SendObject

[Derek Wittman]

I have a request submission form for my users that calls up a macro when SUBMIT is clicked. One of the macro actions is SendObject - this sends a short data table to me and my supervisor. However, since the logic in one of the tables adds an AutoNumber as a unique identifier, I'd like to be able to include the sender in the cc: header. The caveat is that I have not included logins or anything else to pull in the identity of the user. I realize that many people save their emails to Sent Box and that Outlook would do just that, but only if that Outlook option was toggled ON.

How can I include the sender, or allow the sender to add to the cc: header via Access

Thanks
Derek

 

[Jim/Chris]

In your macro's SendObject action change the property "Edit
Message" to Yes. This will open the email for editing
which will allow for the insertion of the CC or BCC.

Jim

-----Original Message-----
I have a request submission form for my users that calls

up a macro when SUBMIT is clicked. One of the macro
actions is SendObject - this sends a short data table to me
and my supervisor. However, since the logic in one of the
tables adds an AutoNumber as a unique identifier, I'd like
to be able to include the sender in the cc: header. The
caveat is that I have not included logins or anything else
to pull in the identity of the user. I realize that many
people save their emails to Sent Box and that Outlook would
do just that, but only if that Outlook option was toggled ON.

 

[Derek Wittman]

Thanks, Jim. I was rather hoping to take advantage of the automation without the user having to input anything. Not that we don't have good people who will be using the db application. I'm looking to play to the proverbial lowest common denominator, if that makes sense. Also, the users will have a minimum of time, so the quicker the operation, the better off they'll be - and the happier, too!

Thanks!
Derek

----- Jim/Chris wrote: -----

In your macro's SendObject action change the property "Edit
Message" to Yes. This will open the email for editing
which will allow for the insertion of the CC or BCC.

Jim

-----Original Message-----
I have a request submission form for my users that calls

up a macro when SUBMIT is clicked. One of the macro
actions is SendObject - this sends a short data table to me
and my supervisor. However, since the logic in one of the
tables adds an AutoNumber as a unique identifier, I'd like
to be able to include the sender in the cc: header. The
caveat is that I have not included logins or anything else
to pull in the identity of the user. I realize that many
people save their emails to Sent Box and that Outlook would
do just that, but only if that Outlook option was toggled ON.

 

[Jim/Chris]

If that's the case and assuming you want to email a
existing report

1 - create a table with userID and email address.
2 - create a form with the criteria for the report
combo boxes for "email to", CC and BCC
Text box for Subject
Text box for message

a control box containing the logged on user emailaddress (
for verification takenfrom the table defined
A command buton which emails a report using a macro.
The macro would contain the action sendobject with the
following properties
OBJECT TYPE: Report
Object name: ReportName
Output Format: select type desired
TO: =[Forms]![NameOfForm]![email to]
from =[=[Forms]![NameOfForm]![loggeduseraddress]
CC =[Forms]![NameOfForm]![CC]
BCC =[Forms]![NameOfForm]![BCC]
Subject =[Forms]![NameOfForm]![subjecttexbox]
Message =[Forms]![NameOfForm]![messageTextbox]
Allow Edits: No will put email in Outbox, Yes will allow
edits to the email before sending

Jim

-----Original Message-----
Thanks, Jim. I was rather hoping to take advantage of the

automation without the user having to input anything. Not
that we don't have good people who will be using the db
application. I'm looking to play to the proverbial lowest
common denominator, if that makes sense. Also, the users
will have a minimum of time, so the quicker the operation,
the better off they'll be - and the happier, too!