Email to Spreadsheet - Revision history

Philip Lacey: /* Uploading and Sending the Email */

2016-01-02T12:09:38Z

‎Uploading and Sending the Email

Philip Lacey at 13:04, 4 May 2015

2015-05-04T13:04:51Z

Philip Lacey at 13:02, 4 May 2015

2015-05-04T13:02:40Z

Philip Lacey at 12:56, 14 April 2015

2015-04-14T12:56:43Z

Philip Lacey at 12:56, 14 April 2015

2015-04-14T12:56:27Z

Philip Lacey at 12:55, 14 April 2015

2015-04-14T12:55:45Z

Philip Lacey at 12:54, 14 April 2015

2015-04-14T12:54:12Z

Philip Lacey at 14:35, 1 April 2015

2015-04-01T14:35:42Z

Philip Lacey at 14:30, 1 April 2015

2015-04-01T14:30:11Z

Philip Lacey at 13:51, 1 April 2015

2015-04-01T13:51:46Z

← Older revision		Revision as of 12:09, 2 January 2016
Line 51:		Line 51:


−	[[File:Email_to_spreadsheet_bcc.png]]	+	[[File:Email_to_spreadsheet_bcc.png\|800px]]

@@ Line 1: / Line 1: @@
 = Overview =
+bxp has the ability to send an email from a spreadsheet of email addresses that has been uploaded, to all the email addresses in that spreadsheet.
@@ Line 46: / Line 45: @@
-The email addresses will be stored in the BCC field.
+The email addresses will be stored in the BCC field.  This field is used to ensure that everyone's email address is private to the rest of the recipients.

@@ Line 1: / Line 1: @@
-== Overview ==
+= 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.
-== Creating the Excel Spreadsheet ==
 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 should also only have one column, and should have the title ''Email''. This column is case sensitive.
 Every cell 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''
+''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.
@@ 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.
 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.

@@ Line 2: / Line 2: @@
 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:-
 [[File:Email_to_spreadsheet.png]]
 If it is not created in a structured way the engine will not process the file.

@@ Line 6: / Line 6: @@
 == Creating the Excel Spreadsheet ==
-The Excel spreadsheet needs to be created exactly as follows:-
+The Excel spreadsheet must be created exactly as follows:-
 [[File:Email_to_spreadsheet.png]]

@@ Line 1: / Line 1: @@
 == Overview ==
-Business Express Platform now has the ability to send an email to a spreadsheet of email addresses.
+Business Express Platform has the ability to send an email from a spreadsheet of email addresses.
@@ Line 8: / Line 8: @@
 The Excel spreadsheet needs to be created exactly as follows.
-If it is not created like below the engine will not process the file.
+If it is not created in a structured way the engine will not process the file.
 [[File:Email_to_spreadsheet.png]]
-The spreadsheet can be called anything 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 only have one column, this column should have the title ''Email''. This is case sensitive.
+The spreadsheet should also only have one column, and should have the title ''Email''. This column is case sensitive.
-Every cell after this should be an email address.
+Every cell should be an email address.
@@ Line 28: / Line 28: @@
-Once you have followed the above path you will be asked to browse for your spreadsheet.
+Once you have followed the above path browse to 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 field hidden in the background, this ensures that everyone's email address is private to the rest of the recipients.
+The email addresses will be stored in the BCC field.
-Their will be a count to show you the number of email addresses that will be processed.
+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.
@@ Line 42: / Line 44: @@
-A ''To'' address is not required for a spreadsheet send but can be entered if you want 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.
+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 your subject and build your email.
+You then can fill in the ''Subject'' and ''Body'' of the email.
-Once you are ready click send and the email will send to all the email addresses in the spreadsheet.
+Click ''Send'' to send the email to all the email addresses in the spreadsheet.

← Older revision		Revision as of 14:35, 1 April 2015
Line 13:		Line 13:
	[[File:Email_to_spreadsheet.png]]		[[File:Email_to_spreadsheet.png]]

		+	The spreadsheet can be called anything but the tab must be called ''Sheet1''.

	The spreadsheet should only have one column, this column should have the title ''Email''. This is case sensitive.		The spreadsheet should only have one column, this column should have the title ''Email''. This is case sensitive.

← Older revision		Revision as of 13:51, 1 April 2015
Line 1:		Line 1:
−	= Overview =	+	== Overview ==

	Business Express Platform now has the ability to send an email to a spreadsheet of email addresses.		Business Express Platform now has the ability to send an email to a spreadsheet of email addresses.
		+
		+
		+	== Creating the Excel Spreadsheet ==
		+
		+	The Excel spreadsheet needs to be created exactly as follows.
		+
		+	If it is not created like below the engine will not process the file.
		+
		+	[[File:Email_to_spreadsheet.png]]
		+
		+	The spreadsheet should only have one column, this column should have the title ''Email''. This is case sensitive.
		+
		+	Every cell after this should be an email address.
		+
		+
		+	== Uploading and Sending the Email ==