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...

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

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.

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...

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.