email problem


B

bojan0810

Hi all

I am using this code for inserting hyperlink to cell and open outlook.

Sub test()
ActiveCell.Hyperlinks.Add ActiveCell, "mailto:" & Email & "?subject=Test: " & PropAdd, "", "", "Send Invoice"
ActiveCell.Hyperlinks(1).Follow
End Sub

Now what I need is instead of subject to show test: in email in outlook, it should show from desired cell.

Also body of email should write something too. For this I just want body of email to say TestBody, and subject to show from cell A1

Thanks
 
Ad

Advertisements

G

GS

Hi all
I am using this code for inserting hyperlink to cell and open
outlook.

Sub test()
ActiveCell.Hyperlinks.Add ActiveCell, "mailto:" & Email &
"?subject=Test: " & PropAdd, "", "", "Send Invoice"
ActiveCell.Hyperlinks(1).Follow End Sub

Now what I need is instead of subject to show test: in email in
outlook, it should show from desired cell.

Also body of email should write something too. For this I just want
body of email to say TestBody, and subject to show from cell A1

Thanks
Have a look here...

http://www.rondebruin.nl/

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
Ad

Advertisements


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

Top