Rules to auto redirect

Status
Not open for further replies.

Shawn Zeng

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hi

So I used the following script to update mail subject and forward. This works, but I am wondering if there is a function or syntax to redirect and not foward. Basically tring to see if mail can be sent without the FW infront the subject and without my email as the sender.... Thanks!


Sub ChangeSubjectForward(Item As Outlook.MailItem)
Item.Subject = "Test for " & Date
Item.Save
Set myForward = Item.Forward
myForward.Recipients.Add "abs@gmail.com"

myForward.Send
End Sub
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
No redirect directly, but if all you want to do is change the subject, use

(This assumes you didn't want to change the subject of the message in your inbox.)

Code:
Sub ChangeSubjectForward(Item As Outlook.MailItem)
Set myForward = Item.Forward
myforward.subject = item.subject
myForward.Recipients.Add "abs@gmail.com"
myForward.Send
End Sub
 

Shawn Zeng

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Hi thanks for the help on this. So the email that I received contained an attachment file (Excel). Is there a way to write up a script to password protected Excel file attachment before the auto forward? Thanks!
 

Shawn Zeng

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
Or maybe auto encrypted email, is there a way to do this?


 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Can excel password a file via a macro? If so, then you might be able to do it in outlook. AFAIK, you can't sign a message sent via a macro, so it depends on if excel can password it.
 

Shawn Zeng

Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server
is there a way to write a script to password protect the excel file before this is send out?
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0
K How to auto truncate a message to forward with Outlook Rules Using Outlook 6
L Exchange 2010 Server not sending attachments on Outlook auto-reply rules. Exchange Server Administration 16
H Create/Apply auto formatting rules by VB? Outlook VBA and Custom Forms 2
R rules not working - done troubleshooting Using Outlook 0
P Outlook 2013 All imported Mail Rules in error when imported into new profile Using Outlook 5
A Apply Selected Emails to outlook rules and Run Rules Using Outlook 5
Wayne Outlook locks up when opening "Manage Rules & Alerts" Using Outlook 7
T "Words In Recipient's Address" Rule Causes Outlook To Stop Processing Rules Using Outlook 3
Retired Geek Junk Folder Clean Up Rules Exchange Server Administration 1
B Setting rules Using Outlook 1
A rules not working Using Outlook 2
M Rules and autoreply Using Outlook 1
N Outlook rules don't create a copy for bcc'ed emails Using Outlook 3
O How to recover rules after switch from POP3 to IMAP Using Outlook 2
N Focussed Inbox Rules Failing Using Outlook 5
N Copies of emails from rules have wrong from: account Using Outlook 0
L Office 365 cloud based rules Using Outlook 1
K Outlook Rules: Move a Copy Using Outlook 4
CWM030 Rules disappearing in OL 2016? ( Yes, I searched before posting) Using Outlook 7
R When rules lose track of "specified folder" Using Outlook 6
I Outlook 2013 Rules - (client only) Using Outlook.com accounts in Outlook 1
B When I add more search strings to RULES, it is not processing them Using Outlook 3
O Having rules run on old mails noved to inbox Outlook VBA and Custom Forms 8
A rules (flags) not working Using Outlook 7
K Lost Rules. Assistant accesses my mailbox. Disappeared Using Outlook 0
soadfan Outlook rules look up display name only Using Outlook 4
S Send email via SMTP - use transport rules to add to senders inbox (then rule to move to sent items Exchange Server Administration 1
Justo Horrillo Issue with rules in Outlook 2010 Using Outlook 4
R When rules are working but invisible and unmanageable Using Outlook 2
P Transport Agent or Rules/Connectors Exchange Server Administration 1
A Rules - how to determine if all conditions in rule are true or false Outlook VBA and Custom Forms 5
EaglePI Outlook 2010 need help with rules Using Outlook 0
O Rules and Alerts for New Messages BEFORE sending Using Outlook 2
D Outlook Rules Using Outlook 1
Diane Poremsky Autoaccept a Meeting Request using Rules New Slipstick.com Articles 2
K adding more rules to 'different domains check' macro Outlook VBA and Custom Forms 2
Gunny NFOhiway Outlook PST file and Rules Using Outlook 1
M Outlook 2016 Rules Not Working Automatically Using Outlook 5
Diane Poremsky Rules & Alerts Dialog Won't Open New Slipstick.com Articles 1
soadfan Enable all rules from toolbar button? Outlook VBA and Custom Forms 3
oliv- How to Run a Script IN AN ADDIN with Outlook's Rules and Alerts Outlook VBA and Custom Forms 2
P Log of Rules that ran Outlook VBA and Custom Forms 3
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
P Recover / Extract Rules from standalone PST file creating RWZ file Using Outlook 2
T Client-side rules not working, but no error Using Outlook 1
R Missing Quick Steps and Rules Using Outlook 0
Diane Poremsky Delegates, Meeting Requests, and Rules New Slipstick.com Articles 0
A outlook 2007 how to chcek all rules ? Outlook VBA and Custom Forms 2
J Outlook Rules not show Master Category List Using Outlook.com accounts in Outlook 4

Similar threads

Top