Send email from VBA program in XL2003 or WD2003

[blue moses]

My employer has configured my PC with Office2003 and Groupwise7

Mail merge does not work.

I wish to send a simple email.
In Word the document.sendmail command will not let me add a recipient email address, but it will let me use the message of the Word doc as the text of the email
In Excel I can use recipient:=recipient@domain.com but the Excel doc goes as an attachment.

How can I send an email with text from VBA to an email address entered via the program rather than via a dialog box?

[macropod]

Hi Blue Moses,

Please explain "Mail merge does not work".

[blue moses]

Hi Blue Moses,

Please explain "Mail merge does not work".

When I use MAIL MERGE to SEND EMAILS, it does everything except send an email. I can use MailMerge to produce individual letters to print, but I think maybe my employer has disabled the email feature somehow <grrr>

[macropod]

Hi Blue Moses,

I think maybe my employer has disabled the email feature somehow

I that case, I suggest that's the place to start - find out whether this is intentional or perhaps a system fault. After all, if there's a fault, it may inhibit a vba solution and rectifying the fault might be all you need for a mailmerge to work. Conversely, if its due to a company policy, your efforts to get around it might not be well received ...