email merge with excel spreadsheet

[Elizabeth]

I wanted to conduct a little test and I did this:

I created an Excel spreadsheet that consisted of four names, first and last
separated by a comma and an email address for each name. I saved it and then
tried to use it for an email merge. It was only sent to the first name on
the list. Why?

 

[Mary Sauer]

Don't know why. I did the same experiment and it worked for me. How are you
setting up your page? You can only have one merge document on your screen, for
example, a label.

 

[Elizabeth]

I'm still having the same problem. When I select the Excel spreadsheet that
I want to use it gives me this:

"Select Table" and then underneath "Name" it lists three 'names' I guess:

Sheet1$
Sheet2$
Sheet3$

I select sheet 1. I don't know what these 'sheets' are referring to and it
won't allow me to select all three. It then takes me to a window where I can
only see the first name on my list...and THAT is the only person who will
receive the email. I don't know what I'm doing wrong. IS there a specific
way that I'm supposed to set up my Excel spreadsheet?

 

[Mary Sauer]

Maybe there is help here
Send e-mail
http://office.microsoft.com/en-us/publisher/CH062524821033.aspx

Have you tried to send the email from your email program?

You will always get your message from Excel when you merge. Usually it will be
the first sheet. You could try to save the data as CSV.