Hi Mike
Your how to email using CDO article was an absolute lifesave.
Thanks
I don't think you can do it without Word as far as I know
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Mike" wrote in message ...
I'll look into this... Your how to email using CDO article was an absolute
lifesave. Thought I should let you know. Thanks! One more question... The
only reason word is involved is because the attachment opens in word. The
word macro simply saves the attachment as .txt (originally .rtf) and saves it
to a place that I can find it in excel. Is there a way to bypass word saving
it as .txt?
"Ron de Bruin" wrote:
Hi Mike
See
http://www.dicks-clicks.com/excel/olRetrieving.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Mike" wrote in message ...
I posted this in the Outlook forum, but the replies in here always tend to be
genius, so I thought I'd post it here as well.
Summary: Everyday, I receive an email with an attachment. I open the
attachment in word. Run a macro called Acknowledgements (specifically
Daily.Acknowledgements). I then open up excel and run another macro called
AcknowledgementsXL (MainCaller.AcknowledgementsXL). I want to create a macro
that will do all of these steps when the email comes into my outlook or. Is
it possible?
Details:
Every day I get an email from " with the
subject line of "PO Acknowledgement Report from Carrier". This file
contains an Attachment Titled "POAC.rtf"
Any Help would be appreciated!