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.