More info please ?
We should no longer have to ask this one, but I will yet again -
- Is it VB6 or VB.NET(plural)
- Do you wish the user to see and.or interact with the about to be sent
email ?
- Do you wish a copy of the email in your Outlook sent folder ?
OR are you happy to have no record of the email ?
- Will there be attachments ?
- Can it be plain text, or do you need html formatting ?
- Will there be any embedded images (Logo or whatever) ?
- And anything else we should know ?
Regards,
Rob

Hello Rob,
I'm not programmer Rob. Just learn VB in Excel. I used CreateObject ("Outlook.Application")
Yes, the mail need attachment, an excel table (few rows & columns) in the body of the email. I don't need a copy of sent mail in outlook.
Dim appout As Outlook.Application
Dim smail
Set appout = CreateObject("Outlook.Application")
Set smail = appout.CreateItem(olMailItem)

Hi,
I am struggling to recover my main PC, so I can only give a quick
response (at the moment)
Here is a link to vbsendmail -
http://www.freevbcode.com/ShowCode.Asp?ID=109Not sure if it can be run from Excel vba code.
This is free, and allows you to do all the things I mentioned in my
first email.
It does NOT require Outlook to be present in the user's PC
I have built it into one of my programs, and it can send formatted
emails with attachments and with an embedded Logo(image).
Embedded means the image is truly part of the html code (not an
attachment, nor a link to a server).
It may be a bit of overkill(the learning curve), for what you are
attempting at the moment, but is definitely worth getting and using in
the future.
Regards,
Rob .