Automate emails from Excel, attach a table

[loribear180]

Hello! I'm hoping someone can guide me into what I'm trying to do, I have data in Excel that I copy&paste into Outlook and then proceed to send an email with the Excel data in a table format (4 columns by 5 rows max).
I'm trying to automate the process and would like to create a mailer list with generic language, and have each email be sent with specific data in table format. I was thinking I could group each little table and have an email address next to it, or something. However, I don't know where to start with this automation process. I'd appreciate if anyone can point me in the right direction

 

[loribear180]

@288enzo I am so dumb, I realized I had completely butchered the code. I finally have the output needed! You are a life saver.

As a newbie to VBA, two last questions, what or who is Fluff? and I see that the VBA code has two parts, one that started with sub and the other with function rangetohtml, what are these parts?

 

[288enzo]

@288enzo I am so dumb, I realized I had completely butchered the code. I finally have the output needed! You are a life saver.

As a newbie to VBA, two last questions, what or who is Fluff? and I see that the VBA code has two parts, one that started with sub and the other with function rangetohtml, what are these parts?

Fluff is another user here, I would call him a super user, his/her knowledge is out of this world.

sub is the actual macro that you're running, the function is, for a lack of a better description, a macro inside of a macro. You can't run a function directly, it can only be used as part of a standard sub routine. I personally have never used a function with the exception for this particular instance.

I've been tinkering for over a decade, and I feel like I only know about 2%.