Merge data into single Word doc from single Access record

[Guest]

I am building a database to store numerous customer records, each holding
numerous different pieces of data. I am fine with that part of the project.
I will want to use various Word docs (templates) for different purposes,
each of which should pull data from an individual customer file on Access,
i.e. just the current record I am in, producing a certain letter and merging
the relevant data into it. Not a mass mailmerge process.
Just one particular letter at a time, from one particular record.
I am familiar with the concepts of templates and data-merging and have done
some work in the past on ready-built databases, but haven't built these from
scratch myself before.
Could somebody walk me through this please, step by step?
Many thanks
CW

 

[Guest]

Hi CW,

To be honest, it's too big to walk you thru. You will need to do alot of
reading, especially on opening data sources.

You will also need to include Word's and and possibly Office's libraries in
your references to get the MailMerge commands.

To pick a specific record you will have to learn to write WHERE clauses.

If you go thru your object browser after including the Word and Office
libraries, you will see your choices. Click ? you get the info on that
object.

Hope this helps some.

 

[Albert D.Kallal]

I have a excellent step by step here...in fact, I have a whole working
library of code you can use:

you will find it here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Give the sample download a try. (do that....first). If you like what you
see, then read the folwling part

http://www.members.shaw.ca/AlbertKallal/wordmerge/page2.html

 

[Guest]

As you are creating a single word document from one record, rather than
undertaking a mail merge I'd suggest filling bookmarks in the Word template
document with the Access data. I've posted a demo which includes this, along
with merges and filling Word tables and form fields, at:

http://community.netscape.com/n/pfx/forum.aspx?msg=23781.1&nav=messages&webtag=ws-msdevapps


You could use the merge facility in the demo to do what you want if you
wished, but the 'Create Letter' facility in the demo does it with bookmarks.

Ken Sheridan
Stafford, England