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 / January 2004

Tip: Looking for answers? Try searching our database.

perform merge on open

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jeanne - 20 Jan 2004 21:09 GMT
I have a hyperlink pointing to a merge document. I'd like
the merge to occur automatically when the the document is
opened, that is, when the link is clicked. Can this be
done.
Bobby Mikkelson_MSFT - 20 Jan 2004 22:34 GMT
Hello Jeanne,

This is possible to start the merge and possibly run through the wizard but
this can only be done using a VB or VBA Macro. Unfortunantly I can't help
create the macro. A Programmer familliar with VB and VBA should be able to
write one faitly easily.

Hope this helps

Thanks

Bobby Mikkelson

--------------------
| Content-Class: urn:content-classes:message
| From: "jeanne" <anonymous@discussions.microsoft.com>
[quoted text clipped - 20 lines]
| opened, that is, when the link is clicked. Can this be
| done.
Peter Jamieson - 21 Jan 2004 09:49 GMT
When the user clicks the link, is the Word document going to be opened in
Word inside an Internet Explorer window, or Word on its own? If the former,
I think you will have difficulty getting a a merge to run. If the latter,
the second question is "Where is the data source?" If it is at a URL (which
is what people typically want in this situation), Word cannot connect to the
source. It has to connect either to a file with a "WIndows file system
address", such as abc.doc, c:\def\abc.doc, \\myserver\myshare\abc.doc etc.,
or to a client-server type database such as SQL Server or Oracle, via ODBC
or (Word 2002 and later) OLEDB.

If the document will open in Word only and is able to connect to the data
source, all you really need is an AutoOpen macro that does

ActiveDocument.MailMerge.Execute

but you might also want to do stuff such as specify the data source. If the
data source needs to be specified at runtime you should save the mail merge
main document without a data source and connect using OpenDataSource in your
macro.

--
Peter Jamieson - Word MVP
Word MVP web site http://word.mvps.org/

> I have a hyperlink pointing to a merge document. I'd like
> the merge to occur automatically when the the document is
> opened, that is, when the link is clicked. Can this be
> done.
jeanne - 22 Jan 2004 16:35 GMT
Yes, it will open in Word only and yes, it can find the
data source (and .mdb file). I think adding the macro will
do it for me. Thanks!

>-----Original Message-----
>When the user clicks the link, is the Word document going to be opened in
[quoted text clipped - 27 lines]
>
>.
 
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.