I have fields from one table that are merged into another table. That is then put into an email. The fields that are merged into the email (like numbers) need to be formatted into their respective formats. For example, I have a dollar amount field that merges into the email with the number but not the dollar amount format. I have the phone number that needs to put in the phone format. How do I do that?
I attached a sample database to see what it looks like. It you click the Send email you will see what I am referring to.