• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

Generating Outlook appointments with VBA

Hi All, I have an Access database that can generate iCalendar and vCalendar files, which are then sent to the relevant parties and added to whichever system they are using.  

However, I want to be able to generate a file that I can send out, which also has the "Accept", "Decline" options (Outlook calls it 'Invite Attendees').  Is this possible?

Thanks as always for the help.
0
Andy Brown
Asked:
Andy Brown
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you're willing to spend a small bit of money, you can use vbMAPI from www.everythingaccess.com. I started using this for any Outlook requirements in my Access projects, and it's been a great investment. Note I have on affiliation with this product other than being a satisfied customer.

If you're not looking to do that, then perhaps this link will help:

http://bytes.com/topic/access/answers/200177-problem-automatically-sending-outlook-appointment-generated-vb-access-97-a

The author there indicates that you must change the appointment item to a Meeting:

objAppt.MeetingStatus = Outlook.OlMeetingStatus.olMeeting

Also, when you ask questions like this it's always a good idea to include the code that you're using to generate these items.
0
 
Andy BrownAuthor Commented:
Thank you for that.  I still haven't tried it - but it looks like the right tool for the job.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now