Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / August 2004

Tip: Looking for answers? Try searching our database.

Anyway to show column labels in merge?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
justin@case.com - 17 Aug 2004 18:40 GMT
I have an Excel gradebook that merges perfectly in Word, but the
column headings for the subjects need to be included in the merged
document. They are in the first row of the Excel spreadsheet.

Is there anyway to reference them in a Word merge document to
associate the courses names with the grades merged?

Thanks
Peter Jamieson - 18 Aug 2004 10:12 GMT
It isn't completely clear which problem you are encountering here.
a. assuming the column names are the names you use to insert the necessary
MERGEFIELDs in your document, you already have to know them to make those
insertions, and you can therefore insert them manually.
b. but maybe you have the problem where you are doing a Catalog/Directory
merge and only have a singlerow table in your Mail Merge Main Document, and
cannot insert a header without getting a header row for every data row. In
this case, it's probably best to consider doing the merge to an output
document (which you have to do with a Catalog/Directory merge anyway) then
either manually adding a header row or inserting one programmatically.
c. Or if you want something that /looks/ more like your Excel header row
data, you could consider using Edit|Copy in Excel and Paste or Paste Special
in Word to create links to the required cells. However, I'm not sure how
that would actually work in practice unless you pasted as plain text, in
which case you might as well do it manually.

Or maybe it's a different problem, in which case could you spell it out
please?

Signature

Peter Jamieson

> I have an Excel gradebook that merges perfectly in Word, but the
> column headings for the subjects need to be included in the merged
[quoted text clipped - 4 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.