B
Bob Phillips
Hi Guys,
I have the following code that I use to send a mail from within Excel.
It all seems pretty straight-forward, Redemption seems to integrate well
with Outlook.
I have one major problem though, in that if I send directly in-stream the
email does not get sent, it simply gets stored in the Drafts folder.
Normally, mail goes straight to the Outbox when sent. If I change the .Send
to .Display, and then send the displayed email, it works fine. However, this
is hardly an automated solution.
Anyone ware of this problem, and know a solution.
I am using Excel 2000, XP Pro (SP1).
By the way, the RangeToHTML call is simply to get an Excel range to HTML.
I have the following code that I use to send a mail from within Excel.
It all seems pretty straight-forward, Redemption seems to integrate well
with Outlook.
I have one major problem though, in that if I send directly in-stream the
email does not get sent, it simply gets stored in the Drafts folder.
Normally, mail goes straight to the Outbox when sent. If I change the .Send
to .Display, and then send the displayed email, it works fine. However, this
is hardly an automated solution.
Anyone ware of this problem, and know a solution.
I am using Excel 2000, XP Pro (SP1).
By the way, the RangeToHTML call is simply to get an Excel range to HTML.