Link to home
Create AccountLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

OutLook VBA - Group EM Box

Hello All,

I need some VBA help!
I am aware of how to code in VBA to automatically send outlook email to recipients.

Something like this:

Sub simpleMailMessage()
Dim oOutApp As Object 'Outlook.Application 'early binding
Dim oMailItem As Object 'Outlook.MailItem 'early binding

    Set oOutApp = CreateObject("Outlook.Application")
    Set oMailItem = oOutApp.CreateItem(olMailItem)
   
    With oMailItem
        .To = [toEmail]
        .Subject = [Subject]
        .Body = [Body]
        .Display 'replace with .Send when ready to automate, or just see the displayed email and hit SEND
    End With
   
    Set oOutApp = Nothing
    Set oMailItem = Nothing
End Sub


But the issue is that when the code above is triggered it sends email from the person's outlook, who triggered the code.
You see I don't want that!!

What I want: that the code actually sends those multiple emails from a assigned Group outlook Email Box. Now how do I do it?? so that those emails gets out from that Group outlook email box..

sending these zillions of emails from the users's individual outlook account is not preferred or wanted....

Thank You,
R
Avatar of Rayne
Rayne
Flag of United States of America image

ASKER

Group Email account aka shared email acccount
Avatar of Rayne

ASKER

like a certain set of people have access to that Group Email Account and these multiple emails will send out from that Group Email Account via the vba code
ASKER CERTIFIED SOLUTION
Avatar of terencino
terencino
Flag of Australia image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Rayne

ASKER

Thank you Terry :)
Much appreciated