Mail Merge from Excel - multiple names not mult sheets?
by hockeyroom28 - 12/24/07 9:51 AM
Here is what I have setup:
Excel spreadsheet with a list of names, hours worked, billed rate, and total paid. That is 1 sheet, there are 10+ sheets exactly like this but for different facilities. These sheets are formatted with company graphics at the top, among other formatting (colored lines, date, etc).
Word Invoice with company heading/graphics at the top and then a table that has the same fields (name, hours worked, billed rate, total paid).
Is there a way to use Mail Merge (or something else) to input the information from the Excel sheet onto the Word Invoice?
Using Office 2003 on Windows XP Home SP2.