Set an Excel generated CDO email's priority or importance to 'high' or'highest'...

Hello,

In reviewing Ron's code here, http://www.rondebruin.nl/cdo.htm, I am
looking for a method to set the email's priority or importance to 'high' or
'highest'. Is there a way to do so, such as from what he has listed?

With iMsg
Set .Configuration = iConf
.To = "Jon@something.com"
.CC = ""
.BCC = ""
.From = """Ron"" <ron@something.nl>"
.Subject = "This is a test"
.Importance = 2
.Priority = 2
.TextBody = "Hi there"
.AddAttachment "C:/" & WBname
' You can add any file you want with this line .AddAttachment
"C:/Test.txt"
.Send
End With

Neither line in bold/red appears to be working.

Additionally, in the email body of several messages (created via an
..HTMLBody variable), a few words are being broken in half and a space
added. In other cases, URLs are being split as well. For an example,
please see the following:

Conversion Account Statem ent --- 'a space was added in Statement'
http://education.ou.c%20om/ --- 'a URL space (%20) was added in between
..com

Any help is much appreciated.

Thanks much,

Kevin

Hi

If the user use Outlook

Use this

..Item("http://schemas.microsoft.com/cdo/configuration/cdoImportance") = cdoHigh

Send me example workbook with the link problem

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Lyons" <kevinlyons@dslextreme.com> wrote in message news:42A93187.6F098D40@dslextreme.com...
Hello,
In reviewing Ron's code here, http://www.rondebruin.nl/cdo.htm, I am looking for a method to set the email's priority or importance to 'high' or 'highest'. Is there a way to do so, such as from what he has listed?

With iMsg
Set .Configuration = iConf
.To = "Jon@something.com"
.CC = ""
.BCC = ""
.From = """Ron"" <ron@something.nl>"
.Subject = "This is a test"
.Importance = 2
.Priority = 2
.TextBody = "Hi there"
.AddAttachment "C:/" & WBname
' You can add any file you want with this line .AddAttachment "C:/Test.txt"
.Send
End With

Neither line in bold/red appears to be working.

Additionally, in the email body of several messages (created via an ..HTMLBody variable), a few words are being broken in half and a space added. In other cases, URLs are being split as well. For an example, please see the following:

Conversion Account Statem ent --- 'a space was added in Statement'
http://education.ou.c%20om/ --- 'a URL space (%20) was added in between .com

Any help is much appreciated.

Thanks much,

Kevin

Mmmm

This is not working correct

I only used other code to do this but this is only working if the reciever have Outlook Express.

I will try to get it working this evening

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:eSRIIRzbFHA.3272@TK2MSFTNGP10.phx.gbl...
Hi

If the user use Outlook

Use this

.Item("http://schemas.microsoft.com/cdo/configuration/cdoImportance") = cdoHigh

Send me example workbook with the link problem

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Lyons" <kevinlyons@dslextreme.com> wrote in message news:42A93187.6F098D40@dslextreme.com...
Hello,
In reviewing Ron's code here, http://www.rondebruin.nl/cdo.htm, I am looking for a method to set the email's priority or importance to 'high' or 'highest'. Is there a way to do so, such as from what he has listed?

With iMsg
Set .Configuration = iConf
.To = "Jon@something.com"
.CC = ""
.BCC = ""
.From = """Ron"" <ron@something.nl>"
.Subject = "This is a test"
.Importance = 2
.Priority = 2
.TextBody = "Hi there"
.AddAttachment "C:/" & WBname
' You can add any file you want with this line ..AddAttachment "C:/Test.txt"
.Send
End With

Neither line in bold/red appears to be working.

Additionally, in the email body of several messages (created via an ..HTMLBody variable), a few words are being broken in half and a space added. In other cases, URLs are being split as well. For an example, please see the following:

Conversion Account Statem ent --- 'a space was added in Statement'
http://education.ou.c%20om/ --- 'a URL space (%20) was added in between .com

Any help is much appreciated.

Thanks much,

Kevin

Hi

I update my CDO page
http://www.rondebruin.nl/cdo.htm


See the Tips section
http://www.rondebruin.nl/cdo.htm#Tips



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:eHs92t1bFHA.3032@TK2MSFTNGP10.phx.gbl...
Mmmm

This is not working correct

I only used other code to do this but this is only working if the reciever have Outlook Express.

I will try to get it working this evening

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:eSRIIRzbFHA.3272@TK2MSFTNGP10.phx.gbl...
Hi

If the user use Outlook

Use this

..Item("http://schemas.microsoft.com/cdo/configuration/cdoImportance") = cdoHigh

Send me example workbook with the link problem

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Kevin Lyons" <kevinlyons@dslextreme.com> wrote in message news:42A93187.6F098D40@dslextreme.com...
Hello,
In reviewing Ron's code here, http://www.rondebruin.nl/cdo.htm, I am looking for a method to set the email's priority or importance to 'high' or 'highest'. Is there a way to do so, such as from what he has listed?

With iMsg
Set .Configuration = iConf
.To = "Jon@something.com"
.CC = ""
.BCC = ""
.From = """Ron"" <ron@something.nl>"
.Subject = "This is a test"
.Importance = 2
.Priority = 2
.TextBody = "Hi there"
.AddAttachment "C:/" & WBname
' You can add any file you want with this line ..AddAttachment "C:/Test.txt"
.Send
End With

Neither line in bold/red appears to be working.

Additionally, in the email body of several messages (created via an .HTMLBody variable), a few words are being broken in half and a space added. In other cases, URLs are being split as well. For an example, please see the following:

Conversion Account Statem ent --- 'a space was added in Statement'
http://education.ou.c%20om/ --- 'a URL space (%20) was added in between .com

Any help is much appreciated.

Thanks much,

Kevin