How can I get my Excel macro to automatically send mail using Outl

Argent

Guest

Posts: n/a

10th Apr 2008

My users have recently migrated to Outlook OWA. They have spreadsheets that
automatically send mail but, obviously, this does not now work as there is no
email client on their machine.

We have experimented with SendKeys, but this is not an ideal solution as we
have to program in waits between keypresses and as the time OWA takes to
respond can vary, we can't always get this right.

I would appreciate any ideas on this.

« Another Question about Save As Dialog box | Conditional + date calculation »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
macro to automatically send an excel spreadsheet by email	MIN	Microsoft Excel Programming	1	12th May 2010 03:41 PM
Send e-mail w/ reminder that can be downloaded to Outl Calendar	DamselNTX	Microsoft Outlook Calendar	1	20th Jul 2008 04:06 PM
How do I send an e-mail to everyone in my address book using Outl	=?Utf-8?B?RnJhbmsgTW9sZXI=?=	Microsoft Outlook Discussion	1	24th May 2006 06:23 PM
Macro to automatically open a website or send an e-mail in excel	=?Utf-8?B?Qnlyb24=?=	Microsoft Excel Misc	3	7th Apr 2006 09:05 AM
Trying to send mail folders from Outlook express to microsoft outl	=?Utf-8?B?aW00bGlua3M=?=	Microsoft Outlook Installation	1	19th Apr 2005 01:27 AM