LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default Emailing using VBA

XL 97

Below is a copy of code that I am using to email some
worksheets (many worksheets) in a workbook to different
individuals (many individuals) I need to be able to add
text msgs in the body

Sub Mail_every_Worksheet()
Dim sh As Worksheet
Dim wb As Workbook
Dim wb1 As Workbook
Dim strdate As String
Application.ScreenUpdating = False
Set wb1 = ActiveWorkbook
For Each sh In wb1.Worksheets
If sh.Range("a1").Value Like "*@*" Then
strdate = Format(Now, "dd-mm-yy h-mm-ss")
sh.Copy
Set wb = ActiveWorkbook
With wb
.SaveAs "Sheet " & sh.Name & " of " & _
wb1.Name & " " & strdate & ".xls"
.SendMail ", _
"I have emailed using VB now"
.ChangeFileAccess xlReadOnly
Kill .FullName
.Close False
End With
End If
Next sh
Application.ScreenUpdating = True
End Sub


This line Below will pause the send mail and let me type
the msg in the body, but then I have to select/type all
the email address individually (that will take forever
cause of the number of names).

..SendMail "", "This is the Subject line"


I'm using a form letter for the body. Is their some way
to enter text into the body with vba with out having to
use the sendkey command?


Code form:
http://www.rondebruin.nl/sendmail.htm#sheets

 
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
Emailing momotaro Excel Discussion (Misc queries) 1 March 21st 06 09:12 PM
Emailing lsherman22 Excel Discussion (Misc queries) 0 January 12th 06 07:35 PM
emailing pdf nickp Excel Discussion (Misc queries) 4 August 8th 05 11:14 AM
emailing IanH Excel Worksheet Functions 4 June 1st 05 09:25 PM
Emailing in VBA Steven Cheng[_2_] Excel Programming 2 July 25th 03 11:27 PM


All times are GMT +1. The time now is 06:24 AM.

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"