HELP sending email from Excel

M

Memnoch

Im using VBA in Outlook XP to create a hyperlink to send an email from
Excel. But it will only work if the Msg is under a certain length. ie I can
usually only have two or three lines in the body or the hyperlink doesnt
show up.

How can I work around this ?

cheers,

Memnoch


Msg = Msg & "Text Line 1" & "%0D%0A" & "%0D%0A"
Msg = Msg & "Text Line 2" & "%0D%0A" & "%0D%0A"
Msg = Msg & "Text Line 3" & "%0D%0A" & "%0D%0A"
Msg = Msg & "Text Line 4" & "%0D%0A" & "%0D%0A"
Msg = Msg & "Text Line 5" & "%0D%0A" & "%0D%0A"

xlRg.Offset(2, 12).Formula = "=HYPERLINK(" & Chr(34) & "mailto:" &
Email & "?subject=" _
& xlRg.Offset(2, 1).Value & "&Body=" & Msg & Chr(34) & ", " & Chr(34) &
"Send Email" & Chr(34) & ")"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with VBA 4
Why did this code stop working ? 0
Send data from Excel in email from specific email address 5
EMail Hyperlink TO limited to 10 char 3
Macro Help 3
VB Help Needed 0
Excel VBA - Sending email 0
Email without extentions 0

Top