Auto-forwarding an Email received from a specific Email address After slight modifications

Status
Not open for further replies.

Nebu

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
Hi All:

Need some help with outlook macro...

I get emails from an id: someone@example.com

Subject line of these emails will be in three formats as below:

1.Industrial Production NSA YoY FALLS x% {IT}
2.(Surprise) Industrial Production MoM RISES x% {IT}
3.*CORRECTION* Industrial Production NSA YoY FALLS x% {IT}

Whenever I receive email from this email id, I want to

1.Modify the subject line by adding country name (based the code at the end of the subject: {IT} = Italy) as below:

a.Italy Industrial Production NSA YoY FALLS x% {IT}
b.(Surprise) Italy Industrial Production MoM RISES x% {IT}
c.*CORRECTION* Italy Industrial Production NSA YoY FALLS x% {IT}

2.Delete unnecessary content from the email

Example of email body below….I want only the part that is highlighted in Red

--- Original Sender: xxx xxx, xxxxxxxxx/ 000 xxx ---

----- Original Message -----

From: xxx xxx (xxxxxxxxx/ 000 xxx)

To: xxxxxx xxxxxxx (xxxxxx xxxxxx xx)

At: 1/13 4:00:00

Industrial Production NSA YoY (Italy) {IT}

OBSERVATION PERIOD: xxx(Monthly)

ACTUAL : -000000

PRIOR : -000000

REVISED : --

SURVEY : -- (Mean: --, High: --, Low: --)

To view breakdown of survey numbers by economist: {xxxxxx xxxxx}

To view Economic Forecast for this country: {xxxx xxx}

Chart and details: {xxxxxx xxx}

To change your alert settings: {00} and click on alert icon

To manage this alert in ALRT: {xxxx xxxx}


3.Then forward this to a distribution list eg: someone@example.com

I get around 100 such emails…any help to automate the process would very helpful…


Thanks in Advance
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange

Nebu

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
Hi Diane:

Thanks for your reply. I am having around 10 countries and loads of question :)

Is it possible to set up the whole macro in the outlook itself? May be create a sub-folder in the inbox and set a rule to deliver all the messages that come from a particular mail id to be moved to that folder and trigger the macro whenever a new mail gets moved to this sub-folder?

Is it going to slow down my outlook if i set up the macro like that?

I am good with excel macro , but a newbie with outlook macros. I did an extensive internet search but could not find any plausible solutions. I tried accessing the link you have shared, but for some reason my office system is not allowing me to access the URL.

Thanks
Nebu
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Is it possible to set up the whole macro in the outlook itself? May be create a sub-folder in the inbox and set a rule to deliver all the messages that come from a particular mail id to be moved to that folder and trigger the macro whenever a new mail gets moved to this sub-folder?
Yes, you can do this using an itemadd macro that watches the folder. No, it shouldn't slow outlook down, but it really depends on the macro.

The basics of an itemadd macro is here - http://www.slipstick.com/developer/processing-incoming-e-mails-with-macros/ - but I have many code samples on my site. The macro no this page watches a shared mailbox and sends a message -http://www.slipstick.com/developer/code-samples/process-items-shared-mailbox/
 

Nebu

New Member
Outlook version
Outlook 2010 64 bit
Email Account
Exchange Server 2010
Yes, you can do this using an itemadd macro that watches the folder. No, it shouldn't slow outlook down, but it really depends on the macro.

The basics of an itemadd macro is here - http://www.slipstick.com/developer/processing-incoming-e-mails-with-macros/ - but I have many code samples on my site. The macro no this page watches a shared mailbox and sends a message -http://www.slipstick.com/developer/code-samples/process-items-shared-mailbox/
Hi Diane:

Thanks a lot, for your reply. I have manged to modify the body of the email and get the email to forward to the respective email IDs . I will have to play around a bit more and test it extensively before implementing it. I will surely post it here if I succeed . Thanks again for all your valuable suggestions and guidance.

Regards
Nebu
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
B Outlook 2003 randomly not auto forwarding Using Outlook 0
C Problem auto-forwarding Outlook emails from shared inbox Using Outlook 1
R Auto display of new email does not work on non-default account Outlook VBA and Custom Forms 0
B Outlook 2016 Auto-archive creates new folder Using Outlook 4
J Edit auto-complete list in Outlook 2016+/365? Using Outlook 0
P Auto assign shared mailbox Outlook VBA and Custom Forms 1
M Outlook 2010 Problem with OutLook 2010 32 bit, after Windows Auto Update Using Outlook 3
P [SOLVED] Auto remove [EXTERNAL] from subject Using Outlook 10
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
N Disable Auto Read Receipts sent after using Advanced Find Using Outlook 4
Q Prompt button to auto turn on Out of Office Outlook VBA and Custom Forms 3
P Auto Insert Current Date or Time into Email Subject Outlook VBA and Custom Forms 2
S Messages moved / deleted by auto-archive are not synchronized to exchange Exchange Server Administration 8
B Outlook 2010 is Auto Purging when not configured for that Using Outlook 1
M VBA to auto forward message with new subject and body text Outlook VBA and Custom Forms 8
A Auto Accept Meetings from the General Calendar Using Outlook 3
R auto send email when meeting closes from a shared calendar only Outlook VBA and Custom Forms 2
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
M Auto expand Distribution List Before Sending Email Outlook VBA and Custom Forms 1
M Auto-export mail to Excel Outlook VBA and Custom Forms 2
Ms_Cynic Auto-pasting email content in calendar appt? Using Outlook 2
R How Do I insert images in and Auto Reply Using Outlook 3
S Received mail as part of DL, need to auto-CC the same when replying Outlook VBA and Custom Forms 5
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
P Auto scroll to specific folder in Folder Pane Outlook VBA and Custom Forms 3
C Auto categorize duplicate subjects Outlook VBA and Custom Forms 11
N Auto-complete - block select emails Using Outlook 3
C Auto save outlook attachments when email is received Outlook VBA and Custom Forms 1
J HELP- Rule to auto strip prepend from external emails Using Outlook 0
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
G Auto accept meeting request for non primary account Outlook VBA and Custom Forms 1
J Outlook Rules - Changing auto-submit address in multiple rules, according to rule name Outlook VBA and Custom Forms 0
E Outlook Form - Voting Responses Not Auto Processing If Form Contains Any Code Outlook VBA and Custom Forms 0
J Auto Forward - Include Attachment and change Subject depending on original sender Outlook VBA and Custom Forms 3
K Extract email address from body and auto-reply outlook Using Outlook 1
S Auto move search results to folder Outlook VBA and Custom Forms 0
E Outlook 2010 disable date auto-complete Using Outlook 2
C Auto subject,name,email,deferred Using Outlook 2
ashcosta2 Auto Reply rule based on speficied time Outlook VBA and Custom Forms 0
B Auto Preview Attachment in Inspector Reading Pane Outlook VBA and Custom Forms 1
Z Auto Forward Using Outlook 4
M can anyone recommend an alternative to DS auto-followup? Using Outlook 2
S Rules to auto redirect Using Outlook 5
B Auto Save of Attachments from Multiple Emails and forward attachments to user group Outlook VBA and Custom Forms 1
A Auto Insert of filename when selecting 'Remove Attachment' Using Outlook 1
C Auto Add a PDF to an outgoing Email, based on a rule Using Outlook 2
B Auto open PDF Outlook VBA and Custom Forms 0
P Is it possible to convert address book to "Auto-Complete List" (NK2)? Using Outlook 5
B Auto name checking upon Tab or Click off To field(s) Using Outlook 19
Similar threads


















































Top