edit a macro that will limit the range of cells being copied in the email body

[melody10]

hi

i am back and was wondering if somebody could help me... again..

the attached macro is working fine. i just need somebody expert to edit the file such that the range of cells that will be copied in the email message is just column B-I (or even better if I can have the option just to add/delete columns I want in the macro like if I want just to copy B, D, H, I). Right now it is copying B-M in the message and I really do not need the extra columns. Also is it possible to include the explanation of your edited portion of the macro? so when I need to edit it again, I can do so by myself.

last.... i need to recreate a 2nd "Send email" button which does the same thing but the only difference is that instead of reading the addresses in column V, it would consider column W?

please... please... please..

and i appreciate the time spent for this...

[melody10]

Any brilliant ideas from anybody?

[jaslake]

Hi Melody

Try the Code in the attached...you've got a lot going on but I believe it does as required. The Code MUST be run from the Buttons however you can put Break Points in the Code should you wish to step through the Code.

I've done this as it was the easiest of your two options.

the range of cells that will be copied in the email message is just column B-I

The second option is probably doable but I've not looked at it.

or even better if I can have the option just to add/delete columns I want in the macro like if I want just to copy B, D, H, I

I've commented the Code for the changes I made.

[melody10]

seems working fine.. thank you very much!!!!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.

[melody10]

hello

i tried using the macro with real data but i am having some problems when filters are applied... can you please take a look into it?
i have attached the file....

my filters are applied in H, I, S..

hope anybody could help please?

[jaslake]

Hi Melody

I took a quick look at your attachment and it appears the immediate problem is you have empty Email Addresses. I'll look at it further tomorrow, probably later in the day. Have other responsibilities in the morning, early afternoon.

[melody10]

thanks jaslake... also if you would look into the body of the draft being created, it seems as if there are too many blank rows being copied... maybe you could do something about it...

looking forward...

[jaslake]

Hi Melody

Give me an example of the Filters your using in H, I and S.

[melody10]

Hi Jaslake

Please see attached in filtered form.

I will always be filtered as = Open, Pending, In Progress
S is filtered in = Not in Freaking SOP
H = will be filtered 1 item at a time

[jaslake]

Hi Melody

The Code in the attached appears to do as you require. This File is the File you attached in Post #6.

[melody10]

seems working now... as always your code works great...
thank you soo much.

hope i could somehow repay you for all your help.

[jaslake]

You're welcome...glad I could help.