Mail merge with prices


D

Dan S.

I have a post card set up in Publisher with mail merge using an Access
database. The table's field is set up as "currency" with only 2
decimal places. Yet, when I merge the price, it still shows up as
"$33.945" for example. Why is this?
 
Ad

Advertisements

E

Ed Bennett

Dan said:
I have a post card set up in Publisher with mail merge using an Access
database. The table's field is set up as "currency" with only 2 decimal
places. Yet, when I merge the price, it still shows up as "$33.945" for
example. Why is this?

This is because Publisher generally ignores all field formatting. If you
export your table as a CSV flat file, then Publisher should merge correctly.
 
Ad

Advertisements

D

Dan S.

Ed Bennett explained :
This is because Publisher generally ignores all field formatting. If you
export your table as a CSV flat file, then Publisher should merge correctly.

It worked perfectly. Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top