|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
February 19th 09, 08:09 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Import Macro Access Table to Outlook Contacts
I would like to automate the import of an Access table into a specific folder
in my Outlook Contacts. Can this be done? -- cao 
|
| Ads |
|
#2
February 20th 09, 10:48 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Import Macro Access Table to Outlook Contacts
Yes it can. You need to use (for example) ADO to connect to your Access
database and get a recordset, then use the Outlook Object Model to create a new contact and populate its fields. If this is a one-off exercise you can also use the import wizard in Outlook. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "srctr" wrote: I would like to automate the import of an Access table into a specific folder in my Outlook Contacts. Can this be done? -- cao
|
|
#3
February 23rd 09, 06:26 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Import Macro Access Table to Outlook Contacts
What you said is greek to me. I was hoping that importing into Outlook from
access might be easier then using Access to export addresses into Outlook. I can't seem to find any good and clear explanation on how to do either of these. ADO, DAO, VBA, Macros - no one seems to speak clear about these processes for a newbie to gain knowledge to learn to use these. Is there anyone who can give clear, precise instructions on a way to take email addresses in Access and automate sending an email message to said addresses, allowing for me to manually attach needed file (changes every month) and send message? It really shouldn't be this big complicated coding secret. -- cao "Alan Moseley" wrote: Yes it can. You need to use (for example) ADO to connect to your Access database and get a recordset, then use the Outlook Object Model to create a new contact and populate its fields. If this is a one-off exercise you can also use the import wizard in Outlook. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "srctr" wrote: I would like to automate the import of an Access table into a specific folder in my Outlook Contacts. Can this be done? -- cao
|
|
#4
February 23rd 09, 07:06 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Import Macro Access Table to Outlook Contacts
Have a look at the following web page, it contains all of the information you
need:- http://support.microsoft.com/kb/290658 -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "srctr" wrote: What you said is greek to me. I was hoping that importing into Outlook from access might be easier then using Access to export addresses into Outlook. I can't seem to find any good and clear explanation on how to do either of these. ADO, DAO, VBA, Macros - no one seems to speak clear about these processes for a newbie to gain knowledge to learn to use these. Is there anyone who can give clear, precise instructions on a way to take email addresses in Access and automate sending an email message to said addresses, allowing for me to manually attach needed file (changes every month) and send message? It really shouldn't be this big complicated coding secret. -- cao "Alan Moseley" wrote: Yes it can. You need to use (for example) ADO to connect to your Access database and get a recordset, then use the Outlook Object Model to create a new contact and populate its fields. If this is a one-off exercise you can also use the import wizard in Outlook. -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. "srctr" wrote: I would like to automate the import of an Access table into a specific folder in my Outlook Contacts. Can this be done? -- cao
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linking Access 2003 Table to Outlook 2003 Shared (Exchange) Contacts | Kenneth[_3_] | Outlook - Using Contacts | 1 | June 18th 08 02:36 AM |
| Sync changes in Ms Access table to outlook appointments | keri | Outlook - General Queries | 0 | January 25th 07 08:39 PM |
| import access odbc linked table to outlook | Jeff | Outlook - Using Contacts | 6 | May 12th 06 03:51 PM |
| How do I import email addresses from an Access table? | Chris | Outlook - Using Contacts | 1 | April 7th 06 01:58 PM |
| Link Access Table to Exchange Public Folder Contacts | Brian | Outlook - Using Contacts | 0 | January 29th 06 08:05 PM |
Linear Mode
