Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Baffled... (http://www.outlookbanter.com/outlook-vba/15947-baffled.html)

M Scott S May 26th 06 02:33 PM

Baffled...
 
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the right
hand lower portion where the user can enter as much free form text as they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...

HELP!!!

thanks.

--
M Scott Schaffernoth
Winnovative
Hudson, NY




Sue Mosher [MVP-Outlook] May 26th 06 02:47 PM

Baffled...
 
Attachments are in the Attachments collection of the ContactItem. You will need to save each attachment as a file before you can do anything with it. Embedded Outlook items are the most difficult to extract; see http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message ...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the right
hand lower portion where the user can enter as much free form text as they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...

HELP!!!

thanks.

--
M Scott Schaffernoth
Winnovative
Hudson, NY




M Scott S May 26th 06 05:39 PM

Baffled...
 
Sue - looking at the code that you mention, it almost looks like embedded
items are not 'safe'...

Having poked through the code I have written, the items that are in fact not
allowing me to export to a file are 'emails' attached to a contact record in
the 'notes' (body) field, they return a class of 5 (olAttachment) and a type
of 5 (OlEmbeddedItem)...

Does this mean that even with Redemption, these items just cannot be pulled
out of Outlook programmatically?

It seemed like the embedded items were the exception in code 523 example...

Thanks!


--
M Scott Schaffernoth
Winnovative
Hudson, NY

"Sue Mosher [MVP-Outlook]" wrote in message
...
Attachments are in the Attachments collection of the ContactItem. You will
need to save each attachment as a file before you can do anything with it.
Embedded Outlook items are the most difficult to extract; see
http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message
...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the
right
hand lower portion where the user can enter as much free form text as they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...

HELP!!!

thanks.

--
M Scott Schaffernoth
Winnovative
Hudson, NY






M Scott S May 26th 06 05:41 PM

Baffled...
 
Sue - looking at the code that you mention, it almost looks like embedded
items are not 'safe'...

Having poked through the code I have written, the items that are in fact not
allowing me to export to a file are 'emails' attached to a contact record in
the 'notes' (body) field, they return a class of 5 (olAttachment) and a type
of 5 (OlEmbeddedItem)...

Does this mean that even with Redemption, these items just cannot be pulled
out of Outlook programmatically?

It seemed like the embedded items were the exception in code 523 example...

Thanks!


--
M Scott Schaffernoth
Winnovative
Hudson, NY


"Sue Mosher [MVP-Outlook]" wrote in message
...
Attachments are in the Attachments collection of the ContactItem. You will
need to save each attachment as a file before you can do anything with it.
Embedded Outlook items are the most difficult to extract; see
http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message
...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the
right
hand lower portion where the user can enter as much free form text as they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...

HELP!!!

thanks.

--
M Scott Schaffernoth
Winnovative
Hudson, NY






Sue Mosher [MVP-Outlook] May 26th 06 06:06 PM

Baffled...
 
It should be possible to do it with Redemption using the technique demonstrated in the code sample.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message ...
Sue - looking at the code that you mention, it almost looks like embedded
items are not 'safe'...

Having poked through the code I have written, the items that are in fact not
allowing me to export to a file are 'emails' attached to a contact record in
the 'notes' (body) field, they return a class of 5 (olAttachment) and a type
of 5 (OlEmbeddedItem)...

Does this mean that even with Redemption, these items just cannot be pulled
out of Outlook programmatically?

It seemed like the embedded items were the exception in code 523 example...



"Sue Mosher [MVP-Outlook]" wrote in message
...
Attachments are in the Attachments collection of the ContactItem. You will
need to save each attachment as a file before you can do anything with it.
Embedded Outlook items are the most difficult to extract; see
http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

"M Scott S" wrote in message
...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the
right
hand lower portion where the user can enter as much free form text as they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...



M Scott S May 26th 06 08:50 PM

Baffled...
 
Sorry, but it's over my head. I am struggling enough with Outlook's model,
let alone introducing yet another...

I am driving this from access, not outlook.

I don't need code for all the various data types as I am handling that, I
just want to be able to pull out an embedded email msg and save it as a file
to the windows file system...

Is there no way to do that with Outlook's object model? It's simple enough
with the other stuff, what's the magic that makes this such a challenge...?


--
M Scott Schaffernoth
Winnovative
Hudson, NY


"Sue Mosher [MVP-Outlook]" wrote in message
...
It should be possible to do it with Redemption using the technique
demonstrated in the code sample.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message
...
Sue - looking at the code that you mention, it almost looks like embedded
items are not 'safe'...

Having poked through the code I have written, the items that are in fact
not
allowing me to export to a file are 'emails' attached to a contact record
in
the 'notes' (body) field, they return a class of 5 (olAttachment) and a
type
of 5 (OlEmbeddedItem)...

Does this mean that even with Redemption, these items just cannot be
pulled
out of Outlook programmatically?

It seemed like the embedded items were the exception in code 523
example...



"Sue Mosher [MVP-Outlook]" wrote in message
...
Attachments are in the Attachments collection of the ContactItem. You will
need to save each attachment as a file before you can do anything with it.
Embedded Outlook items are the most difficult to extract; see
http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

"M Scott S" wrote in message
...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the
right
hand lower portion where the user can enter as much free form text as
they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be
able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...




M Scott S May 26th 06 08:58 PM

Figured it out...
 
I thought it had to be straightforward....

I was attempting to save using display name instead of file name...

Duh!


"Sue Mosher [MVP-Outlook]" wrote in message
...
It should be possible to do it with Redemption using the technique
demonstrated in the code sample.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message
...
Sue - looking at the code that you mention, it almost looks like embedded
items are not 'safe'...

Having poked through the code I have written, the items that are in fact
not
allowing me to export to a file are 'emails' attached to a contact record
in
the 'notes' (body) field, they return a class of 5 (olAttachment) and a
type
of 5 (OlEmbeddedItem)...

Does this mean that even with Redemption, these items just cannot be
pulled
out of Outlook programmatically?

It seemed like the embedded items were the exception in code 523
example...



"Sue Mosher [MVP-Outlook]" wrote in message
...
Attachments are in the Attachments collection of the ContactItem. You will
need to save each attachment as a file before you can do anything with it.
Embedded Outlook items are the most difficult to extract; see
http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

"M Scott S" wrote in message
...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the
right
hand lower portion where the user can enter as much free form text as
they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be
able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...




Ken Slovak - [MVP - Outlook] May 26th 06 09:06 PM

Figured it out...
 
FileName may not exist for some types of embedded attachments. In that case
DisplayName is about all you can use. If you copy a picture to the clipboard
and paste it into the body of an RTF email there will be no FileName and
accessing it will return an error. That's one example of where FileName is
useless.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"M Scott S" wrote in message
...
I thought it had to be straightforward....

I was attempting to save using display name instead of file name...

Duh!



Sue Mosher [MVP-Outlook] May 26th 06 09:54 PM

Baffled...
 
Correct. There is no way to do that within the Outlook object model.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"M Scott S" wrote in message ...
Sorry, but it's over my head. I am struggling enough with Outlook's model,
let alone introducing yet another...

I am driving this from access, not outlook.

I don't need code for all the various data types as I am handling that, I
just want to be able to pull out an embedded email msg and save it as a file
to the windows file system...

Is there no way to do that with Outlook's object model? It's simple enough
with the other stuff, what's the magic that makes this such a challenge...?



"Sue Mosher [MVP-Outlook]" wrote in message
...
It should be possible to do it with Redemption using the technique
demonstrated in the code sample.



"M Scott S" wrote in message
...
Sue - looking at the code that you mention, it almost looks like embedded
items are not 'safe'...

Having poked through the code I have written, the items that are in fact
not
allowing me to export to a file are 'emails' attached to a contact record
in
the 'notes' (body) field, they return a class of 5 (olAttachment) and a
type
of 5 (OlEmbeddedItem)...

Does this mean that even with Redemption, these items just cannot be
pulled
out of Outlook programmatically?

It seemed like the embedded items were the exception in code 523
example...



"Sue Mosher [MVP-Outlook]" wrote in message
...
Attachments are in the Attachments collection of the ContactItem. You will
need to save each attachment as a file before you can do anything with it.
Embedded Outlook items are the most difficult to extract; see
http://www.outlookcode.com/codedetail.aspx?id=523 for a code sample.

"M Scott S" wrote in message
...
I need to be able to export contact info from Outlook store including the
'notes' field on the contact detail form (the 'memo' type field on the
right
hand lower portion where the user can enter as much free form text as
they
like...).

The tool I have seems to expose the text of the field w/o trouble.

The problem comes in in that the users have also draggged and dropped
various items in the emails, docs, xls, whatever, and I need to be
able
to pull these out and import them to the target app...

I have been poking around the Outlook Object model, but I can't seem to
figure out the relationship between the 'attachments' and the contacts...





All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com