emailing from excel

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

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

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

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!

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

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

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

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

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