Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multiple field lines in Excel 2002 mailmerge
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! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Multiple field lines in Excel 2002 mailmerge
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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2002 MailMerge & Access 2002 | Mailmerge | |||
mailmerge from excel with multiple worksheets | Mailmerge | |||
How can I get whole text field from Excel source into MailMerge? | Mailmerge | |||
Mailmerge multiple lines (invoice etc) | Mailmerge | |||
Quickly compile Form Field data from multiple forms in Excel? | Microsoft Word Help |