Possibility to load excel lists automatically from my outlook to MS Access

%3CLINGO-SUB%20id%3D%22lingo-sub-3023948%22%20slang%3D%22de-DE%22%3EPossibility%20to%20load%20excel%20lists%20automatically%20from%20my%20outlook%20to%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3023948%22%20slang%3D%22de-DE%22%3E%3CP%3EI%20receive%20every%20day%20via%20Email%20two%20excel%20lists%2C%20which%20have%20in%20common%20the%20OBDs%2C%20date%20of%20shipment%2C%20name%20the%20carrier%20and%20postal%20code.%3C%2FP%3E%3CP%3EIs%20there%20a%20possibility%20to%20load%20these%20lists%20automatically%20from%20my%20outlook%20to%20MS%20Access%3F%20or%20is%20ther%20another%20possibility%3F%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20display%20a%20single%20list%20throug%20a%20query%20with%20data%20from%20both%20lists%2C%20but%20I%20want%20to%20avoid%20the%20manual%20task%20of%20loading%20these%20lists%20daily.%3C%2FP%3E%3CP%3EThank%20you%20%3Al%C3%A4chelndes_Gesicht_mit_l%C3%A4chelnden_Augen%3A%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3023948%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EPossibility%20to%20load%20excel%20lists%20automatically%20from%20my%20outlook%20to%20MS%20Access%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3028917%22%20slang%3D%22en-US%22%3ERe%3A%20Possibility%20to%20load%20excel%20lists%20automatically%20from%20my%20outlook%20to%20MS%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3028917%22%20slang%3D%22en-US%22%3EThe%20Outlook%20object%20can%20be%20called%20from%20within%20Access%20via%20VBA%20code.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Foutlook%2Fconcepts%2Fgetting-started%2Fautomating-outlook-from-a-visual-basic-application%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Foutlook%2Fconcepts%2Fgetting-started%2Fautomating-outlook-from-a-visual-basic-application%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20Reference%3A%20Outlook%20Attachment%20Object%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.attachment%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.attachment%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E1.%20Loop%20through%20the%20Items%20collection%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.items%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.items%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E2.%20Identify%20the%20desired%20email%20using%20some%20criteria%20(Subject%2C%20Sender%2C%20SentOn%20or%20FileName%20properties)%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.mailitem.subject%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.mailitem.subject%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.mailitem.sender%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.mailitem.sender%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.mailitem.senton%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.mailitem.senton%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.attachment.filename%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.attachment.filename%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E3.%20Save%20the%20email%20attachment.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.attachment.saveasfile%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Foutlook.attachment.saveasfile%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E4.%20Import%20the%20two%20saved%20files%20into%20an%20Access%20table%20using%20VBA%20or%20an%20Access%20import%20specification.%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Faccess.docmd.transferspreadsheet%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Faccess.docmd.transferspreadsheet%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E5.%20Create%20a%20query%20based%20on%20the%20import%20table.%3C%2FLINGO-BODY%3E
New Contributor

I receive every day via Email two excel lists, which have in common the OBDs, date of shipment, name the carrier and postal code.

Is there a possibility to load these lists automatically from my outlook to MS Access? or is ther another possibility?

My goal is to display a single list throug a query with data from both lists, but I want to avoid the manual task of loading these lists daily.

Thank you :smiling_face_with_smiling_eyes:

2 Replies

@tims  Thank you very much for taking the time to answer my question. I will follow the steps you indicated and hopefully it will work for me. Regards