mail merge to Word

[scubadiver]

Hi folks

I have a parameter query that is being used as the source for a mail merge
document. On the form I have a command button that opens the document but it
won't automatically merge when it opens.

I posted this query on the "Word" form and was directed to the following

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

I downloaded the 2000v example but it seems a bit over the top for something
that may (or may not be) apparently straightfoward.

Cheers

 

[Albert D. Kallal]

there is certainly a "bit" of code in my example.

however, if you follow the examples step by step, you don't have to read, or
care about the code....

If you following the step by step, then all you need do is place a button on
the form.

The code in the button is:

MergeSingleWord


That one command button will thus merge the ONE record for you. The bonus
part is that you can select from a list of templates....

If you goal is to merge the current reocrd..and you don't want to write any
code..then that example is rather nice....

The steps to install are here:

http://www.members.shaw.ca/AlbertKallal/wordmerge/Details.htm

do make a back up copy of yoru appcation before you try any of the above...

It is likey "more" code then you need..but, then again..don't try and read
the code...it not that nice!!!!!

 

[scubadiver]

Thank you Albert!

Its just that I only need one template so wouldn't it be possible to adapt
the code?

David

 

[scubadiver]

Well that wasn't so painful. Very practical and certainly very useful.

I created the document and made it the default option in the list, and then
I transferred the merge code from the button to the form "on load" event.

cheers.

 

[scubadiver]

Hello Albert

I need your help

I am now using your code on a second database but this one is slightly more
complicated because the information source is based on two tables with a 1:m
relationship. Each job title has many job descriptions and I only want those
job descriptions for a particular job title.

The button I am using to run "MergeSingleWord" is on a form that has the
titles and a subform that has the descriptions. I don't know whether you
intended your code for something this complicated????

I have set up the word document the way I want it and saved it. When I
reopen the document I get the following message:

"Opening this document will run the following SQL command:
SELECT * FROM 'Report Query'
Data from your database will be placed in the document. Do you want to
continue?"

I click "No" but then I lose the query source in the document and I have to
find it again.

Question 1. Would you be able to tell me what is going on?

Question 2. I would like to know how to retrieve those job descriptions for
a particular job title.

thanks