Excel VBA Macro: Send Email With Multiple Tables In Body (Static and Dynamic Ranges)

Excel VBA Macro: Send Email With Multiple Tables In Body (Static and Dynamic Ranges). In this video, we go over how to send an email with one more than one range/table in the email body. We utilize the RangetoHTML function in order to do this. We start with static ranges and create are own function that returns a range to deal with dynamic ranges.

#ExcelVBA #ExcelMacro

[tramanand]

Can't thank you enough....exactly what i was looking for...deep appreciation🙏🙏🙏

[janicemoe]

This video solves the problem almost completely! Just one thing! I’d like to send respective tables to respective mails! How do I do that? Much help is needed since I am an intern and i am assigned with this task! Crying 😭

[nellrios]

Impressive, It was very easy to follow and understand even though I have no knowledge of VBA! thanks :)

[anticlimactic]

I love your videos. Im so happy I found your channel :)

[chenaou]

Great Amazing Wonderful examples and dude your code is clean, thanks a lot I was needing this, Im not a genius on VBA I barely copy and paste codes and understand the syntax, but creating the code is out of my reach.

Can I ask you if it's possible to paste the Tables as Images in the HTML body ?

Could you share the syntax ?

[vashisht]

Gregg, thank-you, ( just a quick question I want to add same table format(with different values in the table) for each new email I send )...I got all the to, cc, bcc, subject, attachment in one sheet (multiple row of entry), please help🙏 how can I get different values of table change for each email it sends....

[sterlingjones]

This is so helpful! Is it possible to send a bulk email with different parts of a table in each email? For example, I need to send a large amount of emails, but the data within the table will need to be specific by customer email.

[Lyriks_]

Shout out to rg3 ahah i liked that, even though i don't watch football. Thanks man i appreciate your videos

[siddheshkamatgi]

Hi greg, thank you for this video, it has helped me a lot!

Just wanted to know if we it auto pick the col number and row number for second table rather than mentioning manually every-time.

[mohamedelsobky]

Hi Greg ;
Please i got a error in below line ( object-define error )

Set locate = Sheets(sh).Range(Cells(y1, x1), Cells(y2, x2))

[soo]

This is a very awesome video! Dear Greg I have 2 questions:

1- what should I do to add the actual xls file to the email as an attchement?
2- if I have an actual list of emails in a predetermined cell in the document, how do I add that to the .CC or to?

[marekpapp]

When I run the macro I get the error: "Sub or Function not defined" and highlighted: "RangetoHTML (rg1).

Can someone please advise me what to do with it?

[shreyassiyer]

Hi Greg, great video ur videos helped me a lot thanx for all the effort u have put it. I jst have one question if my data is dynamic and the 1st table is 2 rows bigger then the whole code go incorrect ryt and I will have to change the code everytime whn the table increases or decreases, is anyway that you can assist me on this.

[noorhiryanirosli]

Hi Greg! LOOOOVEEEE the way you explain every single code line by line. i need some help with macro. i tried to use several examples from your email related videos and i dont seem to get the end result that i wanted. so here's the situation :

i have a big list of data in a table in excel. this list contains of all the issues faced by company X which dated back from 2020. every month we will need to send out email to several stakeholders to update them and highlight to them in a table format in the email what last month's issues were. so i wanted to create a vba code that filters the list first by date and year. and then copy issue A in a table. issue B in another table and C in another table. all these new tables will be on another worksheet. this table in the new worksheet will then be in the email body and sent to the stakeholder.

i am currently stuck at getting the program to filter out the issues one by one and paste it in another worksheet. I would really appreciate if you could do a demonstration on this :)

[ypdc]

Hi greg. Thank you this is super helpful. I am getting an error “ByRef argument type mismatch” i followed everything just didnt know what i did wrong

[suryabhaskar]

Hi Greg,
Greetings of the day!
It was an amazing video, but only one thing is that html function is creating temporary files it is causing error for the next time. Please share the solution to delete the temp files during macro running. Please help me with your solution

[tengchin]

Hi Greg, Good video. I tried to follow your instruction and it's work. it also copied the hiden rows, how can I show the display without showing the hidden row? Can you give me some guidance? thanks

[AlumniTTV]

How I can do this but with different tables from different sheet? Thanks!

[architvyas]

How to select table from different worksheet to send mail ?

[ashutoshvarshney]

Hi Greg, is there any way i can communicate with you as i extremely need a big help on a project?