Generating Outlook appointments with VBA

Andy Brown
Andy Brown used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
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.
Andy BrownDeveloper

Author

Commented:
Thank you for that.  I still haven't tried it - but it looks like the right tool for the job.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial