By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,171 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Another Mail Merge Question

P: n/a
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 ***
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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 ***
Nov 13 '05 #2

P: n/a
Once you've done one really basic merge, check out Albert Kallal's mail
merge code.

Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.