Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding extra email address to a single Worksheet
Hello from Steved
I am not sure how to add extra email address I need to add 13 Thankyou. Sub Mail_Crinel() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy") Application.ScreenUpdating = False Sheets("Paradox-Kilometres").Copy Cells.Copy Cells.PasteSpecial xlPasteValues Cells(1).Select Application.CutCopyMode = False Set wb = ActiveWorkbook With wb .SendMail ", _ "Auckland Kilometres" .Close False End With Application.ScreenUpdating = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding extra email address to a single Worksheet
You can put them into an array:
.SendMail ", _ ", _ "), _ "Auckland Kilometres" Steved wrote: Hello from Steved I am not sure how to add extra email address I need to add 13 Thankyou. Sub Mail_Crinel() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy") Application.ScreenUpdating = False Sheets("Paradox-Kilometres").Copy Cells.Copy Cells.PasteSpecial xlPasteValues Cells(1).Select Application.CutCopyMode = False Set wb = ActiveWorkbook With wb .SendMail ", _ "Auckland Kilometres" .Close False End With Application.ScreenUpdating = True End Sub -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding extra email address to a single Worksheet
Hi Steved
See the Tip link on the mail pages This is for the SendMail code http://www.rondebruin.nl/mail/tips1.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Steved" wrote in message ... Hello from Steved I am not sure how to add extra email address I need to add 13 Thankyou. Sub Mail_Crinel() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy") Application.ScreenUpdating = False Sheets("Paradox-Kilometres").Copy Cells.Copy Cells.PasteSpecial xlPasteValues Cells(1).Select Application.CutCopyMode = False Set wb = ActiveWorkbook With wb .SendMail ", _ "Auckland Kilometres" .Close False End With Application.ScreenUpdating = True End Sub |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding extra email address to a single Worksheet
Thankyou Gentleman.
"Steved" wrote: Hello from Steved I am not sure how to add extra email address I need to add 13 Thankyou. Sub Mail_Crinel() Dim wb As Workbook Dim strdate As String strdate = Format(Now, "dd-mm-yy") Application.ScreenUpdating = False Sheets("Paradox-Kilometres").Copy Cells.Copy Cells.PasteSpecial xlPasteValues Cells(1).Select Application.CutCopyMode = False Set wb = ActiveWorkbook With wb .SendMail ", _ "Auckland Kilometres" .Close False End With Application.ScreenUpdating = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email one worksheet to email address on worksheet | Excel Worksheet Functions | |||
Embed email address into worksheet | Excel Discussion (Misc queries) | |||
How do I email a single worksheet, not the entire workbook? | Excel Discussion (Misc queries) | |||
Email a single worksheet | Excel Discussion (Misc queries) | |||
Emailing A single worksheet wit a email address | Excel Programming |