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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top