Hi Guys,
I have been having a hard time with auto fit to contents the ranges I paste to outlook email. I've been using Rondebruin's Code to send ranges from excel to outlook. However after the VBA completes i still need to manually right click the table and auto fit to contents. I tried adding EntireColumn.Autofit and EntireRow.Autofit in the Function however it only autofit the columns and rows in the temporary workbook and not in the email body itself. Thanks in advance for those that can help.
I have been having a hard time with auto fit to contents the ranges I paste to outlook email. I've been using Rondebruin's Code to send ranges from excel to outlook. However after the VBA completes i still need to manually right click the table and auto fit to contents. I tried adding EntireColumn.Autofit and EntireRow.Autofit in the Function however it only autofit the columns and rows in the temporary workbook and not in the email body itself. Thanks in advance for those that can help.