ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   For Ron de Bruin Please (https://www.excelbanter.com/excel-worksheet-functions/17796-ron-de-bruin-please.html)

Steved

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.

Ron de Bruin

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.




Bob Phillips

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.




Steved

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.



.


Steved

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.



.


Ron de Bruin

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.



.




Gord Dibben

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