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 / June 2006

Tip: Looking for answers? Try searching our database.

how to save a database field into bookmark

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
flnew - 15 Jun 2006 14:24 GMT
Does anyone know how to save the value of a database field into a
bookmark so I can reference this bookmark even at the end of the mail
merge? Thanks!
Doug Robbins - Word MVP - 15 Jun 2006 18:56 GMT
As the name of each bookmark in a document must be unique, they are deleted
by the mailmerger process as the creation of multiple bookmarks in the
output would be in conflict of this rule.

For what you want to do, why not just insert the field the value of which
you want to refer to at the location where you want the value to appear?

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

> Does anyone know how to save the value of a database field into a
> bookmark so I can reference this bookmark even at the end of the mail
> merge? Thanks!
flnew - 15 Jun 2006 21:06 GMT
Sorry, I do not understand what you are trying to say.
This still refer to the last question I asked(mulitiple records into
one document) and no good means to do it. So I use lots NEXT IF
statements, hoping that the number of retrieved records is less than
the NEXT IFs I have in the main document.

This seems working but there is still a small problem: at the end of
the file, I have a filed need to be filled by data from database, since
merge already finishs all the records, so that field is empty. That's
why I want to save that data to the bookmark or anything can hold this
data and use it at the end of the file.

I am not familiar with word so do not know what to do. It would be
greatly appreciated if you could be able to help me. Thanks!
Doug Robbins - Word MVP - 16 Jun 2006 04:41 GMT
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the
ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

http://www.knowhow.com/Guides/CompoundMerges/CompoundMerge.htm

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

> Sorry, I do not understand what you are trying to say.
> This still refer to the last question I asked(mulitiple records into
[quoted text clipped - 10 lines]
> I am not familiar with word so do not know what to do. It would be
> greatly appreciated if you could be able to help me. Thanks!

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.