Outlook Emails & Access

[Singinbeauty]

Hello All,

I am hoping once again that your excellent help will save the day! Here's
the deal:

I have several supervisors who will get credit or additional bill requests
(Excel format) from their team. Once they approve it, it gets sent off to me
for processing. I would like to be able to import a hidden sheet, which has
all the pertinent info in a row, and put it into my table.

Is there a way to automate this? Right now I am opening each individual
email - then the attachment - then unhiding the sheet - then copying and
pasting the info into Access.

Any suggestions would be wonderful! Thank you in advance for your help.

 

[Dale Fye]

Sure, you could do this with office automation, but it will obviously be a
multi-step process. Lookup Outlook and Excel Automation on Google, or go to
the Office Developer Automation newsgroup for ideas.

In your Access application, you could setup some code to monitor your
outlook inbox and look for emails with a specific subject or an attachment
with a specific name or file type.

If it finds an email that meets those parameters, it could then open the
Excel file, unhide the worksheet (actually you wouldn't even need to unhide
the sheet if you know the cells you want to get your data from), and then
insert a record into an Access table with values from the appropriate cells
in the Excel spreadsheet.

HTH
Dale