Another Mail Merge Question

[Susan Bricker]

Greetings. I've been searching for some guidance in how to merge data
from a table to a document template in VBA behind an Access Project that
I'm working on, but many of the posts assume some sort of prior
knowledge. But I have none where mail merge is concerned. So...

Would you be able to point me to a very good basic resource where I will
be able to learn how to take information from a table and merge it into
a Word Doc template?

Specifically, I want to generate a customized form letter for every
record in a recordset created as a result of a query (will need to get
info from more than one table). Of course, I will be filling in first
name, last name, date, address, city, state, ... (you get the picture).
The act of creating the letters will be behind a command button on a
form.

I'm looking for some good instruction (or sample code). Thanks very
much.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

[David Lloyd]

Susan:

The following KB article is related to what you are attempting to do. This
article uses a blank Word document, but you could easily adapt it to open a
template that already has the document and fields defined.

http://support.microsoft.com/default...b;en-us;209882

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"Susan Bricker" <sl*****@verizon.net> wrote in message
news:5R***************@news.uswest.net...
Greetings. I've been searching for some guidance in how to merge data
from a table to a document template in VBA behind an Access Project that
I'm working on, but many of the posts assume some sort of prior
knowledge. But I have none where mail merge is concerned. So...

Would you be able to point me to a very good basic resource where I will
be able to learn how to take information from a table and merge it into
a Word Doc template?

Specifically, I want to generate a customized form letter for every
record in a recordset created as a result of a query (will need to get
info from more than one table). Of course, I will be filling in first
name, last name, date, address, city, state, ... (you get the picture).
The act of creating the letters will be behind a command button on a
form.

I'm looking for some good instruction (or sample code). Thanks very
much.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

[pietlinden]

Once you've done one really basic merge, check out Albert Kallal's mail
merge code.

[pietlinden]

Here's the link to Albert's site.
http://www.members.shaw.ca/AlbertKal.../msaccess.html

look for "Super Easy Word Merge". He has instructions, and I *think*
the code is open so you can examine/modify it if you want.