Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel Worksheet As Source
I need to use an Excel worksheet as a mailmerge source. The header row for the database is on row 5. Rows 1-4 hold critical calculation information and cannot be removed. Is there a way that Word can recognize row 5 as the field information rather than row 1? Jenn -- MaxArk |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel Worksheet As Source
Suppose the data you need is in row 5, column A to row 20 (say) column
H, then you can create a range name that references A5:H20 in the worksheet. Then when you connect from Word you should be able to select that range in the "Tables" dialog that appears, assuming you are using Word 2002 or later. If you are not in a position to insert a range name into the worksheet yourself, there may be another way, but try that first if possible. Peter Jamieson http://tips.pjmsn.me.uk MaxArk wrote: I need to use an Excel worksheet as a mailmerge source. The header row for the database is on row 5. Rows 1-4 hold critical calculation information and cannot be removed. Is there a way that Word can recognize row 5 as the field information rather than row 1? Jenn |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I e-mail an excel worksheet? | Microsoft Word Help | |||
Microsoft Excel Worksheet | Microsoft Word Help | |||
Excel worksheet font changes | Microsoft Word Help | |||
How to assign worksheet as data source?? | Mailmerge | |||
Excel worksheet issue | Microsoft Word Help |