I'm having some problems with sending an e-mail using VBA in Excel.
- I only want to send some text as the e-mail message but in addition to the
text the entire worksheet is being sent.
- Even though the e-mail message is sent automatically, my Excel application
shows the E-mail header with the To, CC, Subject, and Introduction fields and
a toolbar where I can push the Send This Sheet button. I can't cancel this
(because there is no Don't Send This Sheet button) and if I push the Send
This Sheet button then it sends a second copy of the message.
- My code sends several different e-mails to different recipients by looping
through all the rows in the worksheet until all desired e-mails have been
sent (each row of the worksheet contains the required information like the To
and Subject etc for 1 e-mail message). But while the first e-mail is being
sent, the loop continues executing (ie, it doesn't pause until the first
e-mail is sent) and so when I try to execute the command
ActiveCell.Offset(1,0).Select I get an error because Excel doesn't have the
focus (the e-mail message has the focus) and so the ActiveCell isn't
understood.
I'd appreciate any suggestions.
Thanks