Re: Append query to Outlook contacts

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).


On Sat, 20 Jan 2007 15:40:13 -0800, llamadave
<llamadave@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

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


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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.