Hi all, hope you can help me with the below. Thanks a mill!
I'm looking to post contents within a defined set of cells in table format (e.g. B2:E20), directly into a MS Office Outlook 2010 message i.e. I click a button in my spreadsheet and the table with related contents is automatically transposed into an outgoing MS message.
The issue I have is that while columns are fixed, the rows of the table are variable i.e. sometimes I may only have data for 2 line items, while other times I may have 20 line items.
Is there a way for code to detect the number of line items I have and transpose the table to outlook message window accordingly?
Thank you in advance for the help, I just learned VBA a month ago and am not well versed in coding for such a complex request.
Any help would be greatly appreciated