vba, Email multiple addresses with multiple rows

[Auke]

Hello, my first post.
I'm looking for a solution with my Excel VBA problem.
Hopefully someone is able to help.

I'm looking for a solution to send multiple emails with outlook to different mailadresses with different rows from my excel file.

Employee name	Email address	Info 1	Info 2	Info 3	Info 4	Info 5	Info 6	Info 7
A	A@hotmail.com	A	B	C	D	Info 5	Info 6	Info 7
A	A@hotmail.com	A	B	C	D	Info 5	Info 6	Info 7
B	B@hotmail.com	A	B	C	D	Info 5	Info 6	Info 7
B	B@hotmail.com	A	B	C	D	Info 5	Info 6	Info 7
C	C@hotmial.com	A	B	C	D	Info 5	Info 6	Info 7
C	C@hotmial.com	A	B	C	D	Info 5	Info 6	Info 7

So every employee needs to receive an email with only the rows applying to them.
In this example every employee will receive an email with 3 excel rows in in, the header and the 2 rows related to his name and mailadress.

Is someone able to help me with the code for this?
I've been searching, but I were not able to find the right coding.

Thanks in advance.

Kind regards, Auke

 

[kakdativikam]

Thanks for the quick response.

I'm now getting a run-time error '91': Object variable or with block variable not set. I'm applying this code to a table, so I also tried disabling the autofilter in the beginning, so it doesn't mess with the code, but to no avail unfortunately.

 

[mumps]

I tested the code on some dummy data and it worked properly. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[p2678468]

I was having the same problem with the aforementioned error, but discovered the macro worked just fine if I converted my source table to a range. I have struggled to edit the code to work with a named Excel table, could a new code be provided to work if the data were in a table? Also, perhaps add on whatever the default email signature is for a given user?

 

[mumps]

@p2678468
Hello and welcome to the Forum. Please start your own new thread explaining in detail what you want to do and provide a link to this thread if you think it is useful.