Software

Ask something
Discussion Locked

Mail Merge- Multiple records

0 helpful
9 replies

by nicholasp

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

here is my situation:

I need to create a mail merge. The data will have the client name and a transfer request. One client may have multiple client requests.

I am trying to create a word mail merge letter that will allow me to print the clientinformation and then each transfer request .

I cannot use an Access report because the letter will probably need minor massaging. Is there a way to put the multiple transfers on one mail merge letter? I am using office 97

thanks

9 replies

by jmgesd

I am assuming you have your data (client info and transfer requests) in Access already? If so, you can use Word's mail merge function and using the Access database as your data source for the merge. You can insert multiple merge fields into a Wordletter, and as long as you have uniquely identified your data in Access (given each client request its own column, or defined relationships between tables in Access) it should be pretty smooth.

by seagull data services

The lazy way out 8o)
In Access, create a blank table with the client info already in it (use create table)
Add a memo field
Write the sub data to the memo field for each client
Merge the result into your letter

by sankulpune

Hello nicholasP,

I have written the VBA code for multiple records mailmerge.

But it can not be posted because its size (5260) far exceeds the allowable limit(1960).

I would send you the code if you let me know your e-mail address (at kulkarnisan@yahoo.com)

SanganakSakha,
Simple And Effective Solutions To Small Problems, No QuickFixes.

by nicholasp

I need to edit some fields sometimes, so the letter cannot be an access report.

my e-mail address is nicholas@psarros.com

This discussion is closed to new replies.