Search results

Macro to excute on first business day of each month to send a email from outlook for eg if 1st comes on saturday it will excute a email on monday, if 1st comes on friday it will excute a email on friday. Below is the code attached Sub Monthly() Dim OutApp As Object Dim OutMail As Object...

Thanks vijay & i will get back to you as i have some thing more. thanks again.

from b1 to p74 i want to copy range and paste in email body, so i have a macros for that, the range keeps on changing that is some times it is b1 to p100 some times b1 to p110. b1 is fix and column P is fixed, only row changes. Is their any way we can do that. you help is appreciated And thanks...

I am trying to send a range of cell from excel sheet Hourly & Campaign in a automated email and it should email addressess from cell af22 (nine email addresses) and cc from cell an22 subject from cell c1 and range from b1 to p105 Any help will be appreciated. Thanks in advance. Ashfaq Sayed

Thank so much you made smile, you guys are awesome, appreciate, once again thank you, i love chandoo.org

i want to increase space and reduce those line from f5 to n5, is there any way i should get direct answer like d5.

In sheet daily points from f5 to n5, i'm using vlookup to get data from pivot table and points next to pivot table, but i have to use vlookup formula from f5 till n5, is there any other method to get same data from all 9 pivot in f5, if u see i have sum from f5 to n5 in cell d5.

Good knowledge about run time error on http://www.compuchenna.com/runtime-error-13/ This will surely help me to find a solution as i understood all the possibilities about run time error 13. Thanks for your support and understanding. loved your support and forum. Thanks, And will be back soon...

Any help please ?

No, I don't thing this macros will run with outlook. I have a different macro which run's on outlook to follow same procedure, below is that macros for your reference and this works perfect. Sub Send_Range() ' Select the range of cells on the active worksheet...

On hte below statement i got run time error "13" .HTMLBody = Range("c1:q71")

I have posted on zimbra also just few minutes back, still help required if any one can help to send email from this macros

Thanks for your suggestion SirJB7, I will try in Zimbra forum..

Excelling in Excel

i have post my query on forum and i will also wait for you...

I want a macros which can send a email from email client base and i'm using Zimbra, that means not from outlook, and email should be send in html format that is color and font should remain the same which i have in excel, it should pick up the range for eg: c1 to q56 it should copy paste and...

Hi Narayan, Perfect Sir, its working every where, K6,K7,K8,K9 and K10..... on and on and on... can i get your mobile no... i wish if i can speak with you.... Thank u so much for resolving my issue and i have two more issues to solve if you can help me that will be great .... i don't know...

I thing we can also use, that is formula Large. Just to correct that line i have repost that line

Hi Narayan, Thank for your reply Formula in the following ranges viz. K6:K10 , O6:O10 , S6:S10 ,.... ; Yes want correct formula in these above ranges , based on the logic i have given. Yes sir, you got that very clear, that's what i want and one more thing if it is "0" in any of cell...

In Row o column 6,7,8 i need a formula which should satisfy condition to give points 250,200 and 150 respectively for a sales person with highest sales in hours that is sum of qualified (m6,m7,m8) and sum of CPH(n6,n7,n8,). If m6, is highest it should give 250 points in row o column 6, If m7, is...

when timer starts in cell A3, B3 with conditional format should display message "on Break" when timer stops in A3, B3 with conditional format should empty.