Home » Questions » Computers [ Ask a new question ]

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

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

Hi have an excel workbook with this structure:

Asked by: Guest | Views: 303
Total answers/comments: 1
bert [Entry]

"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."