Export with Outlook Invite as attachment?

[Aweiher]

No I have not yet figured out how to send an appointment via access

Testing this feature out

[sstiebinger]

Since you are trying to email the event, I wouldn't use the outlook object directly, I would create an iCalendar file then send that as an attachment in an email via outlook automation.

[sstiebinger]

here's a link for some code to do it from Excel... you'll have to modify and extend it for your needs.

http://www.gsericksen.com/2015/03/ex...calendar-file/

[Aweiher]

vicsaccess no I have not yet figured out how to email the appointments from access. I'm starting to wonder if it's even possible.

[sstiebinger]

Did you look at the iCalendar option?
Seems pretty easy to create an iCal file, then use outlook integration to generate an email and attach the iCal file.

[vicsaccess]

sstiebinger, do you have any examples? not sure about aweiher but i'm not familiar with doing that. i have done a little research on this in the past and like i said it would be one of those nice things to have but until i get time to research it its on the back burner. most everything i have read though always points to this book.
Sue Mosher's outstanding Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators
search it on google and you'll see it sold several places. keep me up to date please

[sstiebinger]

Per the link I posted earlier on creating an icalendar file with VBA or a number of quick google searches on creating an icalendar file.
The link I posted earlier is written for Excel, but should give enough of a starting point to generate similar code for Access.

The iCal file has nothing to do with outlook and is fairly trivial to set up.

Once the file is created, you would then connect to outlook to generate a new email message and attached the file you just created.
Creating an email and attaching a file are common tasks that are automated in Outlook and you should be able to find any number of examples with a google search.

For instance:
http://stackoverflow.com/questions/1...ith-attachment

[Aweiher]

Oh man I'm not messing with Ical files. I'm going to give up on this one. The code I got earlier about adding an appointment to my outlook with a click of a button was pretty useful. Can I mark a threat "Sort of Solved"? lol

[sstiebinger]

You can add to that user's reputation by clicking the little sheriff's badge icon below their post.

[vicsaccess]

Did you have a chance to look into that book i suggested? my understanding is that it is about the best at working access with outlook. not sure when i will be able to start looking into this but that was the best place for knowledge to do it that everyone suggested.