How can I add decimal points to a mail merge field?

[lesj1968]

Hi

I have added mail merge fields to a Word Template and all gets exported fine from the data source. However all numbers are coming out with inconsistant decimal points. I want someway to format all mail merge fields so they have only two decimal points. Is there some way to do this?

Also is there a way to make a mail merge field only once in Word? I am exporting quote details with a customer address and product details - however the address keeps appearing every time for each product. Ideally I want the address to appear only once and then a list of the products follow. The only way I have temporarily solved this is to have the customer address in the header, however it still appears on every page. Also, if there is someway to only show the total field just once, at the end of the document that would be ideal. At the moment I have the total appearing in the footer, however this too appears on each page. NB each merged document only contains quote information for one customer only.

Thank you very much for any help.

Less

 

[lesj1968]

I forgot to ask...is there a function for a page break...i.e to make the output start at the beginning of the next page?

 

[PeterMoran]

Hi Less,

Have a look at my reply to a recent thread:

http://www.tek-tips.com/viewthread.cfm?qid=1120656&page=1

which is about similar problems and check the urls I have listed.

Specifically:
1. Decimal points - you can specify the format of fields you are printing to two decimal places as follows:
{ = Cost + Tax \# $#,##0.00 } where the \# indicates the format follows - check Mergeformat in Word help

2. Address to appear only once - You will need to have an If in the field to specify your requirements. Check under Field and then "Field codes: IF field".

3. Total Field only at end - similar to above.

Also you might find this site useful:

http://mvps.org/word/index.html

Good Luck!

Peter Moran