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