email problem

  • Thread starter Thread starter bojan0810
  • Start date Start date
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
 
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
Click to expand...

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
 
Back
Top