Topics Search

Automate Mail Merge to MS Word?

Automate Mail Merge to MS Word?
Views: 48
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:

More topics


Word Macro - Running one from Access?

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

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

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

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

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

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

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

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

I have a query which list the visitors to a compound with a given date. I want to send their names and addresses over to ms word in a mail merge. can someone

Mail Merge w/ data from 2 tables

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.