MailMerge

L

Lauren

H
Having trouble merging from excel into word using data from a 2nd or 3rd sheet within the excel doc. Info always comes form the first. I am assuming I need to be able to enter my own page names when selecting which info needs to be merged ie. rather than having to use 'entire speadsheet'. Is this possible. I have been onto the mvps site already with no luck and have tried naming my various sheets already but am still not able to select them

Any advice would be appreciated!

Lauren
 
F

Frank Kabel

Hi
MS Word does only support getting data from the first
Excel sheet.
-----Original Message-----
Hi
Having trouble merging from excel into word using data
Click to expand...
from a 2nd or 3rd sheet within the excel doc. Info always
comes form the first. I am assuming I need to be able to
enter my own page names when selecting which info needs to
be merged ie. rather than having to use 'entire
speadsheet'. Is this possible. I have been onto the mvps
site already with no luck and have tried naming my various
sheets already but am still not able to select them.
 
A

Arvi Laanemets

Hi

When selecting the source Excel table, in Office2000 you are asked, do you
want to use the entire spreadsheet, or a range. So I suspect it's possible
to use named ranges as sources - but I haven't tried it myself. And possibly
it works with non-dynamic named ranges only.


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)


Lauren said:
Hi
Having trouble merging from excel into word using data from a 2nd or 3rd
Click to expand...
sheet within the excel doc. Info always comes form the first. I am assuming
I need to be able to enter my own page names when selecting which info needs
to be merged ie. rather than having to use 'entire speadsheet'. Is this
possible. I have been onto the mvps site already with no luck and have tried
naming my various sheets already but am still not able to select them.
 
D

Debra Dalgleish

The steps vary for different versions of Excel, but if you select ODBC
as the data source, you can use a named range on any worksheet in the
Excel workbook. In the Mail Merge, after you select your Excel file as a
data source, you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under Tools>Options, General -- add a check mark to
'Confirm Conversion at Open')

There are instructions here, to name a range:

http://www.contextures.com/xlNames01.html

Also, there's Mail Merge information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

and Graham Mayor has information on working with Excel data:

http://www.gmayor.com/mail_merge_labels_with_word_xp.htm#Excel_data
 
P

Paul B

Lauren, see if this will help you

http://www.mvps.org/dmcritchie/excel/mailmerg.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 **
Lauren said:
Hi
Having trouble merging from excel into word using data from a 2nd or 3rd
Click to expand...
sheet within the excel doc. Info always comes form the first. I am assuming
I need to be able to enter my own page names when selecting which info needs
to be merged ie. rather than having to use 'entire speadsheet'. Is this
possible. I have been onto the mvps site already with no luck and have tried
naming my various sheets already but am still not able to select them.
 
Top