Access Letter

[Guest]

Hi, i have a access database with customer details inputted in it. i need to
write the same letter to all these customers (over 2000) is there any way
with access that i can generate this letter just changing the persons name
and address on the same letter?

 

[Guest]

Hi Grover,

Yes. It's called mailmerge, and you typically use Word in conjunction with
Access to do this.

http://support.microsoft.com/search...&kt=ALL&mdt=0&comm=1&ast=1&ast=2&ast=3&mode=a


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Arvin Meyer [MVP]]

You can write the letter as an Access report or as a Word mailmerge. The
advantage to using Word is that you can more easily format the body of the
letter.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[david epsom dot com dot au]

You can write the letter as an Access report or as a Word mailmerge. The
advantage to using Word is that you can more easily format the body of the
letter.

Or, even more critically, the advantage of using Word is
that <somebody else> can easily format the body of the
letter.

If I have to format the letter myself, my unfamiliarity
with Word balances against any putative advantages.

(david)

 

[Arvin Meyer [MVP]]

Or, even more critically, the advantage of using Word is
that <somebody else> can easily format the body of the
letter.

Which could also be a disadvantage, assuming the file is emailed instead of
snail mailed.

If I have to format the letter myself, my unfamiliarity
with Word balances against any putative advantages.

That's not what the Microsoft Usability Lab wants to hear Seriously,
Word is a bit easier to format as a letter than creating a letter as an
Access report, but the mailmerge is more complex to set up. If I can, I
always use the Access report. If I need to change fonts, bold a portion of
the text, or allow the user to add something to the document, I use Word. I
also usually print to a PDF no matter which way I go so that I can be sure
that anyone without MS-Office (are there any of those any more) can view and
print the document.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access