Using an Access query as a mail merge data source

[RacerGirl117]

I have a department that has a merge letter that uses a query in an Access database. In the query, the fields are formatted to display as currency. However, when merging the data in the letter, the values display as simple numbers. Is there a way to fix this?

Thanks in advance,
Jessica Kinsey
Hiscock & Barclay, LLP

 

[tunsarod]

Suppose that the currency merge field in your Word document is called «Amount». Highlight the merge field then right click and select 'Toggle Field Codes'.

The field should now look like: {MERGEFIELD Amount}

Edit this to look like: {MERGEFIELD Amount \# £#,##0,00}

Now click the <<abc>> view merged data button and see if it's what you want.

 

[RacerGirl117]

Thank you...that's perfect!