View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Integrating Outlook, Word, Excel macros

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!