Forum

Hi Maarten, It should work fine. What exactly are you experiencing? Can you supply a screenshot? Regards Phil

Hi Bruno, That file doesn't have any of my code in it so I can't see what you are doing and fix the problems. I've already supplied instructio...

Hi Mourad, What are you doing with these files? Power Query might be a better solution depending on what you are doing. Phil

Nothing received.

Glad to hear it's working

Hi David, Open the workbook. Open the VBA editor (ALT+F11) Open the code module for the sheet (double click it) Select all the code, then ...

Hi David, Workbook Event code needs to be in the ThisWorkbook module, not in a separate code module. Move your code into the ThisWorkbook module- ...

Hi Katerina, If you get stuck just let us know. Regards Phil

Hi Bruno, You can put the file onto OneDrive, Google Drive or DropBox then email me a link to download it. Or email the file to me Phil

You're welcome Al 🙂

Hi Marsil, You insert in where I said to insert it in Reply #2 above. Insert it after Set objOutlookMsg = objOutlook.CreateItem(0) See attach...

Thanks for letting us know. Phil

Hi Al, Attached is a file that creates a PDF report and it emails to the relevant people based on the company names and emails on the Reporting Con...

Hi Bill, How do you know the count is wrong? Can you please share the Excel workbook and the source data file(s) so I can check. Thanks Ph...

Hi Akira, Yes you can email it to us on that address. Regards Phil