Difference between revisions of "Email to Spreadsheet"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
Philip Lacey (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | = Overview = | |
| + | |||
Business Express Platform has the ability to send an email from a spreadsheet of email addresses that has been uploaded to bxp, to all the email addresses in that spreadsheet. | Business Express Platform has the ability to send an email from a spreadsheet of email addresses that has been uploaded to bxp, to all the email addresses in that spreadsheet. | ||
| − | + | ||
| + | |||
| + | = Creating the Excel Spreadsheet = | ||
| + | |||
The Excel spreadsheet must be created exactly as follows:- | The Excel spreadsheet must be created exactly as follows:- | ||
| Line 15: | Line 19: | ||
The spreadsheet does not need a unique name, but the tab must be called ''Sheet1''. | The spreadsheet does not need a unique name, but the tab must be called ''Sheet1''. | ||
| + | |||
The spreadsheet should also only have one column, and should have the title ''Email''. This column is case sensitive. | The spreadsheet should also only have one column, and should have the title ''Email''. This column is case sensitive. | ||
| + | |||
Every cell should be an email address. | Every cell should be an email address. | ||
| + | |||
== Uploading and Sending the Email == | == Uploading and Sending the Email == | ||
| + | |||
Once the spreadsheet is in the correct format we are ready to proceed. | Once the spreadsheet is in the correct format we are ready to proceed. | ||
| − | ''Main Menu | + | ''Main Menu > Communications Centre > HTML Email Sending > Spreadsheet - Send email to a spreadsheet of email addresses'' |
Once you have followed the above path browse to find the spreadsheet. | Once you have followed the above path browse to find the spreadsheet. | ||
| + | |||
Select your spreadsheet and then click upload. | Select your spreadsheet and then click upload. | ||
| + | |||
The email send area will then be displayed. | The email send area will then be displayed. | ||
| + | |||
The email addresses will be stored in the BCC field. | The email addresses will be stored in the BCC field. | ||
https://ww3.allnone.ie/client/client_allnone/timemgmt/rptHours_Project-generateddata.asp field hidden in the background, this ensures that everyone's email address is private to the rest of the recipients. | https://ww3.allnone.ie/client/client_allnone/timemgmt/rptHours_Project-generateddata.asp field hidden in the background, this ensures that everyone's email address is private to the rest of the recipients. | ||
| + | |||
Their will be a count to show the number of email addresses being processed. | Their will be a count to show the number of email addresses being processed. | ||
| Line 46: | Line 58: | ||
The ''To'' address is not required for a spreadsheet send, but can be entered if needed, e.g. to send a copy to yourself. | The ''To'' address is not required for a spreadsheet send, but can be entered if needed, e.g. to send a copy to yourself. | ||
| + | |||
Keep in mind that everyone in the list will see the email address in the ''To'' field if it is included. | Keep in mind that everyone in the list will see the email address in the ''To'' field if it is included. | ||
| + | |||
You then can fill in the ''Subject'' and ''Body'' of the email. | You then can fill in the ''Subject'' and ''Body'' of the email. | ||
| + | |||
Click ''Send'' to send the email to all the email addresses in the spreadsheet. | Click ''Send'' to send the email to all the email addresses in the spreadsheet. | ||
| + | |||
| + | |||
| + | [[Category:Module Specific:Communications Centre]] | ||
| + | [[Category:Topic:Communications]] | ||
Revision as of 14:02, 4 May 2015
1 Overview
Business Express Platform has the ability to send an email from a spreadsheet of email addresses that has been uploaded to bxp, to all the email addresses in that spreadsheet.
2 Creating the Excel Spreadsheet
The Excel spreadsheet must be created exactly as follows:-
If it is not created in a structured way the engine will not process the file.
The spreadsheet does not need a unique name, but the tab must be called Sheet1.
The spreadsheet should also only have one column, and should have the title Email. This column is case sensitive.
Every cell should be an email address.
2.1 Uploading and Sending the Email
Once the spreadsheet is in the correct format we are ready to proceed.
Main Menu > Communications Centre > HTML Email Sending > Spreadsheet - Send email to a spreadsheet of email addresses
Once you have followed the above path browse to find the spreadsheet.
Select your spreadsheet and then click upload.
The email send area will then be displayed.
The email addresses will be stored in the BCC field.
https://ww3.allnone.ie/client/client_allnone/timemgmt/rptHours_Project-generateddata.asp field hidden in the background, this ensures that everyone's email address is private to the rest of the recipients.
Their will be a count to show the number of email addresses being processed.
The To address is not required for a spreadsheet send, but can be entered if needed, e.g. to send a copy to yourself.
Keep in mind that everyone in the list will see the email address in the To field if it is included.
You then can fill in the Subject and Body of the email.
Click Send to send the email to all the email addresses in the spreadsheet.
