Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
Copy a cell to all workbooks within a folder. | Excel Discussion (Misc queries) | |||
Ron de Bruin Copy2 Macro - troubleshooting | Excel Worksheet Functions | |||
How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
Combine Mutiple Worksheets into one | Excel Discussion (Misc queries) |