mailmerg current record from a Access form to Word

[Pierkes]

Hi,

I'am having a problem with merging just one record with a Word doc.
In Access i have a multipage (3 tabs) displaying just one record. On the
first page (tab) i have a combobox which is used to select a record from the
database. All the fields(75) are then displayed on the pages(tabs) of the
multipage.

I have a button called "merge" with which i would like to be able to;
1. Open word and open a certain letter (c:\data\DBM\testletter.doc) in which
i have put mergefields (I connected the letter to the database of the form)
2. Then merge only the current record (which is displayed on the multiform)
with the letter

Can anyone help me with the VBA code for the "merge" button please?

Thanks,
Jean-Pierre

 

[Tom Wickerath]

Hi Jean,

Check out Access MVP Albert Kallal's free download:

Super Easy Word Merge
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

It's about half way down the page, when using the verticle scroll bar.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________