Forum

David, Is your OST file attached to Outlook and in use with an email address? Or is it just a file in a folder? Phil

Hi Adam, Without actually seeing your data I can't give the best answer. You could perhaps use Power Query though that maybe overkill. You could ...

yes, these qs seem like homework ....

Hi Deepak, Without your workbook we have to enter everything by hand. That not only takes time, it makes things prone to error, and it means we ar...

Hi David, In Reply #4 of this thread I explained how to change the VBA. Open the file I created, press ALT+F11 to open the VBA editor then make th...

Hi David, I'll try asking again : Have you tried changing the name in the VBA code to your own email account name? Phil

Hi Carlos, I don't see how that can work as described. If you have the invoice being populated with data from the Shipping Dept sheet, then the in...

Hi Chris, you say you have 24 queries to load the 24 tables from 24 sheets. These are all from the same workbook, or different workbooks? You s...

Hi David, Did you try changing the email account name in the VBA as I asked? I also asked you to let me know the name of that account. And th...

Hi Jacek, The final table is on a new sheet 'Final Query'. Regards Phil

Hi David, Yes you can. Have you changed the Email Account Name in the VBA to look at the folders for the account you are referring to? To help ...

Hi Alistair, Yes you can stop the animation. I've added a stop button and a new sub that stops it. To move the chart, select it, cut, paste to ...

Hi Guys, Try the attached file. I've rewritten it to use late binding so you don't need to set a reference to the Outlook library. Cheers Ph...

Hi David, What does that error say? Have you created the reference to the Outlook library in the VBA editor? Phil