HELP ME PLEASE!

[Guest]

I am trying to do an email merge - send the same email to multiple recipients
- and am using a Microsoft Excel file as my data source. I have a column in
the file that is name Email and all the email addresses of my clients are
listed there. Everything goes great until the last minute after I complete
the merge and then I use the Electronic Mail button. Nothing happens!
Nothing gets sent. I don't see the email addresses being imported in the To
line of the email I've created. WHAT AM I MISSING? SOMEONE PLEASE HELP ME
WITH THIS ~ I DO NOT WANT TO SEND ONE EMAIL FOR EVERY PERSON IN MY CLIENT
LIST.

Thank you so much!!

 

[john.atkins]

Are there any emails sitting in your outbox? How many entries in your
data source? Have you tried to do the merge with an excel file with
just a few (maybe a dozen) entries to start?

 

[Brian Tillman]

I am trying to do an email merge - send the same email to multiple
recipients - and am using a Microsoft Excel file as my data source.
I have a column in the file that is name Email and all the email
addresses of my clients are listed there. Everything goes great
until the last minute after I complete the merge and then I use the
Electronic Mail button. Nothing happens! Nothing gets sent. I don't
see the email addresses being imported in the To line of the email
I've created. WHAT AM I MISSING? SOMEONE PLEASE HELP ME WITH THIS ~
I DO NOT WANT TO SEND ONE EMAIL FOR EVERY PERSON IN MY CLIENT LIST.

Did you select the range of cells containing the addresses (including the
top title cell) and then change the name field to give the range a name?
(The name field is the field to the left of the formula bar that usually
contains the cell name.) Click "Email", then slide down to the last
address, hold Shift, then click again to select the entire range. Put a
name, like "Email" in the name field and save the spreadsheet. When you do
the mail merge and specify the data source, you'll get to choose the named
range.