Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Automate email from within Excel. 1
- Thread starter Ezzer
- Start date
-
1
- #2
dwlerwill
Technical User
- May 25, 2001
- 329
Dim A As String
Dim B As String
'Who the email should go to
A = test@email.com
'The Subject
B = "Here is your Spreadsheet"
ActiveWorkbook.SendMail Recipients:=A, Subject:=B
Is this what you need?
David Lerwill
"If at first you don't succeed go to the pub"
Dim B As String
'Who the email should go to
A = test@email.com
'The Subject
B = "Here is your Spreadsheet"
ActiveWorkbook.SendMail Recipients:=A, Subject:=B
Is this what you need?
David Lerwill
"If at first you don't succeed go to the pub"
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question