Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / November 2007

Tip: Looking for answers? Try searching our database.

Mail Merge to New Document Shows Word Application

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dean Price - 19 Nov 2007 17:19 GMT
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 - 19 Nov 2007 19:09 GMT
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.

Signature

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

> Hi,
>
[quoted text clipped - 18 lines]
>
> Dean
Dean Price - 20 Nov 2007 09:29 GMT
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

> See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
> at:
[quoted text clipped - 28 lines]
> >
> > Dean
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.