AttchmentRead

  • Thread starter Thread starter Frank Little
  • Start date Start date
F

Frank Little

Using Outlook 2000

Mission: Go through designated mail folder, open Excel
attachment and copy certain cells to text file for upload
to ERP.

Question 1: I see warnings that this dosn'e always work
and solution is to upgrade. Is this a must do? (We are in
the process of the upgrade, bit it won't be accomplished
in time for the business need.)

Question 2: Assuming that I can do it in version 2000,
does the item have to be declared with WriteEvents? If so,
does that mean a form or class module?

Question 3: Would I be better off saving to disk file and
opening Excel programmatically?

Thanks
 
1) What kinds of warnings? Saving the attachment to a system folder, then opening it and working with the data using Excel methods should be straightforward.

2) You mean WithEvents? You declare objects WithEvents when you want to monitor those objects for events that might fire. Nothing in the description of your project indicates that it's event-driven.

3) It's not an issue of "better off." That's in fact the correct and only solution.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
Back
Top