Macro to send report

[Rob]

I have a macro that sends a report for me. What I would
like to do is in the "To" action block have it look in a
query that produces the correct e-mail address. My problem
is I can't figure out the correct syntax to make it do
this, if it's possible at all.

Thanks,
Rob

 

[Jim/Chris]

Perhaps it might be better to look in a form for the email
address in a control(like a dropdown box). Then have a
button on the form that runs the send object macro. In the
macro for the "TO" enter

=[Forms]![formname]![email address control name]

Jim

 

[Rob]

Thanks,
took your advice and it works.

Rob

-----Original Message-----
Perhaps it might be better to look in a form for the email
address in a control(like a dropdown box). Then have a
button on the form that runs the send object macro. In the
macro for the "TO" enter

=[Forms]![formname]![email address control name]

Jim

-----Original Message-----
I have a macro that sends a report for me. What I would
like to do is in the "To" action block have it look in a
query that produces the correct e-mail address. My problem
is I can't figure out the correct syntax to make it do
this, if it's possible at all.

Thanks,
Rob

.

.