email merge

When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

I have got it working fine with 100 recipients using Excel so I don't think
you'll have to do it all again. I can't see a way to recreate your problem
without your files though, sorry.

"Elizabeth" wrote:

When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

I'm using Publisher 2007 and Excel 2007...and Outlook 2007.

In PUblisher I'm selecting the email merge option and then following the
steps there. I'm not trying to insert any other text.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

OK...when it says "Select email merge output"...right below that it says
'select an email account and send your publication as customized email
messages' When I click on that it only lists the first name on my Excel list
there.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

It appears to me that the email client hasn't been established properly. I
choose send e-mail - send e-mail merge - Merge to E-mail box appears - Select
recipient field from the list - chosen recipients can be previewed - add
subject and send. I am not asked to "Select email merge output" Try opening
Outlook express with some dummy account and choose it as default program for
e-mail under tools and then open Publisher again.

"Elizabeth" wrote:

OK...when it says "Select email merge output"...right below that it says
'select an email account and send your publication as customized email
messages' When I click on that it only lists the first name on my Excel list
there.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

Ian,

When I do that I get the 'select recipient field from the list' Instead of
my Excel spreadsheet I get the first NAME on the Excel spreadsheet. That's
all I can choose. Therefore, it only gets sent to that person. I was under
the assumption that my Excel spreadsheet would appear there for me to select.
The only way that I can see to do this is to input the 300+ names and emails
by hand.

"Ian" wrote:

It appears to me that the email client hasn't been established properly. I
choose send e-mail - send e-mail merge - Merge to E-mail box appears - Select
recipient field from the list - chosen recipients can be previewed - add
subject and send. I am not asked to "Select email merge output" Try opening
Outlook express with some dummy account and choose it as default program for
e-mail under tools and then open Publisher again.

"Elizabeth" wrote:

OK...when it says "Select email merge output"...right below that it says
'select an email account and send your publication as customized email
messages' When I click on that it only lists the first name on my Excel list
there.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

When I do that it says 'select recipient field from the list' and the only
thing that's listed there is the first peson on my Excel list.

"Ian" wrote:

It appears to me that the email client hasn't been established properly. I
choose send e-mail - send e-mail merge - Merge to E-mail box appears - Select
recipient field from the list - chosen recipients can be previewed - add
subject and send. I am not asked to "Select email merge output" Try opening
Outlook express with some dummy account and choose it as default program for
e-mail under tools and then open Publisher again.

"Elizabeth" wrote:

OK...when it says "Select email merge output"...right below that it says
'select an email account and send your publication as customized email
messages' When I click on that it only lists the first name on my Excel list
there.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.

Elizabeth, Scroll down on the task pane and open the "Help with E-mail Merge." I
am not having your issues with Outlook and Publisher. I setup a database with
email addresses and nothing else. The merge worked flawlessly.

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I do that it says 'select recipient field from the list' and the only
thing that's listed there is the first peson on my Excel list.

"Ian" wrote:

It appears to me that the email client hasn't been established properly. I
choose send e-mail - send e-mail merge - Merge to E-mail box appears - Select
recipient field from the list - chosen recipients can be previewed - add
subject and send. I am not asked to "Select email merge output" Try opening
Outlook express with some dummy account and choose it as default program for
e-mail under tools and then open Publisher again.

"Elizabeth" wrote:

OK...when it says "Select email merge output"...right below that it says
'select an email account and send your publication as customized email
messages' When I click on that it only lists the first name on my Excel
list
there.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box,
or text
in the body of an e-mail message in a "mailto" hyperlink in Office
programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first
person
on the list. I recreated the spreadsheet from scratch and the same
thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list
is
there. I don't have a clue what I'm doing wrong here. I don't want to
have
to type in 300+ email addresses by hand.

When I click on that first name I then go to send the emails....THEN...it
tells me that the next name on the list, isn't recognized by Outlook. It's
says,

"If you have used a comma to separate addresses; click Cancel, replace the
commas with semicolons, and then click Send again."

I'm not sure what to do. In my Excel spreadsheet the first field is the
name of the recipient like this...last name, first name. The second field
is the email address. Is this not the proper way to do it?

"Ian" wrote:

When you go to the drop down menu for 'select recipient field from the list'
you should see the heading row of your Excel spreadsheet where you picked the
fields for your message. One of your headings/fields will be the 'E-mail
Address' for each recipient.

"Elizabeth" wrote:

Ian,

When I do that I get the 'select recipient field from the list' Instead of
my Excel spreadsheet I get the first NAME on the Excel spreadsheet. That's
all I can choose. Therefore, it only gets sent to that person. I was under
the assumption that my Excel spreadsheet would appear there for me to select.
The only way that I can see to do this is to input the 300+ names and emails
by hand.

"Ian" wrote:

It appears to me that the email client hasn't been established properly. I
choose send e-mail - send e-mail merge - Merge to E-mail box appears - Select
recipient field from the list - chosen recipients can be previewed - add
subject and send. I am not asked to "Select email merge output" Try opening
Outlook express with some dummy account and choose it as default program for
e-mail under tools and then open Publisher again.

"Elizabeth" wrote:

OK...when it says "Select email merge output"...right below that it says
'select an email account and send your publication as customized email
messages' When I click on that it only lists the first name on my Excel list
there.

"Mary Sauer" wrote:

What version Publisher?

How are you setting up the email?

You cannot specify an address in the Cc box, an address in the Bcc box, or text
in the body of an e-mail message in a "mailto" hyperlink in Office programs
http://support.microsoft.com/kb/916858/en-us
--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com

"Elizabeth" wrote in message
...
When I use my Excel spreadsheet it only sends the email to the first person
on the list. I recreated the spreadsheet from scratch and the same thing
happened. At one point it gives me this drop down box that says 'select
recipient field from the list'....and only the first name on the list is
there. I don't have a clue what I'm doing wrong here. I don't want to have
to type in 300+ email addresses by hand.