If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Automate From Field
Hi all
I posted this last week but it seems MS deleted a load of its forums, including the VBA one I'd posted to :-(. So here goes again... From MS Access 2003, I have a routine in code that automates an email. I can autofill the To, cc, subject, body field etc but now I need to also send from a different user using the 'From' field. I tried adding this in the same way to my code using: .from but it seems this is not a supported method? I receive and Access error 438: Object does not support this property of method. Please can any one tell me if this is possible and if so how to do it? If I leave for the user to enter the from email address manually it is very easy for them to miss this and just hit send, which would result in it being addressed as themselves. It is crucial that this does not happen as we are sending the emails on behalf of a different company. Thanks for your help... snipped of the Code, if I rem the .from line this will work ok... With objEmail .from " .To = "SJH-" & dist .CC = " .BCC = "sue;fred;tom" .Subject = "Analysis Monthly Reports" .Body = "Test email please ignore... " .Attachments.Add strPath |
Thread Tools | |
Display Modes | |
|
|