Checkbox into a merge "switches"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris O - 17 Apr 2008 22:39 GMT

Hello, I am trying to import data from ACT as a mail merge, checkboxes show
up in word as "true" or "false". I would like it to say "Y" or be left
blank. How can I change the data in the switch info so it can do this?
Thanks!!!

Reply to this Message

Doug Robbins - Word MVP - 17 Apr 2008 23:04 GMT

Use and If...then...Else field

{ IF { MERGEFIELD fieldname } = "true" "y" "" }

You must use Ctrl+F9 to insert each pair of Field Delimiters { } and you use
Alt+F9 to toggle off their display.

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

> Hello, I am trying to import data from ACT as a mail merge, checkboxes
> show
> up in word as "true" or "false". I would like it to say "Y" or be left
> blank. How can I change the data in the switch info so it can do this?
> Thanks!!!

Reply to this Message

Chris O - 17 Apr 2008 23:52 GMT

Hi Doug

Thanks for that, unfortunately ACT didn't like that, it came up with the
error "object has been deleted", I know it also doesn't like the date format
switches either.

The info when going ALT F9 is:
{ DOCVARIABLE [ACTFIELD]TBL_CONTACT.CUST_AgriculturalEquipment_121246028 \*
MERGEFORMAT }

The extension is actually .adt instead of .doc, not sure if that affects it
at all.

I have asked this question on the ACT website, but I am yet to get any
response.

Thanks,
Chris

> Use and If...then...Else field
>
[quoted text clipped - 8 lines]
> > blank. How can I change the data in the switch info so it can do this?
> > Thanks!!!

Reply to this Message

Doug Robbins - Word MVP - 18 Apr 2008 02:43 GMT

Use

{ IF { DOCVARIABLE
[ACTFIELD]TBL_CONTACT.CUST_AgriculturalEquipment_121246028 \*
MERGEFORMAT } = "true" "y" "" }

I am not sure where you are seeing the extension .adt so cannot comment on
its significance

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

> Hi Doug
>
[quoted text clipped - 31 lines]
>> > blank. How can I change the data in the switch info so it can do this?
>> > Thanks!!!

Reply to this Message

Rate this thread: