Mail merge from Excel

[Guest]

Hello
I am trying to use the 2nd worksheet of an Excel spreadsheet for a mail merge, but the mail merge helper only allows me to select the 1st worksheet. I don't want to change the worksheet order because I have another mail merge running from the 1st sheet. Is there a way of selecting the 2nd sheet

Thanks in advance

 

[Paul B]

Jo, see the like below about using Microsoft Excel Worksheet via Converter
to do it. You could also copy the page to a new workbook and use it as your
temporary data source. I have run into problems with using some date in
excel when I try to merge with word and have overcome this by coping the
data to a new workbook and set all the cells to text. For some more
information have a look here.

http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

Hello!
I am trying to use the 2nd worksheet of an Excel spreadsheet for a mail

merge, but the mail merge helper only allows me to select the 1st worksheet.
I don't want to change the worksheet order because I have another mail merge
running from the 1st sheet. Is there a way of selecting the 2nd sheet?

 

[Dave Peterson]

I've always changed the order of the worksheet--it seems to work.

But I think the help says that if you use a range name, you can choose that
range.

I just tried a simple test in Office 2002 and it allowed me to choose by range
name. But it also allowed me to choose the sheet, too--so that wasn't a very
good test.

(You're not using xl2002/word 2002????)