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
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
If you are creating the message in Excel VBA can't you add the Outlook Appointmant at the same time?
 

TheShaunMichael

Board Regular
Joined
Oct 24, 2009
Messages
57
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.
 

Forum statistics

Threads
1,085,171
Messages
5,382,125
Members
401,773
Latest member
BredAnderson

Some videos you may like

This Week's Hot Topics

Top