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 / General MS Word Questions / July 2005

Tip: Looking for answers? Try searching our database.

Mailmerge using access problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lesley - 21 Jun 2005 11:29 GMT
I have successfully created a mailmerge in word 2000 using an access table
for data.

There is an access field which is a Yes/No Checkbox and it does not display
the way I need it to.  Instead of seeing a ticked or unticked box I see 0 or
-1

Can anyone please help me?!?!?!
Signature

Many thanks

Lesley

Doug Robbins - 21 Jun 2005 19:16 GMT
You will need to use an If...then...else field that checks for the value of
the mergefield and depending upon what it is, inserts the checked or
unchecked box that you will find in the Insert>Symbol dialog.

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 have successfully created a mailmerge in word 2000 using an access table
> for data.
[quoted text clipped - 6 lines]
>
> Can anyone please help me?!?!?!
Lesley - 12 Jul 2005 10:30 GMT
Doug - thanks for your reply but I am not that computer literate.  Not sure
what you mean by using an If...then....else field.  Not sure whether i would
need to make changes in access or the actual word (mail merge doc).  I would
be grateful if you could explain further.

This is a database i created a couple of years ago and have taught myself
along the way.  I work for a national charity and unfortunately I cannot
subscribe to the MS assisted help option as there is a charge!!!!!

Any help would be gratefully received!

Many thanks
Lesley

> You will need to use an If...then...else field that checks for the value of
> the mergefield and depending upon what it is, inserts the checked or
[quoted text clipped - 10 lines]
> >
> > Can anyone please help me?!?!?!
Doug Robbins - 12 Jul 2005 21:27 GMT
At the location where you want the check boxes to appear, from the Insert
menu in Word, select Symbols and select the Wingdings 1 font and insert the
168 symbol (an empty box) then the Wingdings 254 symbol (a box containing a
tick mark).  Then insert a space between the two symbols and then select
them both and Press Ctrl+F9 so that they are enclosed inside field
delimiters { }.  Now, locate the selection after the opening { and type IF,
then insert the mergefield that contains the -1 or the 0 values and after it
type a space, then = -1 with a space after the minus one.

You should now have

{ IF <<mergefield>> = 0 symbol symbol }

Press Alt+F9 a couple of times to hide the display of the field codes and
then execute your merge.  You may need to use Ctrl+A to select everything in
the document that is created (assuming you execute the merge to a new
document) then press F9 to update the field codes in the document.

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

> Doug - thanks for your reply but I am not that computer literate.  Not
> sure
[quoted text clipped - 30 lines]
>> >
>> > Can anyone please help me?!?!?!
Pidge - 13 Jul 2005 10:20 GMT
Doug - thanks so much for getting back with simple to understand
instructions.  I have tried it many times this morning, however, when i
insert the merge field after Ctrl F9 { I see    

{ IF{MERGEFIELD}=-1 symbol symbol }    notice that I do not get the << or >>
signs you show below

When I press Alt F9 I see ...

Error! Unknown op code for conditional.

I have tried it with 4 of the possible 12 yes/no tick box merge fields
several times all with the same result.  I have also tried adding or removing
a space in various places but with no difference.  The merge fields are all
basic yes/no tick boxes in access.

Can you please help further

Many thanks
Lesley

> At the location where you want the check boxes to appear, from the Insert
> menu in Word, select Symbols and select the Wingdings 1 font and insert the
[quoted text clipped - 48 lines]
> >> >
> >> > Can anyone please help me?!?!?!
Pidge - 13 Jul 2005 12:32 GMT
Doug - before you do anything else stop - I have fiddled a bit more and
managed to display the tick boxes as i need them.  Thank you so much for your
expert help - I have learned a great deal.
With thanks
Lesley

> Doug - thanks so much for getting back with simple to understand
> instructions.  I have tried it many times this morning, however, when i
[quoted text clipped - 69 lines]
> > >> >
> > >> > Can anyone please help me?!?!?!
 
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.