Email Merge???

  • Thread starter Thread starter Ksean
  • Start date Start date
K

Ksean

Since Microsoft Word and Microsoft Excel can be used together to do a "Mail
Merge" can Microsoft Outlook and Microsoft Excel be used to do an "Email
Merge"???
 
I have an Excel database full of information (approx. 400 recipients) and I
would like email merge it and send it out by email, currently I have to do it
one at a time is there any way to automate it?

Basically I am wanting to email financial receipts for a community level
indoor soccer league to around 400 players.

As a volunteer I am not being paid to do this so I am trying to find an
easier way to issue the receipts rather than one email at a time.

Ksean


Diane Poremsky said:
You could use excel as the data source and merge to word, then send by
email... you can't use excel as the merge document.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Exchange server do you use?
http://forums.slipstick.com/showthread.php?t=33803

Ksean said:
Since Microsoft Word and Microsoft Excel can be used together to do a
"Mail
Merge" can Microsoft Outlook and Microsoft Excel be used to do an "Email
Merge"???
Click to expand...
Click to expand...
 
That's what Diane was telling you. Outlook and Word do the merge to
Electronic Mail, but you can set your Excel database as the source for the
email addresses. The Help files tell you how, so do many good websites:
http://www.gmayor.com/merge_labels_with_word_2007.htm
--
Russ Valentine
Ksean said:
I have an Excel database full of information (approx. 400 recipients) and I
would like email merge it and send it out by email, currently I have to do
it
one at a time is there any way to automate it?

Basically I am wanting to email financial receipts for a community level
indoor soccer league to around 400 players.

As a volunteer I am not being paid to do this so I am trying to find an
easier way to issue the receipts rather than one email at a time.

Ksean


Diane Poremsky said:
You could use excel as the data source and merge to word, then send by
email... you can't use excel as the merge document.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Poll: What version of Exchange server do you use?
http://forums.slipstick.com/showthread.php?t=33803

Ksean said:
Since Microsoft Word and Microsoft Excel can be used together to do a
"Mail
Merge" can Microsoft Outlook and Microsoft Excel be used to do an
"Email
Merge"???
Click to expand...
Click to expand...
Click to expand...
 
Back
Top