Sending an e-mail

G

Guest

I can send a workbook by using command
ActiveWorkbook.SendMail Recipients:="recipient", Subject:="subject
But how do I send an e-mail without sending the workbook?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending a selection by email 5
Sending Excel Workbooks to Outlook people automatically 1
Sendmail with a named cell value as recipient 2
emailing using Excel VBA 2
VB code to generate an e-mail with an EXCEL attachment, but not se 5
How to zip a file before sending it out by macro? 3
send email with email addresses in a range of cells 1
Code to add today's date in subject line VBA 2

Top