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 Chris Miller 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
Aug 18, 2002
1
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
Retain signature in Outlook
Replies
17
Views
1K
strongm
strongm
Kymenglish
  • Locked
  • Question
Automated data entry code in MS Excel VB - Edge code how to hit enter to remove popups
Replies
3
Views
367
strongm
strongm
Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
2K
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
860
strongm
strongm
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
581
combo
combo

Part and Inventory Search

Sponsor

Back
Top