E-Mail Merge from Access to Outlook

T

Todd

I've seen the question asked in other threads, but not answered. Can I do an
e-mail merge using data and e-mail addresses from Access through Outlook?

I am using Office XP.
 
T

Todd Kirby

So I can do an e-mail merge sent to individual e-mail addresses with content
like:

Dear [name],

Your allotment this month is [amount].

Sincerely,

Todd

if I go through Word? Like exporting my fields from Access to Word? Can
you walk me through that?
 
S

Sue Mosher [MVP-Outlook]

Start with Word's Tools | Mail Merge command, select the data source (your
Access table), add merge fields to the document, then merge to email.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Todd Kirby said:
So I can do an e-mail merge sent to individual e-mail addresses with
content
like:

Dear [name],

Your allotment this month is [amount].

Sincerely,

Todd

if I go through Word? Like exporting my fields from Access to Word? Can
you walk me through that?

Sue Mosher said:
Actually, it's done through Outlook *and* Word.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
T

Todd Kirby

I merged to email and it went through each e-mail but I can't see any proof
anything was sent (nothing in my SENT box). How do I know if it worked?

I also tried setting up a folder under my contacts and importing the data
from my Access table into my new contacts list, then doing the merge in
Outlook - but only the first letter of the e-mail address imported. What
could cause that?

Sue Mosher said:
Start with Word's Tools | Mail Merge command, select the data source (your
Access table), add merge fields to the document, then merge to email.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Todd Kirby said:
So I can do an e-mail merge sent to individual e-mail addresses with
content
like:

Dear [name],

Your allotment this month is [amount].

Sincerely,

Todd

if I go through Word? Like exporting my fields from Access to Word? Can
you walk me through that?

Sue Mosher said:
Actually, it's done through Outlook *and* Word.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



I've seen the question asked in other threads, but not answered. Can I
do
an
e-mail merge using data and e-mail addresses from Access through
Outlook?

I am using Office XP.
 
S

Sue Mosher [MVP-Outlook]

One way is to disconnect from the network (or use File | Work Offline in
Outlook). You should then be able to see everything in the Outbox before
it's delivered.

I don't know anything about the import problem.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Todd Kirby said:
I merged to email and it went through each e-mail but I can't see any proof
anything was sent (nothing in my SENT box). How do I know if it worked?

I also tried setting up a folder under my contacts and importing the data
from my Access table into my new contacts list, then doing the merge in
Outlook - but only the first letter of the e-mail address imported. What
could cause that?

Sue Mosher said:
Start with Word's Tools | Mail Merge command, select the data source
(your
Access table), add merge fields to the document, then merge to email.

Todd Kirby said:
So I can do an e-mail merge sent to individual e-mail addresses with
content
like:

Dear [name],

Your allotment this month is [amount].

Sincerely,

Todd

if I go through Word? Like exporting my fields from Access to Word?
Can
you walk me through that?

:

Actually, it's done through Outlook *and* Word.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



I've seen the question asked in other threads, but not answered.
Can I
do
an
e-mail merge using data and e-mail addresses from Access through
Outlook?

I am using Office XP.
 
Top