I am trying to create a mail merge using the data in two tables. The first table contains the Vendor No and the corresponding e-mail address. The second table contains the Vendor No with the Customer Number(s) they assigned to us.
I understand how to do the mail merge with the first table, but then I want the e-mail to include a reference to the Customer Numbers from the second table. (If there was only one Customer Number associated with each Vendor No I could simply move it all on one page, but a single Vendor could have 50+ Customer Numbers.)
Any trick in excel?
I understand how to do the mail merge with the first table, but then I want the e-mail to include a reference to the Customer Numbers from the second table. (If there was only one Customer Number associated with each Vendor No I could simply move it all on one page, but a single Vendor could have 50+ Customer Numbers.)
Any trick in excel?