Topics Search

Mail Merge , Combine Multiple Rows In One Cell

Mail Merge ,  Combine Multiple Rows In One Cell
Views: 12
in the screenshot you see the query.

as you see there are 3 rows of customer 1
this is because customer1 has multi products.

some how I need to have one row and a cell that the product en price etc is in it.

why.

well if you mail merge with publisher for every row it make's a new page.
so customer1 get 3pages and it should be one.

gr.
Attached File(s)
Untitled.png ( 98.52K ) Number of downloads
Sponsored Links:

More topics

 

Mail Merge macro

Preview
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

Preview
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

Preview
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

Preview
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?

Preview
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

Preview
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?

Preview
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

Preview
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

Preview
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..

Preview
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.