Closed

Outlook Visual Basic Script Macro for Automated Email Forwarding

This project was awarded to whitelotusvn for $60 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
2
Project Description

I get Google Alerts sent to my gmail account, which are automatically
forwarded to my home account (where I use Outlook 2007). I want to set up a macro script in Outlook that automatically re-arranges the text and subject of these alerts and then forwards them to a third account.

For instance, let's say I get the following alert forwarded to me:

-------
From: Google Alerts
To: <swimmingnews> (the gmail account)
Subject: Google Alert - swimming

Body:
Google News Alert for: swimming
Swimming is fun, say researchers
Connecticut Post - Bridgeport,CT,USA
Scientists at the international swim factory have published a report detailing the fun of swimming. In the report, they claim that ...
See all stories on this topic
________________________________________
This once a day Google Alert is brought to you by Google.
Remove this alert.
Create another alert.
Manage your alerts.
-------


I would like Outlook to change it to:

-------
Subject: Swimming is fun, say researchers

Body:
Swimming is fun, say researchers
Connecticut Post - Bridgeport,CT,USA
Scientists at the international swim factory have published a report detailing the fun of swimming. In the report, they claim that ...


-------

and then mail it to <newaccount>. For the Google Alerts, the new subject will always be on the second line of the original message, and will also be hyperlinked to the news article. I'd also like to preserve the hyperlink in the new message.

Basically, I'm trying to figure out how to write a macro that deletes the first line of an email, changes the subject, deletes everything from "See all new stories...", and then sends the new message to a third account. It should do this automatically as alerts arrive, but only for those addressed to <swimmingnews> gmail account.

I will pay for a working outlook macro that does this automatically.
Signing up for your own google alert is probably the easiest way to figure it out. For instance, you could create a gmail account that gets the alerts and automatically forwards them to your own outlook account. Then, you could have your script forward everything to a second gmail account. This probably isn't more than a few hours of work, less if you know what you're doing.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online