Automate Mail Merge to MS Word?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am one of those. I have very limited knowledge. I have gleamed all that I can from the board, and have just one last idea.
I can get on the click of a button Access to open Word and launch by form letter. But haven't been able to get mail merge to work.
I wrote a Macro in Word that works, but I can't figure out the code to type in Access that once it opens Word and the form letter to then run the macro in Word.
I did a docmd.runmacro "merge", but it is looking at Access for the macro and the macro is in Word.
There must be a way? I think I could make the macro run when the document is opened, but I would like to stay away from that if I can
Here, we are not going to use MS-Word for Address Labels, Form Letters and Mail Merge operations, we will do it in MS-Access. Yes, we will try Mail Merge too.
This topic explains how to start the Mail Merge Wizard from Access and create a direct link between a table or query and a Microsoft Office Word 2007 document. This topic covers the process for writing letters. For step-by-step information about how to set up a mail merge process, see Office Word 2007 Help.
Is there an action in macro's to click the ok so it brings me to the point where to select the file from.
If this is possible, on the next step can a macro action be created to insert the place to get word document from
Actually I have a query and I have designed the letter template in Ms word.
Now I want to filter the query based on the data passed from the access form and merge the filtered data in Ms words mail merge
I have already created my connection to SQL server and populated the dataset but how can I output the dataset to Word.
I have looked on here and can only find information relating to vb6 not the .net framework examples. I understand I will need to use Automation to achieve this any documents or advice would be great.
I created two tables one for client info and one for job info
so the data is separate, I can search through the job info table for jobs and the client list table for clients
I created a query to merge the data so I could import it in microsoft word 2007.
It works fine but the problem is the query is now making duplicates in my client table for all my clients, one for each job #(meaning the client info is repeated for as many different job #'s I have)
why is the query adding the merged data back to the table? I thought query's were just used to filter data into a mergeable format(I tried to mail merge the two tables but it told me to make a query)
Is there a better way to do what I'm trying to do. I want to mail merge two sets of data(the client info table and the job info table(but only one entry from that table)) onto the same page in word.