Unless you are prepared to develop your own vba solution, you must set the
account you wish to use as your default account before running the merge. An
alternative (at a price) would be to use MAPILab's Mailmerge toolkit add-in
for Outlook http://www.mapilab.com/outlook/mail_merge/ which gives you the
option to choose the account.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"aedcone" wrote in message
...
Thanks Doug. I got as far as the pop-up window, typed in the text into
the
subject field for the email and selected the format for the message click
on
finish. and it did work... My only problem is that I have multiple (6)
email accounts and the email account that is sending out these emails is
not
the correct account. Is there a way to be sure that the email is being
sent
from the correct account?


"Doug Robbins - Word MVP" wrote:

Sorry, I missed the Email in the title of your original message.

If you have the e-mail addresses in the data source, you can then execute
the merge to E-mail in which case, the Merge to E-mail dialog box will
appear in which you can select the field in the data source that contains
the e-mail addresses and enter a Subject line to be used in the messages
and
select the format for the messages.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"aedcone" wrote in message
...
I went into Outlook and created a new contacts list based on the emails
in
my
Excel file. I successfully merged... the downside is the following:
1. subject field of the email was blank (no text)
2. the email address was from the wrong email account

How to I rectify the above?

"aedcone" wrote:

I am the event secretary for a dog club. I receive entries for our
shows.
I
have created an Excel file that will be used as my data source. With
this
being said, I would like to to know how to do the following, as I am
not
quite understanding/following the nuances of Word 2007 when it comes
to
mail
merge:

How do I send an email that contains specific information grabbed from
my
Excel data source. The specific information will be sent to only a
specific
personal, not everyone in my data source; i.e.: XXXX has entered her
dog
named XXXX, whose registration number is XXXX, in class XXXX, show
XXXX.
How
do I set this up?