Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a rule in excel... I think
So I have a list of over 1500 people in my database and they all have email
addresses. I want to send an email to all these people so I copy and paste them in to the "to" field in my email. Well it takes them out of excel and puts them in there just fine but it only has a space between the email addresses and not a comma or semi-colon. Is there any way to write a rule in excel that says to put a comma or semi-colon on the end of each email address? Please help, I really do not want to sit there and put semi colons inbetween each email address... That would take FOREVER!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a rule in excel... I think
In a new column enter the formula =A5&";" where A5 is your actual first
record and the column that contains the email address. Then cut and paste to email and Delete the semi-colon at after the last address. "BVZ" wrote: So I have a list of over 1500 people in my database and they all have email addresses. I want to send an email to all these people so I copy and paste them in to the "to" field in my email. Well it takes them out of excel and puts them in there just fine but it only has a space between the email addresses and not a comma or semi-colon. Is there any way to write a rule in excel that says to put a comma or semi-colon on the end of each email address? Please help, I really do not want to sit there and put semi colons inbetween each email address... That would take FOREVER!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a rule in excel... I think
Some of my fields are blank and some of the fields repeat themselves. How do
I get it to delete the duplicated items and how to I get it so that the formula doesn't insert only a semi-colon into the fields that are blank to begin with?? Thanks for the help so far "klswvu" wrote: In a new column enter the formula =A5&";" where A5 is your actual first record and the column that contains the email address. Then cut and paste to email and Delete the semi-colon at after the last address. "BVZ" wrote: So I have a list of over 1500 people in my database and they all have email addresses. I want to send an email to all these people so I copy and paste them in to the "to" field in my email. Well it takes them out of excel and puts them in there just fine but it only has a space between the email addresses and not a comma or semi-colon. Is there any way to write a rule in excel that says to put a comma or semi-colon on the end of each email address? Please help, I really do not want to sit there and put semi colons inbetween each email address... That would take FOREVER!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a rule in excel... I think
Assuming that the formula that BVZ gave you would go into column E, then you
could amend it like this: =IF(OR(A5="",A5=A4),E4,E4&A5&";") When you copy this down it will give you a field which will tag all the other addresses together, so you just need to copy/paste the final cell into the "to" field of your email. This assumes that the addresses in column A are sorted, so it misses out duplicates as well as blanks. You should ensure that E4 is blank. Hope this helps. Pete "BVZ" wrote in message ... Some of my fields are blank and some of the fields repeat themselves. How do I get it to delete the duplicated items and how to I get it so that the formula doesn't insert only a semi-colon into the fields that are blank to begin with?? Thanks for the help so far "klswvu" wrote: In a new column enter the formula =A5&";" where A5 is your actual first record and the column that contains the email address. Then cut and paste to email and Delete the semi-colon at after the last address. "BVZ" wrote: So I have a list of over 1500 people in my database and they all have addresses. I want to send an email to all these people so I copy and paste them in to the "to" field in my email. Well it takes them out of excel and puts them in there just fine but it only has a space between the email addresses and not a comma or semi-colon. Is there any way to write a rule in excel that says to put a comma or semi-colon on the end of each email address? Please help, I really do not want to sit there and put semi colons inbetween each email address... That would take FOREVER!! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a rule in excel... I think
Sorry, it was klswvu who gave you the formula.
Pete "BVZ" wrote in message ... Some of my fields are blank and some of the fields repeat themselves. How do I get it to delete the duplicated items and how to I get it so that the formula doesn't insert only a semi-colon into the fields that are blank to begin with?? Thanks for the help so far "klswvu" wrote: In a new column enter the formula =A5&";" where A5 is your actual first record and the column that contains the email address. Then cut and paste to email and Delete the semi-colon at after the last address. "BVZ" wrote: So I have a list of over 1500 people in my database and they all have addresses. I want to send an email to all these people so I copy and paste them in to the "to" field in my email. Well it takes them out of excel and puts them in there just fine but it only has a space between the email addresses and not a comma or semi-colon. Is there any way to write a rule in excel that says to put a comma or semi-colon on the end of each email address? Please help, I really do not want to sit there and put semi colons inbetween each email address... That would take FOREVER!! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Writing a rule in excel... I think
You could add a helper column with =A1&";" and copy down.
Copy/paste as values and use that for your address list. Or..................... Visit Ron de Bruin's site to learn all you will ever need about emailing from Excel. http://www.rondebruin.nl/sendmail.htm Download the SendMail add-in to make life easy. Gord Dibben MS Excel MVP On Mon, 27 Oct 2008 09:52:02 -0700, BVZ wrote: So I have a list of over 1500 people in my database and they all have email addresses. I want to send an email to all these people so I copy and paste them in to the "to" field in my email. Well it takes them out of excel and puts them in there just fine but it only has a space between the email addresses and not a comma or semi-colon. Is there any way to write a rule in excel that says to put a comma or semi-colon on the end of each email address? Please help, I really do not want to sit there and put semi colons inbetween each email address... That would take FOREVER!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
csv files using Excel 30-99 rule for 2 digit years | Excel Discussion (Misc queries) | |||
add a rule line to excel | Excel Worksheet Functions | |||
How do I solve for complement rule of P(X > or = 4.0) in excel? | New Users to Excel | |||
Excel Rule/Formula | Excel Worksheet Functions |