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 / August 2005

Tip: Looking for answers? Try searching our database.

Opening a Mailmerge Word Document from Excel using VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Wedgetail - 23 Aug 2005 03:32 GMT
Any explanation an assitance would be greatly appreciated.

I have an excel [2000] file that I use to generate a mail merge data set for
word.
Using VBA, I create a excel file with one [1] sheet, then open word, and an
existing mail merge document with all the fields.  I then relink the merge
document to the new data file and merge.  

This all works but takes approx. 1 minute to the file, and another minute to
relink the new data file.  If I open the document through word manually, it
only takes about 3-5 seconds to open the word document, similar to relink.

Can someone first explain the time lag, and/or how to fix it?

Thanks
Simon
Cindy M  -WordMVP- - 23 Aug 2005 15:15 GMT
Replied to duplicate question in one of the
office.developer newsgroups.

   Cindy Meister
 
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.