Post Excel Table Contents into MS Office Outlook 2010 Message

[josephyschen89]

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 (stand-alone app, not web-based) i.e. I click a button in my spreadsheet and it automatically opens a MS email window with the table and its related contents within it.

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

 

[Chihiro]

Please read below link.
https://chandoo.org/forum/threads/new-users-please-read.294/

Specifically section about Cross-Posting below.

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

You were also given warning at www.excelforum.com as well. Please abide by the rules. They are there for reason.

Further reading on why cross-posting rules are there in most forums.
https://www.excelguru.ca/content.php?184

 

[josephyschen89]

https://www.excelforum.com/excel-pr...ents-into-ms-office-outlook-2010-message.html

Addressed here. Apologies.