Multiple field lines in Excel 2002 mailmerge

[Dave_C]

This was a successfully run Word/Excel 2002 mailmerge with field names on one line A1, B1, etc. Data began on A2, A3, etc. Very basic mailmerge.

Management now wants multiline field names/headings.
A1, B1, C1 would contain field heading names. Data would start on D1. Blank spaces can be present in any field or line on the heading/field lines. This Excel spreadsheet is also a spreadsheet report. I wanted to use the Excel report as a database and report together. Is there any other way other than copy/paste the data to another spreadsheet to accomodate the format for Word/Excel mailmerge? I get very interesting field names when I insert merge fields such as name, F2, F4 and they are not correct!

 

[Cindy M.]

Hi Dave_C,

This was a successfully run Word/Excel 2002 mailmerge
with field names on one line A1, B1, etc. Data began on
A2, A3, etc. Very basic mailmerge. Management now
wants multiline field names/headings. A1, B1, C1 would
contain field heading names. Data would start on D1.
Blank spaces can be present in any field or line on the
heading/field lines. This Excel spreadsheet is also a
spreadsheet report. I wanted to use the Excel report as
a database and report together. Is there any other way
other than copy/paste the data to another spreadsheet to
accomodate the format for Word/Excel mailmerge? I get
very interesting field names when I insert merge fields
such as name, F2, F4 and they are not correct!

The only suggestion I have, short of linking the data range
to another sheet with a "neutral" set of field names, would
be to put those names in row D and start the data in row E.
You should be able to hide row D. Set a range name for row
D + the data rows and have the mail merge link to that.

As long as you're not using DDE to connect, the range name
should appear as a selection for the mail merge data when
setting up the link.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail