Rayne
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.Appl ication")
Set oMailItem = oOutApp.CreateItem(olMailI tem)
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
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.Appl
Set oMailItem = oOutApp.CreateItem(olMailI
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
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you Terry :)
Much appreciated
Much appreciated
ASKER