Hey!
There seem to be quite a few topics on this, but I don't know why I cant get it working, I don't seem to understand something.
I need a code to open a particular excel file that gets emailed me and my boss automatically daily.
This will be implemented into a button that we would click once a day to update the profit and loss on our excel sheet.
I need the code to open
outlook
find the most recent email from "quickbooks@notification.intuit.com"
download the excel sheet called "Profit_and_Loss_by_Customer.xls"
the download should probably be in a temp folder, and then deleted after it closes
and then open the spreadseet.
I already made a macro for everything else.
I saw this also, to do it from outlook, but I don't think that would work out, because I would have to put it on multi computers?
Any help that you could give me would be appreciated! Thank you!
There seem to be quite a few topics on this, but I don't know why I cant get it working, I don't seem to understand something.
Open Only Excel files from Outlook Folder
Sub InboxToExcel() Dim olApp As Object 'Outlook.Application Dim olNS As Object 'Outlook.Namespace Dim olItems As Object 'Outlook.Items Dim olItem As Object 'Outlook.MailItem Dim olAttach As Object 'Outlook.Attachment Dim Flg As Boolean Dim i As Integer Dim MT As...
www.mrexcel.com
Download outlook attachments with vba according to subject does not work on other computers.
I have a code that downloads attachments according to the subject, this subject is extracted line by line from excel to outlook. On my pc it works perfectly, but when checking it on another computer it doesn't throw an error message, but it doesn't download the files either. sub download() Dim...
www.mrexcel.com
I need a code to open a particular excel file that gets emailed me and my boss automatically daily.
This will be implemented into a button that we would click once a day to update the profit and loss on our excel sheet.
I need the code to open
outlook
find the most recent email from "quickbooks@notification.intuit.com"
download the excel sheet called "Profit_and_Loss_by_Customer.xls"
the download should probably be in a temp folder, and then deleted after it closes
and then open the spreadseet.
I already made a macro for everything else.
I saw this also, to do it from outlook, but I don't think that would work out, because I would have to put it on multi computers?
VBA - Outlook attachments
Hi, I receive multiple emails daily with attached .csv files and am looking for a macro to save the files to a folder location based on the email subject (file name is auto generated and changes daily so I can't use that). The files received currently do not go to my inbox but are directed to...
www.mrexcel.com
Any help that you could give me would be appreciated! Thank you!