Personal tools

Log in

Changes

From All n One's bxp software Wixi

Jump to: navigation, search

Email to Spreadsheet

123 bytes added, 13:09, 2 January 2016
Uploading and Sending the Email
== Overview ==
Business Express Platform now bxp has the ability to send an email to from a spreadsheet of email addressesthat has been uploaded, to all the email addresses in that spreadsheet.
== Creating the Excel Spreadsheet ==
The = Creating the Excel spreadsheet needs to be created exactly as follows.Spreadsheet =
If it is not The Excel spreadsheet must be created like below the engine will not process the file.exactly as follows:-
[[File:Email_to_spreadsheet.png]]
The spreadsheet can be called anything but the tab must be called ''Sheet1''.
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, this column and should have the title ''Email''. This column is case sensitive.  Every cell should be an email address.
Every cell after this should be an email address.
== 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 you will be asked browse to browse for your find the spreadsheet. 
Select your spreadsheet and then click upload.
You will then be brought to the email send area.
The email send area will then be displayed.  The email addresses will be stored in the bcc BCC field hidden in the background, this ensures . This field is used to ensure 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.  [[File:Email_to_spreadsheet_bcc.png|800px]]  The ''To'' address is not required for a spreadsheet send, but can be entered if needed, e.g. to send a copy to yourself.
Their will be a count to show you the number of email addresses that will be processed.
Keep in mind that everyone in the list will see the email address in the ''To'' field if it is included.
[[File:Email_to_spreadsheet_bcc.png]]
You then can fill in the ''Subject'' and ''Body'' of the email.
A ''To'' address is not required for a spreadsheet send but can be entered if you want to send a copy to yourself.
Keep in mind that everyone in Click ''Send'' to send the list will see email to all the email address addresses in the ''To'' fieldspreadsheet.
You then can fill in your subject and build your email.
Once you are ready click send and the email will send to all the email addresses in the spreadsheet.[[Category:Module Specific:Communications Centre]][[Category:Topic:Communications]]
7,528
edits