Mail Merge

[natalietate via AccessMonster.com]

I have a Form that is comes from a query. the query comes from two tables
that share a relationship. I have a button on my form that opens a word
document. I linked the query to the word document, when I first made the form,
i would open the form find the record i want to merge, click the button to
open the word document, click Merge to New Document on the toolbar, ether the
record number and it would work. Now when I try to merge a record the record
number is like 10 off and I can't understand why. For instances, if I find he
name Brett Jones on my form, I look down and his record # is 220. when i try
to used the mail merge to merge the record and put the record # 220, a
different name comes up. I'm having a hardtime figuring out this problem.
Please help.

 

[Steve Schapel]

Natalie,

It sounds like your records have an ID number of some sort. This is
probably an AutoNumber field. The value of this field is what the Word
merge document will be using to identify its data source. This is
correct. The value of this ID field is not the same as the record
number shown at the bottom of the form in the Navigation Button. This
number for given record will depend on a various factors, such as the
order of the records at the time, any filtering, records deleted, etc,
and as such it is not useful for identifying records, and will not
correspond with anything that the Word merge can use. If you are being
asked to enter the number for the record you want merged, you will need
to use the ID number, not the record number.

 

[Albert D. Kallal]

I have a sample word merge routine that will automatically merge the CURRENT
ONE record to word...

It is does this for any form you have, and you can do this with one line of
code...

Try my sample super easy word merge here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

If the above sample (which has a form + data) works good for you, then you
can follow the instructions on how to use this for your applications

IF you do the above, then simply placing a button on ANY form you have with
one line of code

MergeSingelWord

and, presto...you have a instant word merge system....