PCWorld Forums

PCWorld Forums: Outlook Macro For Generating An Appointment - PCWorld Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Outlook Macro For Generating An Appointment

#1 User is offline   gangi 

  • Newbie
  • Pip
  • Group: New Member
  • Posts: 1
  • Joined: 25-January 12

Posted 25 January 2012 - 05:55 AM

Hi Team,

First thanks for your free support.

My doubt is as follows:

When I have created a macro in Outlook under the "This Outlook Session", it will create an appointment when specific subject mail comes and hits my inbox.

But am unable to implement it when i have 2 or 3 different subjects from different users.I want either of the three subjects hitting my outlook from different users should create an apointment.

Below is the part of my code for your reference.

If TypeName(Item) = "MailItem" Then

changecase = LCase(Item.Subject)

If InStr(changecase, "Sub-1") > 0 Then

If SenderEmailAddress = " 123@xyz.com" Then

With olApt
.AllDayEvent = True
.Subject = "Sub-1"
.Location = "Desk"
.Start = Date + (TimeValue(Now) + TimeValue("00:15:00"))
.End = .Start + TimeValue("00:30:00")

Note:
Please take subjects as sub-2 and sub-3.
the above e-id mentioned is dummy one.tell me how to add different e-id's.

Thanks,
Gangi.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users