Copy specific range with data only

[BenMoss316]

Good day all,

I'm pretty new to this and I'm looking for a VBA solution to the following:

I have a specific range Sheet1 ("B12:L49) and want to copy only cells that include data and pasting without blank spaces to Outlook.

Example:

-------------------------------
Copy:

Test
Test1
"Blank"
"Blank"
Test2

Paste:

Test
Test1
Test2

-------------------------------

Any help from you kind people would be greatly appreciated.
Thanks

Ben

 

[vletm]

BenMoss316
Please, reread Forum Rules.
I'm moving Your thread to VBA Macros (it's now in Ask an Excel question) in this time.

 

[BobBridges]

To Outlook, eh? To an email, you mean? How will it be formatted in the email? One long column of hundreds of values, or in a table, or what?