Forum

All in all, millions thanks to everyone interest in the post in particular, my tribute to Philp Treacy for his patience, precious time and guidance ...

So sorry just ask a bit more, in the Macro how to change the font style and font size in the Email body For example : Font style="Arial Italics...

Had tried, it works beautiful!

Thanks Philip, will put on that in the Email Macro.

Thanks everyone effort and constructive ideas look into the problem. Fortunately errors resolved as the Email Master List [ System downed file] - s...

How far did the code get? What was the PT filter set at when the code stopped? Does that person exist in the Managers table? David: Very str...

On Error GoTo 0 'On Error Resume Next 'Create the PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Fil...

Noted, Philip your advice [ password issue] Will tidy-up all Tables, and re-run the Macro Will use F8 to debug the VB to locate where the err...

Sorry I test run again with actual data but after a few record the Macro come to a halt..

Deep thanks Philip, rectify my serious error, had tried again and work perfect, beautiful and powerful codes, save a lot of our laborious manual work...

In core program of SAP, normally any SAP System Tabular Data display may be prohibited to be extracted, [ copy and paste ] should ask for API data ...

Thanks, Mynda, that's the solution we want, we can tell and enjoy the power of Power Pivot and Query. It saves our effort to juggle around the comp...

I transform the data sheet to Table , but still not sure how to use the Power Pivot to to overcome the calculated field errors in the sample. [...

I got Power Pivot as an add on in my Excel 2010, but not so sure how to work out a solution to solve the calculation problem with this PT.