Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto email
Hello
In this age of spam, is it possible to send an email automatically from excel without 1) user response 2) using Outlook Express' lower security standards? Can DOS accommodate a "mail" command (as would BASH)? Thanks W *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto email
'Orig: Marcus Schmitt, copied and adapted from http://bert-
koern.de/excel/excel_makros_e.htm: Private Declare Function ShellExecute Lib "Shell32.dll" _ Alias "ShellExecuteA" (ByVal hWnd As Long, _ ByVal lpOperation As String, ByVal lpFile As String, _ ByVal lpParameters As String, ByVal lpDirectory As String, _ ByVal nShowCmd As Long) As Long Private Sub Mail(eMail As String, Optional Subject As String, _ Optional Body As String) Call ShellExecute(0&, "Open", "mailto:" + eMail + _ "?Subject=" + Subject + "&Body=" + Body, "", "", 1) End Sub Private Sub Command1_Click() Dim Nachricht As String ' Force Newline with %0D%0A ! Message = "Hello" & "%0D%0A" & "World!" Call ", "My Subject", Message) End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto email
Cool! Thanks! I will give it a try...
W *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Email | New Users to Excel | |||
Auto Email VBA | Excel Discussion (Misc queries) | |||
How do I create an email macro to auto fill the email? | Excel Discussion (Misc queries) | |||
auto email generator | Excel Discussion (Misc queries) | |||
Auto Email | Excel Discussion (Misc queries) |