VBA help

[delone]

I have put together a spreadsheet for work, but stuck on one part, i am trying to do a formula/vba to send data to an email address.

A4:G10 Fixed Cells (Required everytime)
A11:G11 is the heading of a Table, which can go from 1 Row to 20 Rows depending on product. The Table will be at the bottom of the fixed cells.

What i need is a way of copying the Fixed cells and the table below and send it to an email address with the subject as Stock Check.

Would be grateful for any help

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1052179-vba-formula-help.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.