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?

Hi Grover,

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

http://support.microsoft.com/search/...2&ast=3&mode=a


Tom

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


"Grover" wrote:

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

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

"Grover" <(E-Mail Removed)> wrote in message
news:087E0A1D-3A6F-4468-99BE-(E-Mail Removed)...
> 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?

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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, MCP, MVP
> Microsoft Access
> Free Access downloads
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Grover" <(E-Mail Removed)> wrote in message
> news:087E0A1D-3A6F-4468-99BE-(E-Mail Removed)...
>> 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?
>
>

"david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
news:(E-Mail Removed)...
>
> "Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.

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