How do I mail merge using multiple worksheets?
Hi,
I feel you are OK with say, Sheet1. Then close the Word file. Open it
again. Now Word will ask
opening this document will run the following SQL command:
SELECT* Sheet1$
Data from the database will be placed in the document. Do you want to
continue?
Say No
Now you click Open Data Source and browse the Excel file. Select Sheet2.
Regards,
Jaleel
"StarWars" wrote:
I have data in 2 separate worksheets. These 2 worksheets contain a common
column of data. EG(Worksheet A Header - Account No, Name, Job & Worksheet B
Header - Account No, Date of Birth, Address) I would like my mail merge to
contain information from these 2 data sources.
<<AccountNo I am <<Name, living at <<Address.
How do I go about creating this mail merge document?
|