Mailmerge Query

[ryankeast]

Hi There,

I have a mailmerge document that is generated from our Housing System. On this document there are two mailmerge fields - one called Current Balance and the other called Rent Arrears.

What I want to try and achieve is to add these two merge fields together and then multiply by 4, and then place this custom merge filed on the document as well. Is this possible if the mergefiled is not coming from where the other fields are?

Thanks

Ryan

 

[DirkStruan]

Ryan

Yep, should be. Use "Formula" under the Table menu. Insert the Sum function referring to your two mergefields and then multiply by 4 and it should work out.

I'm not that knowledgeable about Word but you may have issues with mergefield names that contain a space (I would use an underscore or not separate the words).

Anyway, when you've finished the function you may see an error message saying there is an undefined bookmark referring to one of the merge fields. Ignore this and merge the document - it should work.


Dirk

Everything useful perishes through use....Should I not rejoice at being useless?

 

[dcompto]

You may also want to include a "picture format" in the merge field to format the number. The formula would look something like:

[b]{=(Current_Balance+Rent_Arrears)*4 \# "$#,##0.00;($#,##0.00)" }[/b]

to result in a number formatted like: $14,824.84