Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |