Set from field in email sent from Access

[WembleyBear]

Hi

I'm using the SendObject method to notify other staff members when a call
has been assigned to them in my database. I'm wondering if it's possible to
set the FROM field of the email message so that rather than looking like it
comes from me personally, it would read like an alias of, say, "Service
Desk"? Of course, I only want such a property to be valid for the one action,
as I obviously do other send emails which come from me personally.

I use Access and Outlook 2000 with Exchange Server over Citrix. I've posted
my code below, but I'm only a beginner, so be gentle! (Apologies if this
should have gone to Outlook group):

Private Sub Assign_To_User_Click()

With CodeContextObject
DoCmd.OpenReport "Full_Call_Report", acPreview, "",
"[Calls]![Call_Ref]=[Forms]![Calls]![Call Ref]"
DoCmd.SendObject acSendNoObject, "", "", .[Assigned To].Column(1),
"", "", "** New call assignment **", "A new " & .[Priority] & " helpdesk call
has been assigned to you. The call reference is: " & .[Call_Ref] & "PLEASE DO
NOT REPLY DIRECTLY TO THIS MESSAGE", True, ""
DoCmd.Close acReport, "Full_Call_Report", acSaveNo
DoCmd.RunMacro "AssignmentMsg"

End With

End Sub


Many thanks
Martyn

 

[SteveM]

SendObject does not have an attribute for setting the 'From' property of an
email (that I know of)...

You can do this using CDO to send your emails.
Do a Google on 'CDO' and you will get a lot of info about it.

Steve