Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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 06:48 AM.


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