Hi,

I want to doubleclick a name in a calender in outlook and - via an eventhandler - send this name to Access where the name is seached and found together with the persons other data in access. Is that possible? Maybee a link to a codesnippet in VBA that do the trick? Or maybee a good book telling me how outlook and access can work together?

Thank you
Lars - DK

EggHeadCafe - Software Developer Portal of Choice
Visual Studio.NET 2005: System.Net Mail Basics
http://www.eggheadcafe.com/tutorials...et-2005-s.aspx

You wouldn't double click a name but an AppointmentItem in a calendar, which
triggers the NewInspector event. That would be where you read the item's
properties and connect to your database.

For the available properties see the object browser (f2), select the
AppointmentItem in the left pane.

For connecting to an Access database I'd use the 'Microsoft ActiveX Data
Objects x Library'. Here's an examle for how to connect to the db:
http://www.vboffice.net/sample.html?...7&cmd=showitem

For the other stuff see an ADO help file: Look for how to use the Recordset
object, and how to use the SQL statement 'Select'.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: http://www.vboffice.net/product.html?pub=6&lang=en


Am Wed, 04 Nov 2009 01:09:28 -0800 schrieb Lars Frederiksen:

Hi,

I want to doubleclick a name in a calender in outlook and - via an
eventhandler - send this name to Access where the name is seached and found
together with the persons other data in access. Is that possible? Maybee a
link to a codesnippet in VBA that do the trick? Or maybee a good book
telling me how outlook and access can work together?

Thank you
Lars - DK

EggHeadCafe - Software Developer Portal of Choice
Visual Studio.NET 2005: System.Net Mail Basics

http://www.eggheadcafe.com/tutorials...et-2005-s.aspx