Outlook and Access integration using VBA

Status
Not open for further replies.
R

Rhys Davies

Hi there, in our access database i have code that allows a user to create an

outlook appointment, which can be seen below:

Dim objOutlook As Object

Dim objItem As Object

Set objOutlook = CreateObject("Outlook.Application")

Set objItem = objOutlook.CreateItem(olAppointmentItem)

With objItem

> Subject = Title & " " & ": Appointment"

End With

objItem.Display

Set objOutlook = Nothing

however, what would be really useful is if it could go one step further and

open existing calendar items rather thana new item. we have a section on the

access database where users enter activity i.e. work done with a client on a

particular date - it would be really nice if when the user selects a date on

this activity screen that they could also maybe hit a command button that

would open up their outlook calendar on the same date as the date selected

within access itself so they can quicky copy and paste some of the

information that they have previosuly entered in their calendar into their

activity. or even that hitting the button opens up an access form that holds

information from the relevant fields from their outlook calendar - i have

seen this done and have done it myself but the opposite way i.e. you write it

into outlook. unfortunately this now doesnt work for us because we do our

activity retrospectively.

any help would be greatly appreciated
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
In Outlook 2007 the Explorer supports the CurrentView property, whcih

returns a CalendarView object if the current folder is a calendar. And the

CalendarView supports the GotoDate function.

Best regards

Michael Bauer

Am Thu, 25 Mar 2010 06:36:01 -0700 schrieb Rhys Davies:


> Hi there, in our access database i have code that allows a user to create


an
> outlook appointment, which can be seen below:

> Dim objOutlook As Object
> Dim objItem As Object
> Set objOutlook = CreateObject("Outlook.Application")
> Set objItem = objOutlook.CreateItem(olAppointmentItem)
> With objItem
> .Subject = Title & " " & ": Appointment"
> End With
> objItem.Display
> Set objOutlook = Nothing

> however, what would be really useful is if it could go one step further


and
> open existing calendar items rather thana new item. we have a section on


the
> access database where users enter activity i.e. work done with a client on


a
> particular date - it would be really nice if when the user selects a date


on
> this activity screen that they could also maybe hit a command button that
> would open up their outlook calendar on the same date as the date selected
> within access itself so they can quicky copy and paste some of the
> information that they have previosuly entered in their calendar into their
> activity. or even that hitting the button opens up an access form that


holds
> information from the relevant fields from their outlook calendar - i have
> seen this done and have done it myself but the opposite way i.e. you write


it
> into outlook. unfortunately this now doesnt work for us because we do our
> activity retrospectively.

> any help would be greatly appreciated
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
T Render Outlook emails in MS access as they appear in Outlook Outlook VBA and Custom Forms 2
T Outlook "A program is trying to access Outlook" Using Outlook 3
R How can I access my emails from corrupt offline files of MS Outlook ? Using Outlook 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
O Synchronize safe persons Outlook 2016 -> Outlook Web Access (OWA) Using Outlook 30
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
O Outlook Web Access - how to disable spam filter Using Outlook 6
F Outlook 2016 bulk email from access Outlook VBA and Custom Forms 3
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
T Cannot access outlook.com accounts in Outlook 2016 Using Outlook 1
B Can't expose sender email address when linking outlook to access Using Outlook 3
Diane Poremsky Change Outlook's Programmatic Access Options Using Outlook 0
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
C Merging Word and Access into Outlook Using Outlook 4
I Outlook 2016 and Slow access to Outlook.com IMAP Using Outlook 0
B No permission to access Outlook.pst file Using Outlook 1
Norbert VBA Flag that would indicate the email was sent from Outlook to Access. Outlook VBA and Custom Forms 2
U Cannot access fields at bottom of Outlook 2013 Contact Rec. Using Outlook 1
A Synchronize Access Table with Outlook Calendar Appointments Outlook VBA and Custom Forms 3
L Outlook Data Files command not working in the quick access bar Using Outlook 1
Hudas Hyperlink Saved Outlook Email to MS Access Table Using Outlook 4
Hudas Import Outlook Emails(Inbox) to MS Access as Attachment Using Outlook 1
M How do I access a contact list subfolder in Outlook 2013? Using Outlook 5
K how to Access Outlook Contact Properties Using Outlook 1
M Outlook client macro to web access Using Outlook 1
M Access replicated Outlook (email folders, calendar, contacts, notes) via web Using Outlook 1
R Limiting Outlook Access to Inside Network Only Exchange Server Administration 1
J Outlook and owa access Using Outlook 1
O Can't create new email or access email acounts Outlook 2003 Using Outlook 1
C MAPI to access a 64 bit Outlook from a 32 bit application; or access via ODBC Using Outlook 0
C Synchronize outlook with access Using Outlook 1
A Allow Programmatic Access Outlook 2010 Using Outlook 3
M open outlook calendar from an access form Using Outlook 4
M open outlook contacts in access 2007 form Using Outlook 1
J Unable to access public folders in Outlook 2007 on Exchange 2010. OWA PF works fine Using Outlook 7
R Proof Of Looping Bug in Reading Outlook Inbox From Access? Outlook VBA and Custom Forms 2
R Access Program Only Looping Part Way Through Outlook Inbox Outlook VBA and Custom Forms 2
H Exporting Outlook Forms to Access or Excel Outlook VBA and Custom Forms 2
P Access - Outlook Outlook VBA and Custom Forms 2
E Redemption access AppointmentItem Label from outlook Outlook VBA and Custom Forms 6
K Outlook admin vs individual access (VBA pulling info) Outlook VBA and Custom Forms 1
S Sending Email from Access 2007 through Outlook 2007 using template Outlook VBA and Custom Forms 13
D Outlook 2003 - A program is trying to access e-mail addresses Outlook VBA and Custom Forms 5
G Linking Outlook to Access for Contacts in Access Outlook VBA and Custom Forms 3
R Programming Web Outlook Access Outlook VBA and Custom Forms 3
D "Outlook has blocked access to this form template file. Outlook VBA and Custom Forms 3
S Programming Outlook from MS Access (Inbox) Outlook VBA and Custom Forms 1
E trust access to visual basic project greyed out in outlook 2003 Outlook VBA and Custom Forms 1

Similar threads

Top