Hello all,
I have got a table with emails listed:
Company AMKL amkl@amkl@amkl.com HFTS hfts@hfts.com
Also I've got separate sheets named identically to the company name. I a macro that will send the emails with a range from a matching sheets. I'm thinking the best option to do it would be using the method below. But ould you suggest me how do I put it into the loop?
Please Login or Register to view this content.
Ok guys,
Currently I'm using this code below. But the problem is I got 11 sheets to send out individually. That means I got 11 separate macros and to send the emails out I need to start call them all. Cant this be done in the loop so it is more efficient to run it?
Please Login or Register to view this content.
This will give you an idea of how it can be done.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
I assume my answer helped in some way since you added rep points?
Anyway, thanks for adding the rep points.
Yes it was helpful, straight to the point. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks