Mail Merge using only Access

[Dazed And Confused]

Hi all.
I have some form letters that we send out periodically. I know that I
can perform a mail merge using an Access data source and Word's mail
merge features. But - is there a way to pull off a mail merge using
only Access? This would probably involve a report being the form
letter. I read something about this a long time ago but can't find it
now. Does anyone have any experience with anything like this or know
where I might find something?
Thanks much!
SJ

 

[Guest]

Certainly: Just do it. Make a report. Put the text on it.

There are two advantages to using Word for mail merge
instead of Access reports.

1) Using Word means that the letters can be done in Word
by people who are used to using Word to do letters.

2) Word is a better/easier environment for writing Letters.

I do all my form letters just as Access reports. I only
use Mail Merge when someone else is doing the letters.

Conversely, I only do form letters in Access when I am
the one doing the form letters. When someone else is
doing the letters, I let them use Word.

(david)

 

[timbits35 via AccessMonster.com]

Hi,

I have also used Access for mail merges, using the report as the form letter.
It takes a bit longer to set up because you don't have the advantages of Word
for paragraph aligning and formatting, but once you're done, it works great.

LM