patrickzummo
Member
- Outlook version
- Email Account
- Exchange Server
(Diane Poremsy, can you help me??!??)
I have a manual task at work where I get a certain type of email (from a specific sender, with specific subject line, with essentially the same body). This email is sent to two distribution lists, and one individual email address.
My task is to reply to all and remove the 'RE:' from the subject, so the email that I send has exactly the same subject as the one I received (and subsequently replied to all).
This situation sounds like something that would easily lend itself to automation, yet I am having some difficulty.
Using a combination of Outook Rule and VB Script (attached to outlook rule) I have gotten a solution that is pretty close.
I hit Alt+F11 in Outlook to access the VB Script and entered the following code:
Sub ChangeSubjectForward(Item As Outlook.MailItem)
Item.Subject = "Subject of Email"
Item.Save
Set myForward = Item.Forward
myForward.Recipients.Add "email@email.com"
myForward.Subject = Item.Subject
myForward.Send
End Sub
- This code works, but there are issues:
1) how do I send it to more than one recipient? I've read that you can out multiple address, in parenthesis, but when I try that in turns red and is not acceptable. Please offer some advice or suggestions.
Also, two of the intended recipients are distributions groups. Can I use 'DistributionListName' (ie 'seattle office') - the way I would send it directly if I were manually writing an email in Outlook? Or do I have to do 'distributionlistname@emaildomain.com' (ie seattleoffice@myjob.com)??
2) The code above uses 'forward', which is a tip I read on something Diane had posted on another site. While this gets to message sent out, I believe it's causing problems with the recipient. Remember, if I do it manually, I'm using the 'reply to all' function in Outlook, not just forwarding the message. Can someone help me out with the correct syntax for actually using 'reply to all' instead of forward in the code above?
So, I think that's it - I need to use 'reply to all' and want to be able to reply to all to multiple recipients - while keeping the subject the same. Any suggestions, tips, or comments are so greatly appreciated!!!
Also, thinking outside the box - if you want to suggest a totally different way to accomplish the same end result I'm certainly willing to try it!
Again, I need to:
Email comes in. I need to reply to all and change the subject to not contain 'FW:' or 'RE:' - just have it be the same. Then I need to send that email to all of the same recipients that were on the original mail. That's it.
I have a manual task at work where I get a certain type of email (from a specific sender, with specific subject line, with essentially the same body). This email is sent to two distribution lists, and one individual email address.
My task is to reply to all and remove the 'RE:' from the subject, so the email that I send has exactly the same subject as the one I received (and subsequently replied to all).
This situation sounds like something that would easily lend itself to automation, yet I am having some difficulty.
Using a combination of Outook Rule and VB Script (attached to outlook rule) I have gotten a solution that is pretty close.
I hit Alt+F11 in Outlook to access the VB Script and entered the following code:
Sub ChangeSubjectForward(Item As Outlook.MailItem)
Item.Subject = "Subject of Email"
Item.Save
Set myForward = Item.Forward
myForward.Recipients.Add "email@email.com"
myForward.Subject = Item.Subject
myForward.Send
End Sub
- This code works, but there are issues:
1) how do I send it to more than one recipient? I've read that you can out multiple address, in parenthesis, but when I try that in turns red and is not acceptable. Please offer some advice or suggestions.
Also, two of the intended recipients are distributions groups. Can I use 'DistributionListName' (ie 'seattle office') - the way I would send it directly if I were manually writing an email in Outlook? Or do I have to do 'distributionlistname@emaildomain.com' (ie seattleoffice@myjob.com)??
2) The code above uses 'forward', which is a tip I read on something Diane had posted on another site. While this gets to message sent out, I believe it's causing problems with the recipient. Remember, if I do it manually, I'm using the 'reply to all' function in Outlook, not just forwarding the message. Can someone help me out with the correct syntax for actually using 'reply to all' instead of forward in the code above?
So, I think that's it - I need to use 'reply to all' and want to be able to reply to all to multiple recipients - while keeping the subject the same. Any suggestions, tips, or comments are so greatly appreciated!!!
Also, thinking outside the box - if you want to suggest a totally different way to accomplish the same end result I'm certainly willing to try it!
Again, I need to:
Email comes in. I need to reply to all and change the subject to not contain 'FW:' or 'RE:' - just have it be the same. Then I need to send that email to all of the same recipients that were on the original mail. That's it.