Microsoft Office Forums - View Single Post - Mail every worksheet with address in A1

Thread: Mail every worksheet with address in A1

View Single Post

Old

06-07-2018, 10:23 AM

Andy79

Andy79 is offline

Andy79 uses Windows 10

Windows 10 Andy79 uses Office 2016

Andy79 uses Office 2016

Office 2016

Novice

Join Date: Jun 2018

Posts: 1

Andy79 is on a distinguished road

Default

Nearly There

Hi Roger

Thanks and its a great bit of code but it only works on the first sheet. Is there a way to replicate/loop it over all the sheets.

I'm so very nearly there.

Thanks
Andy

Reply With Quote