How do I remove a data source froma document

B

BannermanService

I want to attach a document I produced usuing mail merge to an email to be
sent by a separate ISP but I dont want my recipient to get the "Opening this
document will run the following SQL command:" "Data from your database will
be place" etc Dialogue box, when they open my word document on their pc..
How can I dissassociate the database after I have completed my mail merge?
 
P

Peter Jamieson

You can set the Mail Merge Main document type to "Normal Word Document"
- in Word 2007 that option is on the Start Mail Merge button. In Word
2002 and 2003 it's probably easiest to use View->Toolbars to enable the
mail merge toolbar, then use the first button to do that. In Word 2000
and earlier, use Option 1 in the Mail Merge Helper.

You will lose any data source sort/filter options when you do this, but
all the merge fields will remain in the document.


Peter Jamieson

http://tips.pjmsn.me.uk
 

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