Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Steved
 
Posts: n/a
Default 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.
  #2   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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.



  #3   Report Post  
Steved
 
Posts: n/a
Default

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.



.

  #4   Report Post  
Ron de Bruin
 
Posts: n/a
Default

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.



.



  #5   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.





  #6   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.



  #7   Report Post  
Steved
 
Posts: n/a
Default

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.



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
E-mail to every e-mail address in an Excel column? MrMan&Fam Excel Discussion (Misc queries) 24 July 19th 06 09:35 AM
Copy a cell to all workbooks within a folder. Andy T Excel Discussion (Misc queries) 16 February 2nd 05 11:14 PM
Ron de Bruin Copy2 Macro - troubleshooting gizmo Excel Worksheet Functions 3 January 18th 05 02:47 PM
How to delete duplicate records when I merge two lists (deleting . rinks Excel Worksheet Functions 10 December 11th 04 01:03 AM
Combine Mutiple Worksheets into one Dean F Excel Discussion (Misc queries) 11 November 27th 04 04:18 PM


All times are GMT +1. The time now is 07:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"