T thread May 25, 2007 #1 Hi all, is it posible to send only link in outlook without sending the all worksheet as well via vba
G Guest May 25, 2007 #2 Ron De Bruin's code will do it:- http://www.rondebruin.nl/mail/folder3/smallmessage.htm Put your link in a cell and read it with something like:- Mylink = Worksheets("Sheet1").Cells(1, 1).Value then in the message body of Ron's code send Mylink Mike
Ron De Bruin's code will do it:- http://www.rondebruin.nl/mail/folder3/smallmessage.htm Put your link in a cell and read it with something like:- Mylink = Worksheets("Sheet1").Cells(1, 1).Value then in the message body of Ron's code send Mylink Mike
T thread May 29, 2007 #3 this is perfect thanks Mike H : Ron De Bruin's code will do it:- http://www.rondebruin.nl/mail/folder3/smallmessage.htm Put your link in a cell and read it with something like:- Mylink = Worksheets("Sheet1").Cells(1, 1).Value then in the message body of Ron's code send Mylink Mike Click to expand...
this is perfect thanks Mike H : Ron De Bruin's code will do it:- http://www.rondebruin.nl/mail/folder3/smallmessage.htm Put your link in a cell and read it with something like:- Mylink = Worksheets("Sheet1").Cells(1, 1).Value then in the message body of Ron's code send Mylink Mike Click to expand...
