Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
    
It really depends how the rows of courses relates to the rows of participants. Does everyone on the participant sheet belong to every venue & date on the course sheet? Or only certain participants for certain courses? In either case, you need to combine in a third spreadsheet or migrate the whole thing to an Access database (or similar) and build a query or report that combines the separate tables appropriately. –  micahwittman Dec 18 '09 at 20:21

2 Answers 2

up vote 0 down vote accepted

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.

share|improve this answer

I think Word needs a single table of data for a mail merge.

If you can't simply combine the two sheets, you could try adding a third sheet with lookup formulas to present the data from your two sheets in a single table format (one line of data per document).

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.