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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to send an email in MS Excel without OE or Outlook

Status
Not open for further replies.
duongtm

duongtm

Programmer
Joined
Aug 18, 2002
Messages
1
Location
VN
Hi everybody,

Can anyone please help me to show the VBA code for the mentioned procedure. The code may run like below, I think:

mailSubject="something"
mailTo="something"
mailBody=="something"
SMTPServer="something"
SendEmail (mailTo, mailSubject,mailBody,SMTPServer)
...
and should return error code to assure that the mail is sent successful. SMTPServer is the most important, how can I specify it in the SendEmail procedure?

Thanks so much for your advise,

Best regards,

-DuongTM-
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question Question
Retain signature in Outlook
Replies
17
Views
3K
strongm
strongm
Kymenglish
  • Locked
  • Question Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
760
strongm
strongm
Andrzejek
  • Locked
  • Question Question
Outlook Template replace text
Replies
13
Views
3K
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word
Replies
7
Views
2K
strongm
strongm
K
  • Locked
  • Question Question
How to resolve define worksheets array
Replies
1
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top