VBA in Outlook Help

TheShaunMichael

Board Regular
Joined
Oct 24, 2009
Messages
57
I have some VBA written in an Excel Workbook that controls some functionality inside of Outlook (ie writes messages).

What I need to do is create a macro entirely in Outlook that will turn a message into a calendar appointment. The calendar appointment will always be for 9:30am, BUT the date of the appointment is to be found in the body of the email. Is there a way to do this?

The emails are auto-generated from salesforce.com and therefore are always setup in the same fashion:


New Task



To: Shaun Walker

Shaun Walker has assigned you the following new task:

Subject: Call
Contact: Joe Smith
Due Date: 2/21/2012
Priority: Normal

For more details, click the following link:

https://na2.salesforce.com/00T4000001h5Vof
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Apologies! I don't think I was very clear on the first go around.

I'm trying to create a macro that lives IN outlook exclusively.
 
Upvote 0

Forum statistics

Threads
1,214,835
Messages
6,121,880
Members
449,057
Latest member
Moo4247

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top