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

Tip: Looking for answers? Try searching our database.

Merge with Excel

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Robert Couchman - 04 Mar 2004 13:43 GMT
Hello all,

not used this room before but my excel project has growen
into ms word.

please can someone help,

i need to be able to mailmerge with word, YES i can
already do this....

BUT....!!!

if my program moves (e.g. excel spreadsheet and word
documents)

i need the mailmerge to always look for its data in the
activedocument.Path

i know i can use this in VB code when using a querystring,
BUT is there any way of doing this with the merge option??
will it be using VB???

thank you,

Robert Couchman
(robert.couchman@jobcentreplus.gsi.gov.uk)
Peter Jamieson - 10 Mar 2004 07:46 GMT
I think you will have to use VB(A) to reconnect to the datasource to be
sure - generally speaking Word uses an absolute pathname. It /may/ connect
to the file in the same directory in some circumstances but I wouldn't want
to rely on it.

As a rule if you are moving things around you should turn your mail merge
main document back into a "Normal" Word document before moving it. If you
don't, users will almost certainly see the "Cannot find data source"
message. The document should retain its field codes, but it will lose
a. the connection tot the data source
b. the mail merge type (Form Letters, Catalog/Directory etc.)
c. the mail merge destination
d. filter and sort options

So in other words any VB(A) you use will need to restore all those things.

Signature

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

> Hello all,
>
[quoted text clipped - 22 lines]
> Robert Couchman
> (robert.couchman@jobcentreplus.gsi.gov.uk)
 
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.