Saving Contacts from Database to Outlook using Macro.

[BillyBalou]

I'm trying to create a macro which saves information from a contact/company
query into my Outlook 2007. I tried to copy the button from the Contacts
Template and I tried to create my own using RunCommand and the SavetoOutlook
action. Both times an error message came up saying that my database was read
only or that it was a previous version. I don't understand, as I'm using
Access 2007. In general what is a practical way to save an individual contact
from an Access forms or Query to Outlook as user enters into database. Up
till now I have been converting into excel and matching but I am having
trouble with importing email adddresses into outlook from database as they
always import with #mailto....# attached and i have to edit after the fact. I
also don't want to send every contact each time I export. Thought button as
mentioned above would be best??

 

[Pete D.]

This new 2007 feature is not very well documented although it is actually
rather easy to do as long as you know the rules. It also works with MS
Share Point and knowing this you can now find some info on using it. Both
VBA RunCommand acCmdAddFromOutlook and acCmdSaveAsOutlookContact or the
runcommand macro provides the ability. The Blog link below provides info on
how it works and the link Steps to make it work provides pictures and steps
to follow. First time I tried it in my new empty data file I received the
same read only and previous version error however using the MS template
didn't produce the error. The key to the whole process is making sure
Access knows how to map fields in your table to those in Outlook contacts.
Anyway, I'm no expert on it but have it working just fine. I think for now,
I'll stick with my old VBA code which provides me more flexibility but for a
quick import/export on a button this new feature works okay. Pete D.

You may find these useful to solve your problem.

This link is translated from Spanish through Google. Steps to make it work.
http://translate.google.com/transla...n-access-2007.aspx&sl=es&tl=en&hl=en&ie=UTF-8

Access Team Blog

Integrating Access Contacts with Outlook and SharePoint

http://74.125.93.104/translate_c?hl...k.aspx&usg=ALkJrhhG1NlILB5SoMPlgtHk4NKJEhnYzQ



http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1464954&Main=1464035
http://blog.blanar.net/files/OFF307_Covington.ppt

 

[BillyBalou]

This new 2007 feature is not very well documented although it is actually
rather easy to do as long as you know the rules. It also works with MS
Share Point and knowing this you can now find some info on using it. Both
VBA RunCommand acCmdAddFromOutlook and acCmdSaveAsOutlookContact or the
runcommand macro provides the ability. The Blog link below provides info on
how it works and the link Steps to make it work provides pictures and steps
to follow. First time I tried it in my new empty data file I received the
same read only and previous version error however using the MS template
didn't produce the error. The key to the whole process is making sure
Access knows how to map fields in your table to those in Outlook contacts.
Anyway, I'm no expert on it but have it working just fine. I think for now,
I'll stick with my old VBA code which provides me more flexibility but for a
quick import/export on a button this new feature works okay. Pete D.

You may find these useful to solve your problem.

This link is translated from Spanish through Google. Steps to make it work.
http://translate.google.com/transla...n-access-2007.aspx&sl=es&tl=en&hl=en&ie=UTF-8

Access Team Blog

Integrating Access Contacts with Outlook and SharePoint

http://74.125.93.104/translate_c?hl...k.aspx&usg=ALkJrhhG1NlILB5SoMPlgtHk4NKJEhnYzQ



http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1464954&Main=1464035
http://blog.blanar.net/files/OFF307_Covington.ppt







Thanks Pete,

I will try this tomorrow at work, my abilty with VBA is very slight at this
point, but I will try with Macro and give VBA a shot as well. I was wondering
how to match fields with the macro...should I just make sure they all read
from the form exactly as they are in named in Outlook??

 

[Pete D.]

If you use the wizard it will create the table and form for you. Other than
that way the Blog web provides the code to match the fields. Read the first
two links I included, they will walk you through.

 

[BillyBalou]

Once again Pete D., thanks so much. This will really help.