send to range, popup box to input what the range should be each time/select range

[lax2734]

Hello all,

I have this code which works okay if there is an email in each of the specified cells in column b. However, the issue i have is that when i do not have an email address in a cell it will not continue. I was wondering how i could incorporate a popup message box asking me what range i would like to send this general email to.

any and all suggestions are greatly appreciated!

[BuckoAk]

I added to your code a section that takes the Array and Removes all of the Empty Items from the array.
It then compiles a new array list for your email to read from.

Give it a try, hope this helps.

Please Login or Register  to view this content.