Access To Merge Fields

[John Sutton]

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

 

[Doug Robbins - Word MVP]

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

 

[John Sutton]

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

 

[Doug Robbins - Word MVP]

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

 

[John Sutton]

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