Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mail File Q
I am trying to e-mail to 3 people a file on my PC, I got the attached code
from Ron De Bruin's site and tailored it somewhat, my difficulty is adding the 2 other names to the one shown - how do I do it? Thanks Sub Mail_Report() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy h-mm") Application.ScreenUpdating = False Sheets("E-Mail").Copy Set wb = ActiveWorkbook With wb .SaveAs "Part of " & ThisWorkbook.Name _ & " " & strdate & ".xls" .SendMail ", _ "Go Large Report" .ChangeFileAccess xlReadOnly Kill .FullName .Close False End With Application.ScreenUpdating = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mail File Q
Hi John
http://www.rondebruin.nl/sendmail.htm#Tips For mailing to more people use this line. ..SendMail ", "), _ "This is the Subject line" -- Regards Ron de Bruin http://www.rondebruin.nl "John" wrote in message ... I am trying to e-mail to 3 people a file on my PC, I got the attached code from Ron De Bruin's site and tailored it somewhat, my difficulty is adding the 2 other names to the one shown - how do I do it? Thanks Sub Mail_Report() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy h-mm") Application.ScreenUpdating = False Sheets("E-Mail").Copy Set wb = ActiveWorkbook With wb .SaveAs "Part of " & ThisWorkbook.Name _ & " " & strdate & ".xls" .SendMail ", _ "Go Large Report" .ChangeFileAccess xlReadOnly Kill .FullName .Close False End With Application.ScreenUpdating = True End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mail File Q
Thanks Ron - useful code
"Ron de Bruin" wrote in message ... Hi John http://www.rondebruin.nl/sendmail.htm#Tips For mailing to more people use this line. .SendMail ", "), _ "This is the Subject line" -- Regards Ron de Bruin http://www.rondebruin.nl "John" wrote in message ... I am trying to e-mail to 3 people a file on my PC, I got the attached code from Ron De Bruin's site and tailored it somewhat, my difficulty is adding the 2 other names to the one shown - how do I do it? Thanks Sub Mail_Report() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy h-mm") Application.ScreenUpdating = False Sheets("E-Mail").Copy Set wb = ActiveWorkbook With wb .SaveAs "Part of " & ThisWorkbook.Name _ & " " & strdate & ".xls" .SendMail ", _ "Go Large Report" .ChangeFileAccess xlReadOnly Kill .FullName .Close False End With Application.ScreenUpdating = True End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-Mail File Q
Hi John
You can also use one of the templates to do this if you like http://www.rondebruin.nl/sendmail.htm#sheets -- Regards Ron de Bruin http://www.rondebruin.nl "John" wrote in message ... Thanks Ron - useful code "Ron de Bruin" wrote in message ... Hi John http://www.rondebruin.nl/sendmail.htm#Tips For mailing to more people use this line. .SendMail ", "), _ "This is the Subject line" -- Regards Ron de Bruin http://www.rondebruin.nl "John" wrote in message ... I am trying to e-mail to 3 people a file on my PC, I got the attached code from Ron De Bruin's site and tailored it somewhat, my difficulty is adding the 2 other names to the one shown - how do I do it? Thanks Sub Mail_Report() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy h-mm") Application.ScreenUpdating = False Sheets("E-Mail").Copy Set wb = ActiveWorkbook With wb .SaveAs "Part of " & ThisWorkbook.Name _ & " " & strdate & ".xls" .SendMail ", _ "Go Large Report" .ChangeFileAccess xlReadOnly Kill .FullName .Close False End With Application.ScreenUpdating = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
Excel - Sending file using File/Send to/Mail Recipient | Excel Discussion (Misc queries) | |||
Mail an Ecxel-file | Excel Discussion (Misc queries) | |||
append file on e-mail | Excel Discussion (Misc queries) | |||
send file by e-mail | Excel Programming |