• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. vigneshjan24

    Need to get rid off top empty line in email while using send email vba

    Below is the script I using for sending auto email of the cell range C9:G27 in the attached Example File. >>> use code - tags <<< Sub SalesReportMail() Dim rng As Range Dim OutApp As Object Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set OutMail =...
  2. vigneshjan24

    Help in VBA generating outlook mail

    Hi, I have some help in sending email using macro. Since i dont know anything about vba, just googled and using this macro to send mails by selecting any range. Sub Send_Selection() Dim Sendrng As Range On Error GoTo StopMacro With Application .ScreenUpdating = False .EnableEvents =...
  3. vigneshjan24

    Growth due to increase in rate & due to increase in unit

    This is actually a mathematical question.. Sales 2014: Rs.36 Sales 2015: Rs.62 Here we can straightly say growth rate is 72%. But, in depth i need deviation of this 72% as how much due to increase in rate and how much due to increase in no. of units. I have attached the template. Thanks in...
  4. vigneshjan24

    How to use SEARCH formula to search only completed words? [SOLVED]

    I want to get a result as if A1 contains the word "pen", in B1 it should result as "pen" otherwise it should be "NO". So this is the formula i used in B1 =IF(ISNUMBER(SEARCH("pen",A1)),"pen","NO") Below are the results: Left side is input and right side is result 1) Black pen = pen 2)...
Back
Top