Mail Merge

  • Thread starter Thread starter PL
  • Start date Start date
Hi

Thank you for the reply.

But as a beginner I am still confused.

I understand that we can perform Mail Merge in Word using datasource from
Excel, Access, Outlook, but can we do Mail Merge in Access? That is Access is
the main document?

Thanks
 
PL.

There is no *document* in Access. There are reports which you could set up
to *act like* a mail merge. However, there are limitations, as reports were
not designed to be editable via the End-User. (Reports in Access are more
like images, uneditable.) So you would have to create a table that would
hold your paragraphs so that the end user could modify those. But then
there's the problem if you decide to have words merge within a paragraph.
Create a form to allow for a choice of Signatures, Closings, Post Scripts,
CC's, BCC's. Attachements, etc...

All-in-all it *could* be done but not sure I would even want to because of
all the features available in Word with far less work. And with Albert's
code it makes merging with Access data so seemless.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
Hi

Thank you.

But then how do I run the code?

And is Mail Merge in Access a common thing?

Thanks
 
Back
Top