Related Topics

Mail Merge , Combine Multiple Rows In One Cell

Mail Merge macro
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


Mail Merge MultiValue ComboBox
I am using Albert Kallal's Mail Merge Module and I LOVE it. Everything is working as normal except for one thing. I have a multi-value combo box where the user can pick multiple space numbers, the data is being written to the correct table and when I use Alberts Merge the SpaceNumbers option is listed under the Insert Merge Fields. When I choose the SpaceNumbers andMerge a document that field is empty.


Open on specific record in mail merge
I've just created a button that uses the RunApp macro to open up a mail merge for our database. Is it possbile through some VBA code to jump to an exact record in the mail merge? So, for example, if I'm on AccountNumber 29 and click the Mail Merge button, the mail merge will open up on AccountNumber 29. Is this possible at all


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


Attach form to a table field?
I am attempting to automate emails using a directory or many to one style mail merge.
The merge needs multiple pdf attachments inserted, and they are specific to each employee referenced in the email.

There is a main table that provides the data for this merge, but also the data for a forms database which is how the pdf's are generated.

Is it possible to put each individual form back into the main table as an OLE object, etc?

My thinking is that I can just make the pdf (or whatever file type it needs to be) another field in the mail merge.


query being used to make mail merge list
I plan on doing a mail merge which will include the case id(s) from the data collected with this query. There are clients who have more than one case id but I only want to send them one letter that lists both cases and I’m not sure how to do that.

Is it something I do within this query, another query or the mail merge document itself.


Get all 'many' records in a one to many relationship to show up in one record or row?
I need one row for a customer that lists all devices for that customer. I have a database with at least two tables: Customer and Device - there is a one to many relationship between them (Customers can have many Devices).

The Device table has the foreign key for the customer table (CompanyID). I want to send a letter to the customers with all their devices listed. A simple query creates multiple rows for each device so a mail merge creates multiple letters for each company, one for each device.

How can I get one row with the customer addressinformation and a list of serial numbers for all the devices related to that company so the mail merge will only create one letter and list all the devices in that letter?


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.


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


combining rows..
I've tried several things I have found around the net, including here. I'm assuming (based on the other code I have tried) this will have to be VBA?

I am trying to combine a cell from different rows in the table.


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.


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 form that merges to certain templates in one click?
I need to create a mail merge that the operators can enter the information that needs to be record and then merge the information in a submit command so it gets logged on a database but also a specific letter type is printed so it can be scanned.

The perfect thing would be to have an entryform they can select the template and then it merges automatically?


Mail merge from from Access to Word
I have an Access database that I created using Access 2007 - I have a problem now I've upgraded to 2010.

Basically, I have a Word Macro enabled document that is linked to a table in my database. I use the mail merge function to export information into a Word document. If I use Word 2007 and Access 2007 together, it works fine. However, if I try the same thing using the 2010 versions, I encounter a problem.

A practical example:

One of my database fields is a list of countries - take Vietnam, as an example. If I export using 2007 Word mail merge, it works perfectly. If I used the 2010 version, instead of getting Vietnam, I get Vietng. The same thing happens to every other field - instead of Nigeria I get Nigeng.

This happens on multiple computers, using multiple OS (Vista & 7), using 32 and 64 bit versions. Has anyone noticed something similar happening, or know if it being mentioned as a bug somewhere


Mail merge into OLE file
Here goes - in my database I have large number of various data. I have created a form to display some of the relevant data (name, city, card number ect.), and I have an icon that is a link to an docx. file docx file with appropriate data form the row using mail merge (or any other method I am not aware of).

I know I can mail merge it, I have done it, however it is time consuming and not so flashy.


Mail merge into OLE file
Here goes - in my database I have large number of various data. I have created a form to display some of the relevant data (name, city, card number ect.), and I have an icon that is a link to an docx. file
Is it possible to instantly populate .docx file with appropriate data form the row using mail merge (or any other method I am not aware of).

I know I can mail merge it, I have done it, however it is time consuming and not so flashy


Creating a conditional mail merge from an parameter query.
I need some directions on how to proceed.

I use an access db that stores our customer info on a mssql backend. I need to be able to create a mail merge based on a customers renewal date. Now I do know how to set parameters in aquery but is there a way I can use a access report to enter a month and day they are set to renew then have it create the mail merge based on their info?

The Layout is faily simple just a renewal notice with what they have on their plan.


Mail Merge and MS Access
I need to be able to create a Mail merge document that uses an updated address list as its data source.

The address list will be imported from (as an .xls or .csv file) the result of an MS Access query. is there a way to do this ? The best solution I have come up with is breaking the problem in two parts - a) generating, and saving the address list in the local file system using a asp.net web form , and then b) selecting this new list as the datasource while creating the mail merge document.


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.


Creating a conditional mail merge from an parameter query.
I need some directions on how to proceed.

I use an access db that stores our customer info on a mssql backend. I need to be able to create a mail merge based on a customers renewal date. Now I do know how to set parameters in a query but is there a way I can use a access report to enter a month and day they are set to renew then have it create the mail merge based on their info?

The Layout is faily simple just a renewal notice with what they have on their plan