[AccessD] Export Access Data to Custom Outlook Fields/Columns

Bob, take a look at Sue Mosher's OutlookCode site.  Do not know if you'll be able to use built-in functions or write your own VBA code to get the correct syntax (e.g. myItem.UserProperties("Field1") = "new value") to work.  Hopefully this will help you out.

http://www.outlookcode.com/article.aspx?id=38

John

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Access Pro
Sent: Friday, May 03, 2013 4:31 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Export Access Data to Custom Outlook Fields/Columns

Thanks for the response.
No, it is the same whether I link or import. The custom fields I created in outlook are not available/present in Access.
They are however avail in "view" in Outlook...

Anyone?

Bob

 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson
Sent: Wednesday, May 01, 2013 9:53 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export Access Data to Custom Outlook Fields/Columns

Try the other direction as id you were importing from the table in outlook and see what outlook offers as field names when you link to it and import from it. Maybe the names will appear different or are aliased.
On Apr 28, 2013 3:16 PM, "Access Pro" <accesspro at cox.net> wrote:

>
> Hello to the list,
>
> I have a need to append data to an attached table in A2010.
> The attached table is an Exchange/Outlook table.
> I am able to do except for the custom fields/columns I have added in 
> Outlook.
> These columns are visible in Outlook. I can add data in Outlook.
> But when I add one of these to my append query, it blows up.
> "The INSERT INTO statement contains the following unknown field name:
> 'Phone
> Cellular Spouse'. Make sure you have typed the name correctly, and try 
> the operation again."
>
>
>
> Tia
>
> Bob Heygood
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com