Search results

This is an addition to modOutlook and shows a function to return Outlook as an Object whether or not Outlook is open or not. 'Globals Public gnErr As Long 'Last err number Public gsErr As String 'Last error message Public gsPrompt As...

I was trying to find out what prevents posting: it's a hyperlink in the code to a Microsoft site I found useful in the development!

This shows how to transfer contact data from Outlook to an Access table. Copy this code into modOutlook. '27 May 2020 'Fully comprehensive method of putting contacts into a temporary table 'Requires loads of support functions Function apContactFetchFromOutlook() As Integer 'Import Outlook...

Below is a whole module's worth of Outlook and support routines. I've put them here in three modules: modFunctions, modOutlook and modVARS. The first is a simple way to look at the field headings that Outlook uses for People, Outlook's name for Contacts, and how they are used in VBA code...

I hope that this will help you. The names of the fields that Outlook uses are different to the column headings in the People (Contacts) section of Outlook 2016. Paste the following code into a new module and step though it with the Locals window open and open the oContact section to see all the...

I've retired from Access Database work. I have loads of routines that I want to publish in order to help others and save them hundreds of frustrating hours of VBA coding. So in January, I created a website on Google Sites thinking that Google would crawl all over it and this would benefit others...