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.
Can I use a Field Reference as the CC or BCC in Total Access Emailer for Microsoft Access?
Yes you can. On the Addresses tab of the Total Access Emailer settings editor, the CC and BCC text boxes can reference a field in your data source. Simple refer to the field name within brackets like this:
If you have more than one field that you'd like to reference as a CC or BCC, use a query as your MS Access data source and create a calculated field that combines the two fields with a semicolon between them. Then use the name of the Calculated Field for the name of your Field Reference. For example, in the screenshot below, we're combining the data from Field2 and Field3 within a calculated field called "CC".
Then, use the CC field as your Field Reference in Total Access Emailer like this:
Note: Be sure that you have the Use Field References option turned on. This setting is found on the Basics Tab of the Total Access Emailer Settings Editor.
Additionally, the CC and BCC features were not designed to support *both* field references *and* literal email address strings. It supports one or the other. That said, if you'd like to, you can edit your query to use both. In the example below, our query is using a calculated field to refer to table values as well as an email address string.