Hi, how can i send different range of the table to the the different emails. For example the range cells(A2:A5) (Q2:Q5) send to Email in cell S5
then another part off teh table to another email cells(A6:A8) ( Q6:Q8) to email in cell S8, and so on.
I have over 100 emails to send. Can anyone help me with the code for that.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Sorry, i'm not good with VBA.
If i want to add another row in that table, witch parameter do i need to change? So it will end up As A6 and each table would be 4 rows now instead of 3?
Change the 3 in 'Step 3' to 4.
Also change the 3 to 4 in this line:and change the 2 to 3 in this line:Please Login or Register to view this content.Please Login or Register to view this content.
after sending 34 emails, it stops and this massage pops up: "Run-time error'440': The object does not support this method.
Another Option...For original file...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Which line of code is highlighted when you click "Debug"?
hi, this line:
.to = Range("S2 & x + 3)
If you look at the code provided by Mumps1 in Post 2, you will notice your above snippet is not as he supplied...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks