Solved

Generating Outlook appointments with VBA

Posted on 2012-12-21
3
370 Views
Last Modified: 2013-01-25
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
Comment
Question by:Andy Brown
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 38713349
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 38715377
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
 

Author Closing Comment

by:Andy Brown
ID: 38819536
Thank you for that.  I still haven't tried it - but it looks like the right tool for the job.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
Scam emails are a huge burden for many businesses. Spotting one is not always easy. Follow our tips to identify if an email you receive is a scam.
To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now