extract e-mail file

[Guest]

I get an email attachment from a program. I extract this
into word, adjust the margins, set to lanscape (so that
the figures line up) and save it. I then open it in excel
(fixed length extract) and save it. I then import it into
access.

Can I simplify this process? I have already created
macros in word and excel and access. The part I have not
figured out yet is how to extract from the e-mail without
manual intervention. Also, is there a better way of
acheiving the same results?

Thanks

 

[Steve Schapel]

What is the format of the original file you get attached to your email.
It sounds to me like it is a fixed-width text file, or delimited text
file. If so, it should be fairly simple to import directly into Access,
using a TransferText macro. Maybe you could post back with some
examples and more information regarding the data you are working with.

 

[Guest]

it is a fixed-width text file with formatting attached to
each page...

Eg:

Report Test Page 1
Item1 Item2 Item3 Item4
-----------------------------------------------
Data1 Data2 Data3

.....

The formatting is repeated on all the pages. Also,there
is a header and a footer for the report.

By the way, can I automatically extract teh file from the
e-mail rather than saving it once the e-mail is opened and
then extracting it?

Thanks