export email addresses to Outlook

[Guest]

How can I export email addresses and the other info (phone, address, city,
state, etc) to Outlook? I can build a query having all the fields I need,
but what do I do with the results?

 

[John Nurick]

Hi Ricky,

You can use Outlook's File|Import menu command (maybe first exporting
the data from Access to a CSV file), or - to have full control over what
happens - use Automation to create Outlook Contact objects from Access
VBA, as described at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp

 

[Guest]

Thanks John! I am trying the 2nd option. I have added the Outlook 11 to my
references and "changed" Office in the control panel; pasted the
sbSendMessage into a module. When I run or try to test as suggested I get a
"user-defined type not defined" error pointing to DIM objOutlook As
Outlook.Application and checking relationships it appears that the reference
is there ok. Do you have any ideas why I might be getting this?

By the way - perfect article for what I need.

 

[John Nurick]

Hi Ricky,

Outlook 11 implies Office 2003: that is the version you're using, isn't
it? Assuming that's the case, there are still various things that can go
wrong with references: see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html for details
and fixes.