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 2007

Tip: Looking for answers? Try searching our database.

How do I retain special fields {} in a merge document?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
C Hayes - 21 Aug 2007 16:42 GMT
How do I retain special fields {} in a merge document?

I created a special autotext field on a document to allow a dropdown menu on
right click.  When I merge the document I lose that field and it becomes
text.  Is there a way to merge the field and not the text only?
C Hayes - 21 Aug 2007 17:36 GMT
I've been reading some recent posts (I did try to search for an answer before
I posted) and it appears there is no easy answer to this.

> How do I retain special fields {} in a merge document?
>
> I created a special autotext field on a document to allow a dropdown menu on
> right click.  When I merge the document I lose that field and it becomes
> text.  Is there a way to merge the field and not the text only?
Doug Robbins - Word MVP - 21 Aug 2007 20:54 GMT
I would guess that you will need to use VBA to create a "roll-your-own"
equivalent to mail merge.  To do that, I would start with a template in
which I used DOCVARIABLE fields in place of the merge fields and then
iterate throught the data source, creating a new document from that template
for each record and setting document variables in that documnet to the data
from the data source and then saving that document before the macro moves on
to the next record in the data source and repeats the process.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I've been reading some recent posts (I did try to search for an answer
> before
[quoted text clipped - 6 lines]
>> right click.  When I merge the document I lose that field and it becomes
>> text.  Is there a way to merge the field and not the text only?
C Hayes - 21 Aug 2007 21:10 GMT
Thank you Doug.

I kind of came at it from the other end.  I dropped a button on my subform
and used Kallal's mergeallword module with a hard coded sql string.  But I
like this idea of a "roll-your-own" mail merge for complex fields (especially
merging a form with controls.)

Thank You,

Chris

> I would guess that you will need to use VBA to create a "roll-your-own"
> equivalent to mail merge.  To do that, I would start with a template in
[quoted text clipped - 14 lines]
> >> right click.  When I merge the document I lose that field and it becomes
> >> text.  Is there a way to merge the field and not the text only?

Rate this thread:






 
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.