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?

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?