Macro to send report

  • Thread starter Thread starter Rob
  • Start date Start date
R

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
 
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
 
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

.
Click to expand...
.
Click to expand...
 
Back
Top