Mail Merge to New Document Shows Word Application

[Dean Price]

Hi,

I am automating a mail-merge which works fine. The snag I have is that I
need to also store each individual document in order for a Document
Management System to read in and store in its database. The way in which I
have gotten round this is by creating individual merge results for each
record and then producing the whole datasource and merging at the end, all
works fine.

However, when I execute a merge to a new document which shows the Word
application and documents even though I have already set the .Visible
property to false.

My question is, is there a better way of saving a merge result to individual
documents or if not how can I prevent word from showing when I execute to a
new document?

Regards,

Dean

 

[Doug Robbins - Word MVP]

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
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

 

[Dean Price]

Hi,

Although this is very useful, I am attempting to do this automatically froma
VB .NET application.

I guess I have two questions, can I use this code directly in VB .NET using
the Word Interop or secondly can I call the macro from automation code. My
preferred choice would be to do this via .NET code as I will be using at
least 2 different versions of Word.

Kindest Regards,

Dean