Mail Merge and Print Data Only for Forms

O

OfficeNDN

Hello,

I have Office 2003 on my XP system. What needs to be done is this. I have
an accounting record in Excel. I am trying to use the Word mail merge
feature to import the necessary data (vendor name, address, justification,
amount, etc.) from the Excel spreadsheet into a Word document that will print
on pre-printed check request forms that we have here at work. On the Word
document there is text and images that should not print as they will already
be on the pre-printed check request.

Is there a way to print only the data imported using the mail merge and not
print the text and images? I know this is a feature of form fields but I am
not using form fields. The data is coming from an excel spreadsheet that
someone else enters. I guess I could just leave the starting Word document
blank but other people need to see it before the check request is made.
 
M

macropod

Hi,

Simply make a copy of your mailmerge template, delete all the unwanted text, then re-run the mailmerge. You may also want to change
the mailmerge type from letter to catalog/directory.
 
O

OfficeNDN

Thanks for your suggestion. I am sure it will work fine.

macropod said:
Hi,

Simply make a copy of your mailmerge template, delete all the unwanted text, then re-run the mailmerge. You may also want to change
the mailmerge type from letter to catalog/directory.

--
Cheers
macropod
[MVP - Microsoft Word]


OfficeNDN said:
Hello,

I have Office 2003 on my XP system. What needs to be done is this. I have
an accounting record in Excel. I am trying to use the Word mail merge
feature to import the necessary data (vendor name, address, justification,
amount, etc.) from the Excel spreadsheet into a Word document that will print
on pre-printed check request forms that we have here at work. On the Word
document there is text and images that should not print as they will already
be on the pre-printed check request.

Is there a way to print only the data imported using the mail merge and not
print the text and images? I know this is a feature of form fields but I am
not using form fields. The data is coming from an excel spreadsheet that
someone else enters. I guess I could just leave the starting Word document
blank but other people need to see it before the check request is made.
 

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