export email addresses to Outlook Ricky11 03.08.2006 00:39:02 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? -- Rick

Re: export email addresses to Outlook John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 03.08.2006 05:11:36 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 On Wed, 2 Aug 2006 17:39:02 -0700, Ricky11 <Ricky11[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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 [Microsoft Access MVP] Please respond in the newgroup and not by email.

Re: export email addresses to Outlook Ricky11 05.08.2006 01:30:02 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. -- Rick "John Nurick" wrote: [Quoted Text] > 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 > > > > On Wed, 2 Aug 2006 17:39:02 -0700, Ricky11 > <Ricky11[ at ]discussions.microsoft.com> wrote: > > >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 [Microsoft Access MVP] > > Please respond in the newgroup and not by email. >

Re: export email addresses to Outlook John Nurick <j.mapSoN.nurick[ at ]dial.pipex.com> 05.08.2006 08:56:21 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. On Fri, 4 Aug 2006 18:30:02 -0700, Ricky11 <Ricky11[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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 [Microsoft Access MVP] Please respond in the newgroup and not by email.