how to mail merge data from two sheets (in one excel workbook) to word
- by nickjohn
i have an excel workbook with this structure
myexcelworkbook.xlxs
course sheet with date and venue
participants sheet with names and addresses
how can i add date, venue, names and addresses from these two sheets of same workbook into word document via mail merge
i tried but it uses only one sheet at a time.
thanks