Non contiguous cells selection in a Range in Excel for Emailing with Outlook 2007

[nuttycongo123]

Dear Old Chums ,
See I am still at it..made a little progress but going on ..here is the mutilated code I want to edit ..attached is the dummy sheet sheet .Just need to sort out the range issue for now ..

Please Login or Register  to view this content.

Thanks in advance ...T-10 ,B ,J
Regards
N

[teylyn]

Hello,

although you may feel that we are all your "Dear Old Chums", please be aware that not everybody here is familiar with questions you may have posted earlier.

Above, you post code and mention a "range issue". You don't describe what the issue is. If you are interested in a solution, you'd benefit greatly from not assuming that everyone here is familiar with the situation.

Please describe the problem in the post narrative and don't expect members to either be familiar with your situation or spend considerable time on creating a sample file to run your code and figure out what the issue is in the first place.

cheers,

[nuttycongo123]

Dear Mr teylyn,

although you may feel that we are all your "Dear Old Chums", please be aware that not everybody here is familiar with questions you may have posted earlier, you post code and mention a "range issue". You don't describe what the issue is.

I do realise that world is not a friendly place for everyone and also courtsey is not everyones virtue,but being humble can be learnt ..it's not difficult to try ...I guess may be Macro is easier ...well I have taken the possitives out of your post and am attaching a workbook .No offence ..
Thanks in Advance and chers to you too
N

[broro183]

hi Nutty,

Please note that Teylyn is just completing her voluntary responsibilities and that John (& perhaps me?) have already suggested that...

...PS: should you start a new thread, provide a link to other threads that you feel are appropriate to your issue.

Can you please provide a link to your previous thread so that anyone who so desires can easily become familiar with the situation?

I'm sorry I don't have time to look at your file in detail at the moment. However, after glancing at your posted code, I recommend that you read through every line of code within the "For Each eCell In eRng" Loop. If any line does/returns exactly the same thing for every loop iteration, move the code so that it is only performed once (before the Loop begins). For example, the "Headers" & "bottom border" sections.

btw, I suspect there are still a few tips that you can still learn from the previous thread

hth
Rob

[jaslake]

Hi Nutty
I support Rob's comments. Your thread title and initial file posted gave no indication of your issue. Had I not been familiar with your previous posts, I'd not even looked at it.

You need to help us help you. Give us ALL the information...don't assume we KNOW. Give us TOO MUCH information...we'll sift through the detritus.

See attached.

[nuttycongo123]

Dear All,
@ Ms Teylyn,
...Now what kind of man will ever be rude to a lady ...Was it me ???.. well I must have been knocked off or may be close to being dead to do so ..humour apart I am sorry for being not nice to you ...hell ..a lady deserves respect and I better give it to her ..Cheers .. N
@ R
always love you for driving home a point in best way possible
@ J
..thanks for all your help always..I owe you a beer

[jaslake]

Hi Nutty

For some reason I seem to have lost your PM so I can't respond to it. I recall from the PM you want to send emails ONLY to "Yes" and that you were looking for the border around the last item.

You also asked if you should post an updated file with your new requirements. Well, perhaps yes, perhaps no.

If you wish to send to ONLY "Yes" recipients, why do we have the "No" code? Are you suggesting you wish to CHOOSE to whom to send...either "Yes" OR "No"...or BOTH?

Explain what you need, perhaps I can help.

[nuttycongo123]

Dear J,
I guess My initial post wa a bit confusing ...here in I am attaching a file that explains all..
If the condition is "No "..there should be no e mail going out ..
thanks for your help in advance ..
Regards
N

[jaslake]

Hi Nutty

Should be a rather simple fix...I'll get back to you.

[nuttycongo123]

No Worries J ...Hey I need your advice for a larger problem It's part of the entire configration ..would you be able to suggest ..help ..right now I am working in peicemeal basis and it still leaves a lot to be desired ...I can e mail you my workings and also work books if you are alright with it ..I will be glad if you can assist ...
Regards
N

[jaslake]

Hi Nutty

I think I misread your post. See if this does as you require. By the way, the code should be in a General Module.

[jaslake]

Hi Nutty

Regarding this

Hey I need your advice for a larger problem It's part of the entire configration ..would you be able to suggest ..help ..right now I am working in peicemeal basis and it still leaves a lot to be desired ...I can e mail you my working

I'd STRONGLY suggest you keep it on the Forum. You've got hundreds of better qualified individuals than I to assist you. If you wish I be involved, simply PM me that you've posted a new Thread...I'll look at it.