insert merge code in excel document

I want to set up a checklist to use for auditing activities. I will print
out a sheet for each company. however, I want to insert the name of the
company at the top of each sheet. Can i insert a merge code in the header of
an excel document.
Thank you.
--
bsp131

AFAIK, you cannot use mail merge with Excel. However, if you are printing
these sheets, I do not see why you could not use a table in Word for the
purpose.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"bsp131" wrote in message
...
I want to set up a checklist to use for auditing activities. I will print
out a sheet for each company. however, I want to insert the name of the
company at the top of each sheet. Can i insert a merge code in the header
of
an excel document.
Thank you.
--
bsp131

Thanks. Is there a way for me to use the completed Excel worksheet without
cutting and pasting.
--
bsp131


"Doug Robbins - Word MVP" wrote:

AFAIK, you cannot use mail merge with Excel. However, if you are printing
these sheets, I do not see why you could not use a table in Word for the
purpose.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"bsp131" wrote in message
...
I want to set up a checklist to use for auditing activities. I will print
out a sheet for each company. however, I want to insert the name of the
company at the top of each sheet. Can i insert a merge code in the header
of
an excel document.
Thank you.
--
bsp131

I think cutting and pasting is going to be the simplest thing for you to do.

The only other alternative that I can think of is to use a macro in Excel
that would iterate through a list of the company names, to insert them one
at a time into the desired cell on the worksheet and print it out.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"bsp131" wrote in message
...
Thanks. Is there a way for me to use the completed Excel worksheet without
cutting and pasting.
--
bsp131


"Doug Robbins - Word MVP" wrote:

AFAIK, you cannot use mail merge with Excel. However, if you are
printing
these sheets, I do not see why you could not use a table in Word for the
purpose.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"bsp131" wrote in message
...
I want to set up a checklist to use for auditing activities. I will
print
out a sheet for each company. however, I want to insert the name of
the
company at the top of each sheet. Can i insert a merge code in the
header
of
an excel document.
Thank you.
--
bsp131