Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2012, 02:35 PM
bmobrien bmobrien is offline mail merge multiple recipients per page Windows 7 64bit mail merge multiple recipients per page Office 2007
Novice
mail merge multiple recipients per page
 
Join Date: Feb 2012
Posts: 2
bmobrien is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-23-2012, 07:23 PM
macropod's Avatar
macropod macropod is offline mail merge multiple recipients per page Windows 7 64bit mail merge multiple recipients per page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 02-23-2012, 10:31 PM
bmobrien bmobrien is offline mail merge multiple recipients per page Windows 7 64bit mail merge multiple recipients per page Office 2007
Novice
mail merge multiple recipients per page
 
Join Date: Feb 2012
Posts: 2
bmobrien is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 02-23-2012, 10:47 PM
macropod's Avatar
macropod macropod is offline mail merge multiple recipients per page Windows 7 64bit mail merge multiple recipients per page Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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 multiple recipients per page Mail Merge Recipients List TanMan Mail Merge 1 10-13-2011 06:36 PM
mail merge multiple recipients per page Continuous page numbers with mail merge? Jennifer Murphy Mail Merge 1 08-11-2011 05:27 AM
mail merge multiple recipients per page 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft