How do I mail merge using multiple worksheets?

[Guest]

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?

 

[Guest]

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