Ms Outlook into form

[gstylianou]

Hi,

Is it possible to add an outlook control into ms access form?

Thanks

 

[theDBguy]

Not sure. Maybe try the OLE ActiveX Object control? Good luck!

Edit: I looked, and here are some of the Outlook objects I found on my system.

 

[gstylianou]

Not sure. Maybe try the OLE ActiveX Object control? Good luck!

Edit: I looked, and here are some of the Outlook objects I found on my system.

View attachment 82883

Hi, i tried it already without result. Actually i put the control into form but On Load event i cannot get anything..

 

[Isaac]

What kinds of Outlook things do you want to do on your form?

 

[gstylianou]

What kinds of Outlook things do you want to do on your form?

My inbox and outbox...

 

[Isaac]

You can create a Listbox that loads emails from your Outlook and refreshes them from time to time.

Look into VBA to loop through an Outlook folder and grab attributes of MailItems. I've done this before in Excel, it's been a while.

 

[gstylianou]

You can create a Listbox that loads emails from your Outlook and refreshes them from time to time.

Look into VBA to loop through an Outlook folder and grab attributes of MailItems. I've done this before in Excel, it's been a while.

Can you please give me more instruction on how can i do this because my poor knowledge in vba programming? Should be very helpful for me even one small example file in order to understand it...

I will be very appreciated

 

[Gasman]

Can you please give me more instruction on how can i do this because my poor knowledge in vba programming? Should be very helpful for me even one small example file in order to understand it...

I will be very appreciated

Why not start off with simple steps?

Link Microsoft Access Databases to Microsoft Outlook Inbox, Calendar, Contacts and Tasks

Link Data from Microsoft Outlook directly into your Microsoft Access Database to get emails, contacts, calendar items, and tasks

www.fmsinc.com

 

[Isaac]

Attached is an example. Form Load event. Loads inbox emails into form listbox. In this example I'm not readily familiar with how to grab the outlook namespace using late binding (strongly preferred for deploying databases to diverse users), so I checked a reference to Microsoft Outlook.

 

[gstylianou]

Attached is an example. Form Load event. Loads inbox emails into form listbox. In this example I'm not readily familiar with how to grab the outlook namespace using late binding (strongly preferred for deploying databases to diverse users), so I checked a reference to Microsoft Outlook.

Thank you very much, i will study your code and your idea and if i will need more help i'll be back. But, the idea is to load the outlook as is it into my form....

Anyway, thank you very much again

 

[Isaac]

If you actually mean duplicate the entire outlook interface.....Inbox, Calendar, Todo list, reading pane, onto an Access form, that might be a tall order. (not to say it can't be done).

Good luck with the project

 

[gstylianou]

If you actually mean duplicate the entire outlook interface.....Inbox, Calendar, Todo list, reading pane, onto an Access form, that might be a tall order. (not to say it can't be done).

Good luck with the project

yes, actually i want Inbox, Calendar, Todo list, reading pane, onto an Access form..

 

[theDBguy]

yes, actually i want Inbox, Calendar, Todo list, reading pane, onto an Access form..

Hi. The only thing I could think of, to make it easier, is to use a web browser control and point to the online version of your Outlook. Just a thought...

 

[The_Doc_Man]

I understand you want those functions in Access, but the truth is that after a while you would do better to just launch Outlook. The biggest cost of having to reinvent the wheel is all of the square wheels you end up building until you finally get it right - whereas it is already right in Outlook.

 

[Gasman]

I understand you want those functions in Access, but the truth is that after a while you would do better to just launch Outlook. The biggest cost of having to reinvent the wheel is all of the square wheels you end up building until you finally get it right - whereas it is already right in Outlook.

There goes my idea for an Access form to type in commands for my Google Minis, rather than speaking to them then.