![]() |
For Ron de Bruin Please
Hello Ron from Steved
Ron I am using your excellent Sub Mail_test() And I thankyou specilly that I Have 5 Worksheets to email. My Question In Your Macro is it possilble please to add a comment in the Subject: As an example ..Subject = Depot Anullments Thanks Ron. |
Hi steved
Do you mean this one http://www.rondebruin.nl/mail/folder1/mail2.htm You can change "This is the Subject line" Or do you mean something else ? -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello Ron from Steved Ron I am using your excellent Sub Mail_test() And I thankyou specilly that I Have 5 Worksheets to email. My Question In Your Macro is it possilble please to add a comment in the Subject: As an example .Subject = Depot Anullments Thanks Ron. |
According to help on SendMail, there is a subject argument. And in Ron's
example he uses the subject .SendMail Addr(N), _ "This is the Subject line" -- HTH RP (remove nothere from the email address if mailing direct) "Steved" wrote in message ... Hello Ron from Steved Ron I am using your excellent Sub Mail_test() And I thankyou specilly that I Have 5 Worksheets to email. My Question In Your Macro is it possilble please to add a comment in the Subject: As an example .Subject = Depot Anullments Thanks Ron. |
Thankyou
I am very sorry I put your macro in a hurry not completely reading it. -----Original Message----- Hi steved Do you mean this one http://www.rondebruin.nl/mail/folder1/mail2.htm You can change "This is the Subject line" Or do you mean something else ? -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello Ron from Steved Ron I am using your excellent Sub Mail_test() And I thankyou specilly that I Have 5 Worksheets to email. My Question In Your Macro is it possilble please to add a comment in the Subject: As an example .Subject = Depot Anullments Thanks Ron. . |
Thanks Bob I did not read it.
Cheers. -----Original Message----- According to help on SendMail, there is a subject argument. And in Ron's example he uses the subject .SendMail Addr(N), _ "This is the Subject line" -- HTH RP (remove nothere from the email address if mailing direct) "Steved" wrote in message ... Hello Ron from Steved Ron I am using your excellent Sub Mail_test() And I thankyou specilly that I Have 5 Worksheets to email. My Question In Your Macro is it possilble please to add a comment in the Subject: As an example .Subject = Depot Anullments Thanks Ron. . |
No problem
-- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Thankyou I am very sorry I put your macro in a hurry not completely reading it. -----Original Message----- Hi steved Do you mean this one http://www.rondebruin.nl/mail/folder1/mail2.htm You can change "This is the Subject line" Or do you mean something else ? -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello Ron from Steved Ron I am using your excellent Sub Mail_test() And I thankyou specilly that I Have 5 Worksheets to email. My Question In Your Macro is it possilble please to add a comment in the Subject: As an example .Subject = Depot Anullments Thanks Ron. . |
So who reads? <g
Gord On Tue, 15 Mar 2005 23:47:17 +0100, "Ron de Bruin" wrote: No problem -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Thankyou I am very sorry I put your macro in a hurry not completely reading it. |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com