Topics Search

Automate Mail Merge to MS Word?

Automate Mail Merge to MS Word?
Views: 54
Is it possible to make a macro to automate this function? If so, how is this done? I want to be able to have this function assigned to a button on my database
Sponsored Links:

Similar posts...


Word Macro - Running one from Access?

Word Macro - Running one from Access? Icon
Seems like everyone is trying to figure out how to automate mail merge from Access to Word.

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

Mail Merge from Access Form To Word Doc

Mail Merge from Access Form To Word Doc Icon
I need to find a way to create a one click button that will select the current record from an access 2007 form and mail merge it with a predefined word 2007 document.From looking around online, I can tell you that I cannot use bookmarks or anything of that sort. It has to be mail merge-able due to the fact that that is how all of our word doc's are already set up. I can't copy it to a word table or excel sheet because we constantly have people in our DB adding to it.

MS-Access and Mail Merge

MS-Access and Mail Merge Icon
When we talk about Address Labels, Form Letters, Mail Merge and so on, the name that comes into our mind is MS-Word, loaded with plenty of functions for the above tasks. It needs a database to provide source data for address labels, Form Letters etc. We can prepare a Table in Word Document and use it for Addresses or attach one from Microsoft Access or other database sources.
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.

Use a table or query as a mail-merge data source

Use a table or query as a mail-merge data source Icon
You can create a mail merge operation by using the Microsoft Word Mail Merge Wizard. This wizard is also available from Microsoft Office Access 2007, and lets you set up a mail merge process that uses a table or query in an Access database as the data source for form letters, e-mail messages, mailing labels, envelopes, or directories.
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.

mailmerge macro

mailmerge macro Icon
I'm trying to build a macro to perform a mail merge. I'm using the macro function and so far can get the macro to begin the mail merge. Access presents me with a pop up box called 'microsoft word mail merge wizard' which then presents you with the window for mail merges.

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

Mail merge for filtered results

Mail merge for filtered results Icon
This is the first time I am trying to do mail merge from access.

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

Merge from Access to Word - Loses Data Source

Merge from Access to Word - Loses Data Source Icon
I have a Microsoft Word Mail Merge document that uses a Microsoft Access query as the data source. A DSN has been setup for the connection. The user clicks a command button and the MS Word Mail Merge document is suppose to appear ready complete the merge. The process usually works great but lately the MS Document seems to be losing the link and needs help to find the data source. Why would this work one day and then the next it needs help re-finding the data source?

Mail Merge VB.NET 2005 DataSet

Mail Merge VB.NET 2005 DataSet Icon
I would like to perform a mail merge between 2005 and Word 2007 using a dataset from my application, so the user doesn't have to touch word they will just be presented with the mail merged data.

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.

Mail Merge w/ data from 2 tables

Mail Merge w/ data from 2 tables Icon
I'm trying to automate letters sent to different clients with certain job information on it.

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.

Mail Merge macro

Mail Merge macro Icon
so I have made a mail merge for my database and it works fine and im happy with it. Now I just need to create a macro so I can create a button on my switch board which allows me to access the mail merge and the send it to the recipitent automatially. The mail merge is formed by a query