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

Tip: Looking for answers? Try searching our database.

Mergo to fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jonathan - 23 Apr 2005 17:09 GMT
Hi,

I build a form I locked and would like to merge and use the merged data as
default value for each field of the form (or fill i nthe form with the
imported data).

I tried to set the default value of the fields to = { MERGEFIELD Name }
but it does not work. I tried some macro too but failed.

Thanks

PS : Word 2000
Peter Jamieson - 25 Apr 2005 09:17 GMT
In Word 2000 the only way you could really do this would be to write a macro
that fills in the data and produces an output document for each record in
the data source. It wouldn't actually be a Word merge, but you could use the
MailMerge.DataSource.DataFields collection to get the values of the various
fields and insert them into your form. Alternatively you could (and probably
should) avoid MailMerge altogether and just use ADO or some other interface
to get your data and do the same thing.

I don't have sample code for that.

In Word 2002 or later you might be able to use the mail merge events to do
something similar.

However, just merging to an output file may not be what you really want to
do anyway - if you do not want to preserve the form fields for use by other
people, there would be no real need to use Form fields. If you do want to
preserve the form fields, you would also probably be better off generating
forms anf accompanying data from scratch in VBA.

Peter Jamieson

> Hi,
>
[quoted text clipped - 8 lines]
>
> PS : Word 2000
 
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.