Email a Report

[Brook]

Does anyone know how I can sent a report via Email, having
the user Choose what email address to use? Meaning I have
a tblEmail that houses all my email address that I will
have the option to use. Can I do a lookup to this tbl to
select the person I want to email?

Brook

 

[Piers 2k]

Create a macro to help you.

Use the SendObject function, in which you can specify which item to send, in
what format, and to whom. Also other bits like body, CC and subject.

You can leave the TO field blank for it to prompt you, or you could specify
the form and field that has the e-mail address in it.

If you have a button on a form to run the macro, have a drop-down with the
users names, and put something like this in the TO field:
Forms!FormName!ComboBoxName

Piers

| Does anyone know how I can sent a report via Email, having
| the user Choose what email address to use? Meaning I have
| a tblEmail that houses all my email address that I will
| have the option to use. Can I do a lookup to this tbl to
| select the person I want to email?
|
| Brook

 

[Brook]

Thanks for the information,

Can I have the Macro point to a table that houses my
Email List?

Brook

 

[Bob]

Leaving the "To" field blank prompts your email carrier to
request input from the user and will default to whatever
address books that carrier contains. You can however have
a combobox on your form that points to the table that
houses your email addresses and use that control as
the "To" field when sending the email.

 

[Brook]

So once I set up my combo box, how do I code the "To"
field to accept the Combo Box Control?

Brook

 

[Brook]

Another issue that I am trying to get finalized, is that
once I get the Macro Set up to be able to email, is there
a way that I can have it only email the record that is
located on the form in which I am running the Macro.

I.E. If my form is pulling data based on CallID, can I set
up the macro to recognize this?

Brook