Followup to earlier question on message attachments

Followup to earlier question on message attachments

Based on the excellent information in this group I was able to get the basic 
functionality I was looking for working on my "test" mailbox.  But when I try 
to run it on the real mailbox it's intended to run on it's mostly OK but the 
following section of code:

	If Rs("urn:schemas:httpmail:hasattachment") Then
		Set objMessage = CreateObject("CDO.Message")

		objMessage.DataSource.Open surl & "/" & Rs("DAV:displayname")

Generates the error:

D:\Users\administrator\Scripts\exchtest.vbs(103, 3) (null): The filename, 
direct
ory name, or volume label syntax is incorrect.

on one of the messages in the mailbox.  If I output the value, surl & "/" & 
Rs("DAV:displayname") I get:

file://./backofficestorage/mydomain.com/MBX/myusername/Inbox/FW: Happy Holid
ays --- & UnitedHealthcare update-2.EML

That appears to be correct to me.  I thought it might be some of the special 
characters in the string like :, ---, or & but other messages that do work 
have these also.  A check of the mailbox in question shows that this message 
does exist and appears to be just as expected.

Any ideas about what is causing this and how to correct it?

Thanks...

date: Tue, 20 Dec 2005 08:56:01 -0800 author: jwh20

RE: Followup to earlier question on message attachments

When this happens, Err = 8007007B


"jwh20" wrote:

> Based on the excellent information in this group I was able to get the basic 
> functionality I was looking for working on my "test" mailbox.  But when I try 
> to run it on the real mailbox it's intended to run on it's mostly OK but the 
> following section of code:
> 
> 	If Rs("urn:schemas:httpmail:hasattachment") Then
> 		Set objMessage = CreateObject("CDO.Message")
> 
> 		objMessage.DataSource.Open surl & "/" & Rs("DAV:displayname")
> 
> Generates the error:
> 
> D:\Users\administrator\Scripts\exchtest.vbs(103, 3) (null): The filename, 
> direct
> ory name, or volume label syntax is incorrect.
> 
> on one of the messages in the mailbox.  If I output the value, surl & "/" & 
> Rs("DAV:displayname") I get:
> 
> file://./backofficestorage/mydomain.com/MBX/myusername/Inbox/FW: Happy Holid
> ays --- & UnitedHealthcare update-2.EML
> 
> That appears to be correct to me.  I thought it might be some of the special 
> characters in the string like :, ---, or & but other messages that do work 
> have these also.  A check of the mailbox in question shows that this message 
> does exist and appears to be just as expected.
> 
> Any ideas about what is causing this and how to correct it?
> 
> Thanks...

date: Tue, 20 Dec 2005 10:16:07 -0800 author: jwh20

Re: Followup to earlier question on message attachments

Try using DAV:href property instead of DAV:displayname, this should contain 
the full path to the object in the Exchange store which will be escaped 
where nessasary.

eg
objMessage.DataSource.Open Rs("DAV:Href")

(you'll need to make sure you include it in you initial SQL query)

The example you have given if probably failing because of the : in FW: this 
needs to be escaped as %3A if you just use the DAV:Href property this will 
be already done.

Cheers
Glen



"jwh20"  wrote in message 
news:D3D5E768-5340-4F21-85E0-3BF992DB1314@microsoft.com...
> When this happens, Err = 8007007B
>
>
> "jwh20" wrote:
>
>> Based on the excellent information in this group I was able to get the 
>> basic
>> functionality I was looking for working on my "test" mailbox.  But when I 
>> try
>> to run it on the real mailbox it's intended to run on it's mostly OK but 
>> the
>> following section of code:
>>
>> If Rs("urn:schemas:httpmail:hasattachment") Then
>> Set objMessage = CreateObject("CDO.Message")
>>
>> objMessage.DataSource.Open surl & "/" & Rs("DAV:displayname")
>>
>> Generates the error:
>>
>> D:\Users\administrator\Scripts\exchtest.vbs(103, 3) (null): The filename,
>> direct
>> ory name, or volume label syntax is incorrect.
>>
>> on one of the messages in the mailbox.  If I output the value, surl & "/" 
>> &
>> Rs("DAV:displayname") I get:
>>
>> file://./backofficestorage/mydomain.com/MBX/myusername/Inbox/FW: Happy 
>> Holid
>> ays --- & UnitedHealthcare update-2.EML
>>
>> That appears to be correct to me.  I thought it might be some of the 
>> special
>> characters in the string like :, ---, or & but other messages that do 
>> work
>> have these also.  A check of the mailbox in question shows that this 
>> message
>> does exist and appears to be just as expected.
>>
>> Any ideas about what is causing this and how to correct it?
>>
>> Thanks...

date: Wed, 21 Dec 2005 10:03:45 +1100 author: Glen Scales [MVP]

Re: Followup to earlier question on message attachments

Glen,

Thanks, I'll give that a try.  The strange this is that there are other 
messages with a ":" in the displayname and they don't have a problem.  It's 
just this one message out of several hundred...  Very odd...

Regards,

Joe



"Glen Scales [MVP]" wrote:

> Try using DAV:href property instead of DAV:displayname, this should contain 
> the full path to the object in the Exchange store which will be escaped 
> where nessasary.
> 
> eg
> objMessage.DataSource.Open Rs("DAV:Href")
> 
> (you'll need to make sure you include it in you initial SQL query)
> 
> The example you have given if probably failing because of the : in FW: this 
> needs to be escaped as %3A if you just use the DAV:Href property this will 
> be already done.
> 
> Cheers
> Glen
> 
> 
> 
> "jwh20"  wrote in message 
> news:D3D5E768-5340-4F21-85E0-3BF992DB1314@microsoft.com...
> > When this happens, Err = 8007007B
> >
> >
> > "jwh20" wrote:
> >
> >> Based on the excellent information in this group I was able to get the 
> >> basic
> >> functionality I was looking for working on my "test" mailbox.  But when I 
> >> try
> >> to run it on the real mailbox it's intended to run on it's mostly OK but 
> >> the
> >> following section of code:
> >>
> >> If Rs("urn:schemas:httpmail:hasattachment") Then
> >> Set objMessage = CreateObject("CDO.Message")
> >>
> >> objMessage.DataSource.Open surl & "/" & Rs("DAV:displayname")
> >>
> >> Generates the error:
> >>
> >> D:\Users\administrator\Scripts\exchtest.vbs(103, 3) (null): The filename,
> >> direct
> >> ory name, or volume label syntax is incorrect.
> >>
> >> on one of the messages in the mailbox.  If I output the value, surl & "/" 
> >> &
> >> Rs("DAV:displayname") I get:
> >>
> >> file://./backofficestorage/mydomain.com/MBX/myusername/Inbox/FW: Happy 
> >> Holid
> >> ays --- & UnitedHealthcare update-2.EML
> >>
> >> That appears to be correct to me.  I thought it might be some of the 
> >> special
> >> characters in the string like :, ---, or & but other messages that do 
> >> work
> >> have these also.  A check of the mailbox in question shows that this 
> >> message
> >> does exist and appears to be just as expected.
> >>
> >> Any ideas about what is causing this and how to correct it?
> >>
> >> Thanks... 
> 
> 
>

date: Wed, 21 Dec 2005 02:24:03 -0800 author: jwh20