Launch Outlook and Copy only Columns and Rows with Data

Hi,
I have been strugling with this one, I learned of some scripts here at this forums on how to launch outlook and copy columns and rows to it.
However, is it possible for the Macro to only copy the rows only to the extent where there is data?
Below is an example, it copies from B6 till V500. At times I only have data until V200 or maybe less. Is there a workaround for this? I mean copy only to outlook those columns and rows with populated data.
Please advise?

Thank you.

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Choose a column, in this example, B, where you know there will be data in the last row, for example, a Total.



Regards

You're welcome. Thanks for the rep.