Background

Total Access Emailer is the world's most popular Microsoft Access email add-in product and VBA code library. Simplify the way you communicate with your contacts, and easily share the data and reports from your Microsoft Access databases with personalized emails for each recipient.

Problem

Total Access Emailer field references do not respect table formatting from the Currency datatype. 

Solution

This is the result of the way that field references work within Microsoft Access. If you would like to use a formatted value within a Field Reference in Total Access Emailer, simply use a query for the data source and add a calculated field with the value to use.

For example:
Expr1: Format([CurrencyField], "Currency").

You can rename "Expr1" to a more meaningful name if you would like, then reference that field within the email as a Field Reference.

Check to make certain that you have the Use Field References option selected in the interface.

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
• PDF Fact Sheet