emailing from excel

  1. P

    Emailing Multiple attachments with VBA code

    Hi, I am using VBA code to send multiple clients with copy to some. It looks like below... I want to attach multiple file ....plz suggest. ************************************************** Sub Mail_Send_withattachment() On Error Resume Next Dim employeename, tomailid, ccid, bccid, compname...
  2. J

    VBA code for emailing payslips from excel source file as pdf's to multiple employees.

    Hi I am rather new to VBA but have used Excel for some time. I have an excel file dump of employee payslips each week. All employees are contained in the one worksheet - structure of data is regular so a search for a key cell value eg "Earnings Summary" at the start of each payslip then create...
  3. Fishboy

    Emailing 2 non-consecutive rows via VBA

    Hi all, I am trying to help another member in THIS thread. The idea is to loop through checking one list against another list and where matches are found, to send the row from the first list as an email to the corresponding email address found in the second list. This much I have working as...
  4. K

    Emailing a worksheet

    I am trying to write a "script/VBA" that would copy ONLY THE VISIBLE CELLS in a specified range (A4:H75) and paste them AS VALUES into a new worksheet. Then email this new worksheet to the email address in the original spreadsheet's cell A1. Please help!
  5. J

    need to email when cell is blank and row header date is over 2 weeks old

    windows 7-64, excel 2007 i have tried 3 or 4 different ways for the last 2 days, i get close but no luck, I need a fresh set of eyes. Driver ___ 4/1/12 ___ 4/2/12___ 4/3/12___ 4/4/12 xxxxxxx ___blank _____ NV _____ blank ___ blank...
  6. B

    vb Code for Emailing worksheet.

    Does anyone know a simple code for emailing the worksheet instead of the entire workbook. Sub HOLYCRAP() ' ' HOLYCRAP Macro ' ' ActiveSheet.Unprotect Range("A4:Q23").Select Range("Q4").Activate With Selection.Interior Selection.Interior.ColorIndex = 35...
  7. J

    E-Mailing sheets from a workbook

    <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>Hello everyone, <o:p> </o:p> Thanks for taking the time to look into my question! <o:p> </o:p> The below code works well for e-mailing sheet to different e-mail addresses that are identified in the code...
  8. V

    Attempting to email pivot charts for excel

    I found a wonderful resource @ http://www.rondebruin.nl for macros. I have been doing trail and error. This is a very frustrating experience. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> What I am attempting to email two pivot charts in the same email...
  9. V

    Complete Automation and Emailing from within Excel 2003

    I tried to find a post that already was created (in this year) for this type of issue. If I placed this in to the wrong thread please move it to the proper place. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have gone though a lot of the postings...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    • Started by ipbr21054
    • Replies: 37
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    • Started by Moeey
    • Replies: 34
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    • Started by zookeepertx
    • Replies: 30
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    • Started by AllisterB
    • Replies: 30
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    • Started by bricegoing
    • Replies: 29
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    • Started by laura_pink
    • Replies: 27
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top