Append query to Outlook contacts

[Guest]

I store addresses from my web order form in an Access database and then want
to export them to Outlook contacts so I can print postage with stamps.com
software that works well with Outlook. I have successfully made linked table
to the contacts file and can modify existing records, but I cannot add new
records with an append query. I get the message: "You do not have the
nessary permissions to use the "object." The object name is not given and I
assume it is not an Access permissions problem since all objects have Admin
permissions. My guess is this is to keep viruses from adding to contacts and
sending lots of email. My Stamps.com software can add contacts without a
problem. Anything I can do to make this work?

Thanks.

David

 

[John Nurick]

Hi David,

You may need to use VBA code to create Outlook contacts from the Access
database. The sample code at http://support.microsoft.com/?kbid=290658
is designed to run in Outlook and get data from Access, but could
easily be modified to run in Access.

But unless you've already researched it and found it can't be done, I
suggest you start by investigating whether the stamps.com software can
get what it needs from the database (or from a CSV or XLS file exported
from the database).

 

[Guest]

Thanks, John. My orders come in one at a time and I don't want to be
bothered with a separate export/import operation each time. Stamps.com uses
its own dBase address list as well as Outlook and I have managed to add
records to that, but it won't accept changes while the software is running,
so if I make a change in an address in Access, I have to stop and start the
stamps.com software (a very slow process). With Outlook I can make changes
and they show up immediately in both Outlook and Stamps.com software. I am
new to VBA code but I will give that a try!

David

--
-----------------
Llamadave
www.RediPix.com

Hi David,

You may need to use VBA code to create Outlook contacts from the Access
database. The sample code at http://support.microsoft.com/?kbid=290658
is designed to run in Outlook and get data from Access, but could
easily be modified to run in Access.

But unless you've already researched it and found it can't be done, I
suggest you start by investigating whether the stamps.com software can
get what it needs from the database (or from a CSV or XLS file exported
from the database).