Mail Merge Source Data Problem

[Trubble]

Hi,

I was wondering if anyone knows the answer to this.

I'm trying to perform a mail merge from within WORD using data in a named range in EXCEL.

The problem that i'm having is that the data is on the second sheet (Sheet2) and the mail merge doesn't seem to be able to locate it. If I move the data to the first sheet (Sheet1) the mail merge has no problem, but I need to use the second sheet (Sheet2).

Any ideas?

T

[Charlize]

How are you connecting to the source ? Maybe a little more background info of what coding you are using would be helpfull.

Charlize

[Trubble]

Its really straight forward.

Here is a basic example

The data source book1.xls contains two sections of data defined as Sheet1 and Sheet2.

When I try to set up a mail merge using a word document only the data that is called Sheet1 is available.

Any ideas?

T

[lucas]

Are you using code in word to run the mail merge...if so it would probably help if you posted the code....

[Trubble]

All I was doing was using the mail merge helper in word.

I don't have any code for that, thats how simple it is!

I've just kinda resolved this, in Excel I dragged the Sheet2 tab so it was before the Sheet1 tab and it seems to have sorted that problem.

I would like to know if there is another way to get round this problem though.

cheers

T