email problem

[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

 

[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

 

[bojan0810]

Dana petak, 30. sijeÄnja 2015. u 19:09:01 UTC+1, korisnik GS napisao je:

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

thank you, i found solution