Including Excel Column Name with Merged Data

M

Matt

I am trying to merge data from an Excel Spreadsheet to Word. I am
familiar with the process in geneneral, but am having trouble with the
following:

I would like to include the Column Name along with the associated data
I am merging. For example, right now I ask it to merge information
from a Column Labled "Student Grant" and the associated value is $400.

Right now, when I merge the info, it just inserts "$400."

What I would like it to insert is the following, "Student Grant $400."

I have about 20 Columns of data and unless I am able to put in the
Column Name Info, the reports will be just a bunch of numbers without
any associated names which will not do much good.

I have searched Word help, but have not found a solution.

Any help?

Matt
 
D

Doug Robbins

You will need to type the column names into the mailmerge main document.
Then they will appear in each document created by executing the merge.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top