Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2017, 09:18 AM
TheWalrus TheWalrus is offline Mail Merge query - multiple selected documents from one data source Windows 10 Mail Merge query - multiple selected documents from one data source Office 2016
Novice
Mail Merge query - multiple selected documents from one data source
 
Join Date: Oct 2017
Posts: 1
TheWalrus is on a distinguished road
Default Mail Merge query - multiple selected documents from one data source

Hi, I'm looking to use mail merge for the following but am struggling to find an efficient way (I'm new to mail merge):

I have a suite of documents (say doc A to doc Z) that I need to populate a selection of with slightly different information for each project I am managing.

I have a data source spreadsheet pick list with the information on it in columns 1 to 10. The data source spreadsheet will have the unique project reference in the first column, then the project particulars in the next columns (eg name of supervisor, customer etc).

so, a project comes in and I might need to pick document c,s,u,x & z. each will look up the project particulars from my data source spreadsheet, and return the info into pre-determined data fields in the documents. When this is done I then convert to PDF and they become the Project File.



Whats the right way to do this? Is there a way without individually editing the fields in each of the required documents to look at the new data source?

Thanks for reading, hope I have explained well enough, and you can help
Reply With Quote
  #2  
Old 10-15-2017, 01:28 PM
macropod's Avatar
macropod macropod is offline Mail Merge query - multiple selected documents from one data source Windows 7 64bit Mail Merge query - multiple selected documents from one data source 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

See, for example, the attachment to: https://www.msofficeforums.com/mail-...tml#post120342
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-15-2017, 02:04 PM
macropod's Avatar
macropod macropod is offline Mail Merge query - multiple selected documents from one data source Windows 7 64bit Mail Merge query - multiple selected documents from one data source 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

Cross-posted at: https://www.office-forums.com/thread...query.2350108/
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
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 using HTML Data Source chadnewman Mail Merge 0 09-21-2017 07:14 AM
Mail Merge query - multiple selected documents from one data source Migrating Mail Merge Data Source jameswang Mail Merge 2 06-07-2015 03:03 AM
Mail Merge query - multiple selected documents from one data source Enable Mail Merge Data Source always in same folder alleycat1998 Mail Merge 1 04-10-2013 03:02 AM
Mail Merge data source on network drive Brandi Mail Merge 0 06-13-2010 11:26 AM
Mail Merge query - multiple selected documents from one data source Generating multiple documents from 1 data source themangoagent Word 2 08-14-2009 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:47 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