Email subject line in VBA using Sendmail

I am using the activeworkbook:sendmail command, i have a list of addresses and can send to these addresses using:

ActiveWorkbook.SendMail (Recipients:=Range("I1:I3"), _

i now want to get the email to have a subject line of "free text" then D10 and D12 in that order.

can anyone help?

Hello Arnoldn5,

This should do it...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks Leith

That works but i have changed the code slightly to:

Please Login or Register  to view this content.

Its causing some problems with sending from other machines with the error "Genreal Mail Failure"

can this be solved?

Nic

Hello Nic,

If the code is running on your machine, but not on some others then problem is with those machines. SendMail uses the default email client installed on the machine. If the email client has not been setup, the attempt fails.

Sincerely,
Leith Ross