Sending 400 Personalised Emails with Entourage

M

Michael Lee

I want to send the same email to 400 people, with each personalised like
Dear John, Dear Susan etc. Does anyone know how I can do this?
Michael
 
P

Paul Berkowitz

I want to send the same email to 400 people, with each personalised like Dear
John, Dear Susan etc. Does anyone know how I can do this?
Michael
Click to expand...
You can do an Email merge using Word X's Data Merge Manager, which will do
exactly that. Follow the Help in Word for Data Merge Manager, choosing to
Create--> Form Letters, Data Source-->Office Address Book, Merge Field (Drag
and Drop into Document)-->First_Name, Merge-->Query Options (choose
categories and/or contacts by name), To Email (as Text, HTML or as
Attachment).

That will send separate email messages to each recipient to your Outbox:
there will be no problem with your ISP's recipient limit. (Or if there is,
send 50 at a time.) Word's Data Merge Manager is pretty fantastic, and has
great integration with Entourage.


--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/toc.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - 2001 or X.
It's often impossible to answer your questions otherwise.
 
M

Michael Lee

Hi Paul,

Thanks very much, it¹s great to hear there¹s a way to do it. Currently I¹ve
got all the info (mailing list) in excel. Is it pretty simple to transfer to
word?

Michael

Paul Berkowitz12/25/03 3:31 PMberkowit@spoof_silcom.com
 
P

Paul Berkowitz

Simple. When using the Data Merge Manager, when you get to the second step
"Data Source/Get Data", don't choose Office Address Book but rather "Open
Data Source" and choose your Excel file. Voilà!

(If you want to get your data from the Excel file into Entourage, if you're
not concerned with categories or separate lines in the Notes, you might find
it easiest just to export the Excel file as a Tab-Delimited Text File and
import that into Entourage using File/Import Contacts. If you are concerned
with categories and paragraphs in the Notes, then you could get my shareware
scripts Export-Import Entourage X from

MacScripter.net <http://macscripter.net/scriptbuilders/>

)

--
Paul Berkowitz
MVP Entourage
Entourage FAQ Page: <http://www.entourage.mvps.org/toc.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Entourage you are using - 2001 or X.
It's often impossible to answer your questions otherwise.



From: Michael Lee <[email protected]>
Newsgroups: microsoft.public.mac.office.entourage
Date: Fri, 26 Dec 2003 11:39:59 -0800
Subject: Re: Sending 400 Personalised Emails with Entourage

Hi Paul,

Thanks very much, it¹s great to hear there¹s a way to do it. Currently I¹ve
got all the info (mailing list) in excel. Is it pretty simple to transfer to
word?

Michael

Paul Berkowitz12/25/03 3:31 PMberkowit@spoof_silcom.com
 
Top