Hi,
i have below macro and i need your help to run it continuously till empty cell in column N. Thank you.
Please Login or Register to view this content.
Hi,
i have below macro and i need your help to run it continuously till empty cell in column N. Thank you.
Please Login or Register to view this content.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Dear JLGWhiz,
thank you for your interest, however i need the macro to do below;
first - send the mail
second - delete X on top
third - send the mail again
forth - delete X on top
....
until there is no non-blank cell in I (it was N before, i updated your accordingly before use)
your nice code worked as
1 - send mail
2 - delete all X on column
3 - stopped
What do you mean by this ?delete X on top
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 think the OP means that the Xs are being used as a counter to control the number of Emails sent and by deleting one every loop, when there are no more Xs the code stops. But I can't be sure that is what the OP wants from the paucity of information provided. If a sample file was uploaded for us to review, maybe we could figure it out.
Maybe this:
Please Login or Register to view this content.
Last edited by JLGWhiz; 02-17-2019 at 10:48 PM.
I have not worked with MailEnvelope before, so I could have the loop starting and ending in the wrong place. I am not going to spend a lot of time researching how to use the MailEnvelope, so maybe somebody else with more knowledge of the issue will step in and assist you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks