Sending 400 Personalised Emails with Entourage

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3155204489_1340037
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

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

--B_3155204489_1340037
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Sending 400 Personalised Emails with Entourage</TITLE>
</HEAD>
<BODY>
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 t=
his? 
Michael 
 

</BODY>
</HTML>

--B_3155204489_1340037--

Paul
Thu Dec 25 17:31:31 CST 2003

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3155211091_28974024
Content-type: text/plain;
charset="US-ASCII"
Content-transfer-encoding: 7bit

On 12/25/03 1:41 PM, in article
BC109989.4A2B%michael.lee@renoirpartners.com, "Michael Lee"
<michael.lee@renoirpartners.com> wrote:

> 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
>
>
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.

--B_3155211091_28974024
Content-type: text/html;
charset="US-ASCII"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Sending 400 Personalised Emails with Entourage</TITLE>
</HEAD>
<BODY>
On 12=
/25/03 1:41 PM, in article BC109989.4A2B%michael.lee@renoirpartners.com, &qu=
ot;Michael Lee" <michael.lee@renoirpartners.com> wrote: 
 
<BLOCKQUOTE>I want to send the same email to 400 people, with each personalised like D=
ear John, Dear Susan etc. Does anyone know how I can do this? 
Michael 
 
 
</BLOCKQUOTE>You can do an Email merge using Word X's Data Merge Ma=
nager, which will do exactly that. Follow the Help in Word for Data Merge Ma=
nager, choosing to Create--> Form Letters, Data Source-->Office Addres=
s Book, Merge Field (Drag and Drop into Document)-->First_Name, Merge--&g=
t;Query Options (choose categories and/or contacts by name), To Email (as Te=
xt, HTML or as Attachment). 
 
That will send separate email messages to each recipient to your Outbox: th=
ere will be no problem with your ISP's recipient limit. (Or if there is, sen=
d 50 at a time.) Word's Data Merge Manager is pretty fantastic, and has grea=
t integration with Entourage. 
 
 
-- 
Paul Berkowitz 
MVP Entourage 
Entourage FAQ Page: <a href=3D"http://www.entourage.mvps.org/toc.html"><ht=
tp://www.entourage.mvps.org/toc.html></a> 
AppleScripts for Entourage: <a href=3D"http://macscripter.net/scriptbuilders/=
"><http://macscripter.net/scriptbuilders/></a> 
 
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. I=
t's often impossible to answer your questions otherwise. 

</BODY>
</HTML>

--B_3155211091_28974024--

Michael
Fri Dec 26 13:39:59 CST 2003

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3155283599_595629
Content-type: text/plain; charset="ISO-8859-1"
Content-transfer-encoding: 8bit

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

> On 12/25/03 1:41 PM, in article BC109989.4A2B%michael.lee@renoirpartners.com,
> "Michael Lee" <michael.lee@renoirpartners.com> wrote:
>
>> 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
>>
>>
> 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.
>

--B_3155283599_595629
Content-type: text/html; charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Sending 400 Personalised Emails with Entourage</TITLE>
</HEAD>
<BODY>
Hi Paul, 
 
Thanks very much, it’s great to hear there’s a way to do it. Cu=
rrently I’ve got all the info (mailing list) in excel. Is it pretty si=
mple to transfer to word? 
 
Michael 
 
Paul Berkowitz12/25/03 3:31 PMberkowit@spoof_silcom.com 
 
<BLOCKQUOTE>On 12/25/03 1:41 PM, =
in article BC109989.4A2B%michael.lee@renoirpartners.com, "Michael Lee&q=
uot; <michael.lee@renoirpartners.com> wrote: 
 
<BLOCKQUOTE>I want to send=
the same email to 400 people, with each personalised like Dear John, Dear S=
usan etc. Does anyone know how I can do this? 
Michael 
 
 
</BLOCKQUOTE>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--> For=
m 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: th=
ere will be no problem with your ISP's recipient limit. (Or if there is, sen=
d 50 at a time.) Word's Data Merge Manager is pretty fantastic, and has grea=
t integration with Entourage. 
 
</BLOCKQUOTE> 

</BODY>
</HTML>

--B_3155283599_595629--

Paul
Fri Dec 26 20:26:49 CST 2003

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3155308010_696427
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit

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 <michael.lee@renoirpartners.com>
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

> On 12/25/03 1:41 PM, in article BC109989.4A2B%michael.lee@renoirpartners.com,
> "Michael Lee" <michael.lee@renoirpartners.com> wrote:
>
>> 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
>>
>>
> 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.
>

--B_3155308010_696427
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: Sending 400 Personalised Emails with Entourage</TITLE>
</HEAD>
<BODY>
Simpl=
e. 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 &quo=
t;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 mig=
ht find it easiest just to export the Excel file as a Tab-Delimited Text Fil=
e and import that into Entourage using File/Import Contacts. If you are</=
I> concerned with categories and paragraphs in the Notes, then you could get=
my shareware scripts Export-Import Entourage X from 
  
 MacScripter.net   <a href=3D"http://macscripter.net/scriptbui=
lders/"><http://macscripter.net/scriptbuilders/></a> 
 
) 
 
-- 
Paul Berkowitz 
MVP Entourage 
Entourage FAQ Page: <a href=3D"http://www.entourage.mvps.org/toc.html"><ht=
tp://www.entourage.mvps.org/toc.html></a> 
AppleScripts for Entourage: <a href=3D"http://macscripter.net/scriptbuilders/=
"><http://macscripter.net/scriptbuilders/></a> 
 
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. I=
t's often impossible to answer your questions otherwise. 
 
 
<HR ALIGN=3DCENTER SIZE=3D"3" WIDTH=3D"95%">From: Michael Lee <michael.=
lee@renoirpartners.com> 
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,<B=
R>
 
Thanks very much, it’s great to hear there’s a way to do it. Cu=
rrently I’ve got all the info (mailing list) in excel. Is it pretty si=
mple to transfer to word? 
 
Michael 
 
Paul Berkowitz12/25/03 3:31 PMberkowit@spoof_silcom.com 
 
<BLOCKQUOTE>On 12/25/03 1:41 PM, in article BC109989.4A2B%michael.lee@r=
enoirpartners.com, "Michael Lee" <michael.lee@renoirpartners.co=
m> wrote: 
 
<BLOCKQUOTE>I want to send the same email to 400 people, with ea=
ch personalised like Dear John, Dear Susan etc. Does anyone know how I can d=
o this? 
Michael 
 
 
</BLOCKQUOTE>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 Add=
ress 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: th=
ere will be no problem with your ISP's recipient limit. (Or if there is, sen=
d 50 at a time.) Word's Data Merge Manager is pretty fantastic, and has grea=
t integration with Entourage. 
 
</BLOCKQUOTE> 
 

</BODY>
</HTML>

--B_3155308010_696427--

Sending 400 Personalised Emails with Entourage

Re: Sending 400 Personalised Emails with Entourage by Paul

Re: Sending 400 Personalised Emails with Entourage by Michael

Re: Sending 400 Personalised Emails with Entourage by Paul