Design a Macro that sends e-mail

  • Thread starter Thread starter David
  • Start date Start date
D

David

When I preview a report, I can send an e-mail containing a "snapshot" of the
report by right-click/ send to/ Mail receipient/ snapshot / OK.

How can I make a macro to to all that?
 
You use the SendObject action in an Access macro to do the
same thing.

Select "SendObject" from the action column. At the bottom
of the screen you'll see several options for the action
with the first being ObjectType. In your case you'll
select "Report", then choose the name of your report.
Choose "Snapshot" as the output type. Pay attention to the
help comments on the right side of the screen as you
select each option. It will guide you through what options
you might want to select. If you leave the address fields
blank you'll be given the option to select recipients in
your email program. Whatever you put on the subject line
here will appear on the subject line of you email. Save
your macro.

To send the report, create a command button to execute the
macro. If you're using the wizard to create the command
button you can select "Run Macro" and specify the macro
you just created.
 
Thanks for the details.


Bob said:
You use the SendObject action in an Access macro to do the
same thing.

Select "SendObject" from the action column. At the bottom
of the screen you'll see several options for the action
with the first being ObjectType. In your case you'll
select "Report", then choose the name of your report.
Choose "Snapshot" as the output type. Pay attention to the
help comments on the right side of the screen as you
select each option. It will guide you through what options
you might want to select. If you leave the address fields
blank you'll be given the option to select recipients in
your email program. Whatever you put on the subject line
here will appear on the subject line of you email. Save
your macro.

To send the report, create a command button to execute the
macro. If you're using the wizard to create the command
button you can select "Run Macro" and specify the macro
you just created.
 
Back
Top