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?
|