Using VBA to Utilize Outlook in Access

[Don]

Any suggestions on sites, books, and references for using Outlook from
Access using VBA? (Sending reminders, building distribution lists, etc.)
Microsoft's online documentation is lacking (at least what I could find) on
end-to-end examples. Is Sue Mosher's book (Microsoft Outlook Programming)
any good? (The web site for the book seems to be having problems right at
the moment.)

Any suggestions will be greatly appreciated!

Thanks!

Don

 

[John Nurick]

Hi Don,

The great thing is that programming Outlook from Access is very very
similar to proramming Outlook from within Outlook (or any other Office
application). www.outlookcode.com and www.slipstick.com are excellent
places to start.

 

[Don]

Thanks John!

Don

Hi Don,

The great thing is that programming Outlook from Access is very very
similar to proramming Outlook from within Outlook (or any other Office
application). www.outlookcode.com and www.slipstick.com are excellent
places to start.

 

[askjerry]

Don,
Try this microsoft hyperlink for sample code
http://support.microsoft.com/?kbid=170320#XSLTH3128121122120121120120
It shows how to import data from Access to Outlook. To export you would
reverse things and loop through a set of Outlook.items and write to
Access records.

Jerry

 

[Don]

Thanks Jerry!

Don