A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mergo to fields



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2005, 05:09 PM
Jonathan
external usenet poster
 
Posts: n/a
Default Mergo to fields

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
  #2  
Old April 25th, 2005, 09:17 AM
Peter Jamieson
external usenet poster
 
Posts: n/a
Default

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

"Jonathan" wrote in message
...
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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
improving performance by indexing query criteria fields Paul James General Discussion 20 February 16th, 2005 07:55 PM
improving performance by indexing query criteria fields Paul James Running & Setting Up Queries 20 February 16th, 2005 07:55 PM
adding 2 fields including null entries Jesse Running & Setting Up Queries 26 January 18th, 2005 05:31 PM
Can't Add Fields to Form Jeff Miller Using Forms 4 January 12th, 2005 03:42 AM
Automatic filling of fields in table two from table one Jim Kelly Database Design 1 September 27th, 2004 10:16 PM


All times are GMT +1. The time now is 05:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.