Hi,
I am kind off new to VBA and i an trying to tackle a problem i have. And am not finding a sollution.
I have a column of adresses that get filled in depending on other sheets. There are 150 possible lines.
What i am trying to do
When C32 has adress send range (J12:U35) from sheet 1 to this adress C32
When C33 has adress send range (J12:U35) from sheet 2 to this adress C33
.... C181
I also need to send this from a specific adress (always the same) and with a specific subject that is on the sheet 1,2... page (C2)
I can send a mail with a range to a specific adress but i cant find how i have to check the cells and send to this mail.
I also don't know if it is possible for a code that can do this without copying it 150 times
I tried so many things my macro is totally broken now
Thanks in advance
Best Regards
Didier
I am kind off new to VBA and i an trying to tackle a problem i have. And am not finding a sollution.
I have a column of adresses that get filled in depending on other sheets. There are 150 possible lines.
What i am trying to do
When C32 has adress send range (J12:U35) from sheet 1 to this adress C32
When C33 has adress send range (J12:U35) from sheet 2 to this adress C33
.... C181
I also need to send this from a specific adress (always the same) and with a specific subject that is on the sheet 1,2... page (C2)
I can send a mail with a range to a specific adress but i cant find how i have to check the cells and send to this mail.
I also don't know if it is possible for a code that can do this without copying it 150 times
I tried so many things my macro is totally broken now
Thanks in advance
Best Regards
Didier