In each statement, the target field needs to be on the left side of the
statement, the source data on the right. So statements like this copy the
data from the Manager field into the Rep field:
objItem.UserProperties("Rep") = objItem.Manager
What happens when you try to step through the code in VBA?
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
> Hi Sue,
>
[quoted text clipped - 160 lines]
> >
> >.
Betty - 31 Jul 2004 19:51 GMT
Awesome! Thanks for the reply! I am now trying to apply
this new concept. As I understand it, the code I am
trying to edit has two purposes: 1 to actually pull the
info from the excel spreadsheet 2 to pull the info from
Outlook fields into my user defined field names.
Is that correct? If so, which portion of the code is used
for pulling the info from Outlook field names into user
defined fields? (I have already "parked" the data in
Outlook fields by Custom mapping and now just need to pull
it from there into my fields. Will let you know how this
works out today.
Thanks again!
>-----Original Message-----
>In each statement, the target field needs to be on the left side of the
[quoted text clipped - 177 lines]
>
>.
Sue Mosher [MVP-Outlook] - 31 Jul 2004 20:47 GMT
The code statement in my last post is an example of pulling information from
a built-in Outlook field into a custom property.

Signature
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
> Awesome! Thanks for the reply! I am now trying to apply
> this new concept. As I understand it, the code I am
[quoted text clipped - 206 lines]
> >
> >.
Betty - 31 Jul 2004 19:59 GMT
I get this response "Object doesn't support this property
or method" in a pop up window and the script opens up. I
am looking at the Field names where i "parked' the data
and it doesn't seem to like field names that have spaces
and or apostrophes for instance my data for Rep
is "parked" in the Outlook field named: "Manager's Name"
Outlook's VPS doesn't seem to like that.
>-----Original Message-----
>In each statement, the target field needs to be on the left side of the
[quoted text clipped - 177 lines]
>
>.
Sue Mosher [MVP-Outlook] - 31 Jul 2004 20:48 GMT
Which statement triggers that message? In general, yes, you should stay away
from using apostrophes in property names, because it can be difficult to
distinguish an apostrophe from a quotation mark limiting a string.

Signature
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx
> I get this response "Object doesn't support this property
> or method" in a pop up window and the script opens up. I
[quoted text clipped - 3 lines]
> is "parked" in the Outlook field named: "Manager's Name"
> Outlook's VPS doesn't seem to like that.