7
75oreo
We have created a database and have queries that list email addresses. We
created a macro with the Send Object action. In the "To" we created a
expression for Access to pull the email addresses from the query for sending
the report. The problem is when we run the macro we get the email to pull
with the report but the email address actually list our expression and not
the email addresses from the query. There has to be a way to get the email
addresses in the receiptant without having to retype the addresses everytime.
We have multiple email addresses from the query we want to pull from. We
have separated the fields in the expression with (
but, still it puts the
expression in the "To" for the email. Can anyone help?
created a macro with the Send Object action. In the "To" we created a
expression for Access to pull the email addresses from the query for sending
the report. The problem is when we run the macro we get the email to pull
with the report but the email address actually list our expression and not
the email addresses from the query. There has to be a way to get the email
addresses in the receiptant without having to retype the addresses everytime.
We have multiple email addresses from the query we want to pull from. We
have separated the fields in the expression with (
but, still it puts theexpression in the "To" for the email. Can anyone help?