Application.FollowHyperlink "mailto:...." formating 1

[PWise]

This is the code that I am using

Application.FollowHyperlink "mailto:SomeOne@SomeDomain.SomeExt?subject=Something or Other&body=John" & vbcrlf & "Some Text" & vbcrlf & "Some More text"

this works but the line brakes dont work
I tried Vbcrlf,Vbnewline,chr(13)+chr(10) and the whole body is one long line

Any Ideas


Thank You

PWise

 

[matrixindicator]

Is the method case sensitive ? Just an ID.

vbCrLf

 

[matrixindicator]

I mean Constant vbCrLf

or is there something not correct with the " ?

 

[PWise]

matrixindicator:

Re:
Is the method case sensitive ?
in my actuel code it is vbCrLf

Re:
is there something not correct with the " ?

I Tried without the "?" and it does not help.

Thamk You

Pwise

 

[matrixindicator]

I never seen a FollowHyperlink as a mailto, but perhaps its ok, I don't know. Otherwise its a syntaxis problem, something wrong with the settings of " or try only to use variables to declare body. (put them first in variables and afterwards use this variables in your string.
Below an example of the opening of an excel file, the worksheet selected in access and positioning on the first cell.

Application.FollowHyperlink "C:\HypCountry.xls#" _
    & cboCountry & "!A1"

Its just an ID, perhaps not the solution.

 

[ProgramError]

Am I missing something here the hyperlink address given is an email address?

Are you hyperlinking or emailing. Did't know you could hyper to an email address.


Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.

 

[PHV]

You may try %0a

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PWise]

As i was about to raise the white flag and give up on this one PHV to the resque

Thanks and a purple Star

 

[matrixindicator]

just to update my knowledge, is %0a instead of vbCrlf and what does it mean ?

 

[MakeItSo]

%0a means hex code 0a which is Linefeed or vbLf
%0d would then be hex code 0d which is Carriage Return or VbCr

vbCrLf would thus logically be %0d0a (or %0d%0a ?)


Cheerio!
MiS

[navy]"We had to turn off that service to comply with the CDA Bill."[/navy]
- The Bastard Operator From Hell