View Single Post
 
Old 06-05-2018, 12:30 PM
thisperson1 thisperson1 is offline Windows XP Office 2000
Novice
 
Join Date: Jun 2018
Posts: 1
thisperson1 is on a distinguished road
Default Mail merge choosing which location

My spreadsheet columns contain contact info for various companies, and then a column each for several of our locations. So, Mr. Smith, ABC Co, 123 Street, Jonestown, CA 90210, and then HQ, Shipping, Receiving, etc. We currently have Xs in the rows noting that ABC Co relates to HQ and Receiving, while XYZ Co relates to Shipping and Software. In the mail merge Word document is there a way to (1) get it to show the location is HQ when there is just an X in the cell, and (2) do a document for ABC Co for both HQ and a separate one for Receiving?
Reply With Quote