M
Mara
Hoping you can assist.
(Did post this 3 hrs ago but it hasn't appeared on the internet. Sorry if
this has caused a duplicate post)
I'm receiving hundreds of emails every day with an excel attachement (all
excel files have same format). I'm required to collate the details on these
attachments into the one table for reporting purposes. I was hoping this
could be done automatically via a link from the Outlook 2007 folder to Access
2007.
I've successfully created an External Data Link with the outlook folder,
which populates everything relating to the email except the details on the
actual excel attachement.
Is this possible and if not, could you recommend another solution to assist
automating this process? Presently it's unrealistic (time wise) for me to
manually open each email and copy/paste the excel file into another folder
for upload.
Open to suggestions !!
(Did post this 3 hrs ago but it hasn't appeared on the internet. Sorry if
this has caused a duplicate post)
I'm receiving hundreds of emails every day with an excel attachement (all
excel files have same format). I'm required to collate the details on these
attachments into the one table for reporting purposes. I was hoping this
could be done automatically via a link from the Outlook 2007 folder to Access
2007.
I've successfully created an External Data Link with the outlook folder,
which populates everything relating to the email except the details on the
actual excel attachement.
Is this possible and if not, could you recommend another solution to assist
automating this process? Presently it's unrealistic (time wise) for me to
manually open each email and copy/paste the excel file into another folder
for upload.
Open to suggestions !!