Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MailEnvelope
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailenvelope Gives Error to Only One User | Excel Programming | |||
using MailEnvelope | Excel Programming | |||
Emailing a Filtered Range w/ MailEnvelope | Excel Programming | |||
MailEnvelope | Excel Programming | |||
using MailEnvelope | Excel Programming |