Access To Merge Fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Sutton - 14 Nov 2003 20:22 GMT

Word 2002

I have a merge document where I want to have certain sections show
up/not show up based on merged fields having a value other than $0.00.
I think I would need to mark the sections with bookmarks and have an
autonew macro set up to delete the unneeded sections of the doc. I
can't seem to find how to address mergefields in the macro. This will
be a quote sheet when finished, with all parts listed on the doc, and
only those quoted will remain.

As an afterthought, can you perform calculations on/with the merge
fields in the macro? I have amounts but no total, do I need to go back
and add that to the data source???

Thanks for your time,
John Sutton
KBS

Reply to this Message

Doug Robbins - Word MVP - 14 Nov 2003 23:27 GMT

Hi John,

Use an If...Then...Else field construction in the mailmerge main document.
No macro will be required.

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Word 2002
>
[quoted text clipped - 13 lines]
> John Sutton
> KBS

Reply to this Message

John Sutton - 17 Nov 2003 15:44 GMT

Thanks Doug,
About my secondary question, during a merger, can you combine two
merge fields into one, such as adding one to another to print a single
number??
Thanks
John
KBS

Reply to this Message

Doug Robbins - Word MVP - 18 Nov 2003 08:50 GMT

Hi John,

Yes, use a formula field

{ = { MERGEFIELD "Field1" } + { MERGEFIELD "Field2" } }

You must use Ctrl+F9 to insert the field delimiters { }

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Thanks Doug,
> About my secondary question, during a merger, can you combine two
[quoted text clipped - 3 lines]
> John
> KBS

Reply to this Message

John Sutton - 18 Nov 2003 14:04 GMT

Thanks Doug, is that in the help anywhere???

I tried several things, all of which just danced around the correct
answer.

Thanks again,
John
KBS

>Hi John,
>
[quoted text clipped - 17 lines]
>> John
>> KBS

Reply to this Message