Creating a mail merge letter using VBA (1 Viewer)

[w11184]

Hi everyone,

I am having a of trouble doing something which you would probably find really simple but I am pulling my hair out and I am not really having much luck finding and solutions either. Here is my problem, bear with me...

So I basically have a form which the record source is either from a table or query and all I would like to do is to have a button which when pressed will open up a previously created word template and insert all relevant fields into the template. First Name, Last Name, Address etc.

Any help would be much appreciated!

 

[Trevor G]

Is the word template a mail merge document? Have you considered using a report for your mail merge document and then print individual letters from there so everything stays in the database.

Take a look at this link it may help

http://stackoverflow.com/questions/...by-vba-in-access-let-word-open-database-again

There are many threads within the forum that deals with this.