VBA to send a selection on a sheet in the body of email

**JonSalmon87** · 08-31-2018, 08:02 AM

Hi, Im trying to make an email vba with an activeX button to send a table of information.

I have attached a workbook with the example of what im trying to to for reference.

I am trying to send an email which will in the body of the email do the following:

show cell M17
then 1 line down show range m13:n14
then 2 lines down show the range H4:k33.

As you can see with the coding so far, i am typing in cell by cell, but there must be a more efficient way of coding this?

Any help would be greatly appreciated, thank you in advance!

Kind Regards

Jon

My code so far looks like this:

Please Login or Register  to view this content.

**davesexcel** · 08-31-2018, 08:05 AM

There is no attachment.
What do you mean by..."As you can see with the coding so far, i am typing in cell by cell, but there must be a more efficient way of coding this?"