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 / Programming / August 2005

Tip: Looking for answers? Try searching our database.

MailMerge to CheckBoxes?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roger Marrs - 15 Aug 2005 18:52 GMT
I am working on a document that contains a number of checkboxes and
bookmarks, the value/contents of which are dependent upon the value of
numerous fields in multipe records in a database.  Basically, I want to
perform a MailMerge operation, but I need to translate most of the
information in the data source file into CheckBox values, rather than text.

Since the situation I'm dealing with is so similar to a MailMerge, my first
thought was to set up my data source file as a comma-delimited .rtf file.
However, since the ultimate output I'm seeking is mostly CheckBox values
being displayed with the correct value, instead of text from the data
source, I'm thinking that using tables might be better.  I can create a
single column, mulitple row table for each record, so I would end up with an
.rtf file that would contain a single colum table for each record, with the
rows in each table consisting of the data from the fields in each record.

Or, I suppose I could perform a straight MailMerge using the comma-delimited
file and then reference the MailMerge fieldnames in the merged file to get
the information needed for CheckBox values in the final document that I
actually need to create.

(I realize I could potentially query the database directly, but for various
reasons I would like to avoid doing so.)

I've searched the word.mvps site and the internet for some guidance in how
to accomplish this procedure, but haven't found anything even close.  Any
help would be greatly appreciated.

Roger Marrs
Cindy M  -WordMVP- - 16 Aug 2005 11:39 GMT
Hi Roger,

> I am working on a document that contains a number of checkboxes and
> bookmarks, the value/contents of which are dependent upon the value of
> numerous fields in multipe records in a database.  Basically, I want to
> perform a MailMerge operation, but I need to translate most of the
> information in the data source file into CheckBox values, rather than text.

You'll find a suggestion in the mail merge faq on my website for associating
symbols with mergefields, inside an IF field. Perhaps that will help?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Roger Marrs - 16 Aug 2005 21:46 GMT
Thank you Cindy.  I'll work on this from the MailMerge angle and see how it
comes together.  I was hoping to avoid performing a mailmerge and then using
that result to create my end product, but it may be the way to go.

Roger

> Hi Roger,
>
[quoted text clipped - 14 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
Cindy M  -WordMVP- - 17 Aug 2005 10:56 GMT
Hi Roger,

> I'll work on this from the MailMerge angle and see how it
> comes together.  I was hoping to avoid performing a mailmerge and then using
> that result to create my end product, but it may be the way to go.

I triggered on MailMerge in your subject line. There's almost certainly a way
to do this without mailmerge (try inserting a symbol - record a macro when
doing that in the Word UI to get the basic syntax). Let me know...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Roger Marrs - 31 Aug 2005 20:14 GMT
Cindy,

I followed your suggestion and recorded a macro while inserting a Registered
symbol into a document:

Selection.InsertSymbol Font:="Times New Roman", CharacterNumber:=174, _
       Unicode:=True
However, I'm unclear as to how that syntax would apply to what I'm trying to
accomplish.

Roger
> Hi Roger,
>
[quoted text clipped - 13 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

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.