Hi there,
I'm trying to write VBA code to send email from a shared mailbox to which I have full permissions. The below VBA code sends email from the primary outlook account, but I've been unable to send from a different mailbox address("From" field) configured on the same account. I've tried ".SendUsingAccount" and ".SendonBehalfofName", but those are used in the case of different outlook accounts altogether. Please advise. Here's the code.
Please Login or Register to view this content.
this is what I use to email from another user that I admin....you can see some fields to fill in and it's make a call to an HMTL converter function...you can change the object htmlbody to body and put a string in there to be the body of the email....if you need the html converter let me know...HTH
"Please Login or Register to view this content.
objmessage.To = ""
objmessage.CC = ""
objmessage.BCC = ""
objmessage.htmlBody = RangetoHTML(rng)
objmessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objmessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "INSERT YOUR SMTP SERVER NAME HERE"
objmessage.Configuration.Fields.Item _
("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objmessage.Configuration.Fields.Update
objmessage.Send
End Sub[/CODE]
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Thanks for the suggestion Ernest. I should've started by saying this: I'm a noob when it comes to VBA. I did modify your code in a number of ways, but couldn't get it to run correctly. This is probably a little too much to ask, but could you modify my original code to allow for the "from" address to be the mailbox address (say ABC is the mailbox name and ABC@xyz.com is the "FROM" email address)? Thanks a lot.
give this a try....
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks