Excel – How to mail merge 2 excel sheets in same workbook, to word

mail-mergemicrosoft excelmicrosoft word

Hi have an excel workbook with this structure:

  • course sheet with date and venue
  • participants sheet with names and addresses

How can I add the date, venue, names and addresses from these two sheets of the same workbook into a Word document, using Mail Merge? I can only get it to use one sheet at a time.

Best Answer

Mail Merge can only support 1 flat file at a time. You can structure and write complicate VB scripts to attempt to pull from multiple sources, but it is infinitely faster for you to just create a new worksheet and paste data from both sources into it, thereby creating a single file.

You could always use the lookup function if you need to address corresponding course data to individual participants.

Related Question