#1
|
|||
|
|||
mail merge multiple recipients per page
I am a public defender and I am trying to automate a cover page for each client i represent each day. I have a table (#1) where I input name, dob, phone#, and charges. The charges that I input are in # format (1, 2, 3, 4, etc) and relate to another table (#2) that I created that has 75 charges separated into code section, title and sentence.
When I mail merge the documents initially, I get a separate document with each client, dob and phone #, along with their charges, i.e. 1-16-62. Ive been trying to figure out how to then incorporate those charges from #2 automatically into each client's charge summary. Right now I have the charges for each client listed, I then individually merge each clients charges, by selecting which recipients (which charges) the client is charged with, I then complete the merge, and then scroll down to the next client and repeat. I am wondering if there is a way to allow me to input the charges manually where a prompt that might ask which recipients and i say charge 1, 16 and 62 which would autopopulate the charges to each client. this is basically what already happens I just want a way to do it all at once instead of individually. I know this is better suited for access but I dont know access. Hope this makes sense |
#2
|
||||
|
||||
Hi bmobrien,
What application are the tables stored in? Could you post a sample of the data (obfuscate anything sensitive)?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
I took the night and decided to learn Access so the problem is pretty much moot, but the tables were both in Microsoft Word and it was basic data in each field, i.e name, dob, phone in #1 and charge, name and sentence in #2
|
#4
|
||||
|
||||
Hi bmobrien,
A mailmerge can only use one data source at a time. Having said that, if the 2nd table had each code, title and sentence bookmarked, your mailmerge could use an INCLUDETEXT field to import the data that correspond to the charges field in your first table.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge to multiple .doc files named after a mergefield | nicnad | Mail Merge | 1 | 02-22-2012 01:59 AM |
Mail Merge Recipients List | TanMan | Mail Merge | 1 | 10-13-2011 06:36 PM |
Continuous page numbers with mail merge? | Jennifer Murphy | Mail Merge | 1 | 08-11-2011 05:27 AM |
Multiple Mail Merge? | imogul | Mail Merge | 1 | 06-24-2011 07:20 PM |
Multipe emails to multiple recipients | BillNugent427 | Outlook | 0 | 03-19-2010 06:52 PM |