Timesheet export to .xlsm with macros

[ismailshajji]

Hello friends , I am struck once again developing my time sheet workbook, i would be greatful if anyone can help me.
My issue , is it possible to export the active sheet with its macros and conditional format staying intact and attaching to outlook.
currently i am using the below macro one for save as pdf and email and other is auto name tab . one more issue is that the date is calculated based on a different sheet as seen in the time sheet.
sorry forgot to mention is it possible to copy the following range A37:O59 and past it i the body of the email some of the cells are merged in the range A37:O59.

Please Login or Register  to view this content.

[ismailshajji]

i have managed to export to xlms format now but still struggling with coping the following range A37:O59 and past it i the body of the email .Any Help please, its really late and i am really tired.

[Pepe Le Mokko]

Administrative Note:

Please don't quote entire posts unnecessarily. They are just clutter and make threads hard to read.
Use the "Quick reply" instead
Thanks

[Pepe Le Mokko]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[ismailshajji]

Administrative Note:

We don't expect you to bump threads sooner than 24 hours after your last post or more than once a day . Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

I am so sorry if I have offended anyone , I was just joking. I do understand that this is a Voluntary service for which i really appreciate everyone's effort .

[ismailshajji]

thank you all for your help. I have managed to copy the range on the emailbody after lots of trial and errors if any ones interested below is the code.

Please Login or Register  to view this content.

[Pepe Le Mokko]

Also please read post #3