send

Hello All, I use a macro that generates a PDF summary of sales made by each seller. Then, I send each individual PDF to each seller. I do it manually. :-( I would like to modify the current macro (or create another one if easier) to automatize the sending process. Each individual PDF should...

Hi Friends, I have prepare the code for Outlook office 365 window My criteria is one of file is save in my system C:\Drive and this file attache in mail and send to the team member . My code is working if I send only one person, Not working on multiple mail Id , please help for resolve this...

Hi can anyone suggest if there is any way of sending an email only the once based on a cell value. Basically I have a VBA Code that sends an email automatically when my cell AA4 = 1. What I want the code to do now is 1 only send the email once and not go into a loop and continually send...

Hi all, I was able to create a macro that allows me, with the push of a button, to send he Excel file to a certain address. Sub Mod_SendWorkbook() Dim OutlookApp As Object Dim OutlookMail As Object Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0)...

Need Help with code to monitor cell AB1, which counts certain words in a range. When AB1 is greater than zero, the system send an email to alert manager. Also Is there a way to increase the base value of AB1 as the number goes up, without manually changing it from 0 to 1 to 2 etc. Also need...

Hi, I have a list of c4000 individuals records on a spreadsheet who all hold a qualification that has to be renewed every 3 years. I would like to find an easy way to send reminders directly from the spreadsheet to the individuals concerned with all the details they need to renew in an...

Hi, to those who use vba regularly, I'm sure this is an easy one. I have an excel spreadsheet with a number of columns. I currently paste data into email fields to send. I currently send 14 emails. some emails contain more values than others, example below. First email To D2 Subject "Test...

Hi, I have a listbox that is populated based on usernames listed in cells A5-A24. Each username has a checkbox, if the checkbox is selected, I need to send an email with an attachment to that user. I have each of the associated emails listed in column F. The macro I have first creates and...

I would like to be able to send email attachments from excel using VBA. I've got a macro that I use to generate PDFs of customer invoices from a spreadsheet and I'd like to add to the macro to open outlook, create an email, get the email address from the same spreadsheet and attach the invoice...

i want get data from web site with following code: <tbody> range day 11,670 11,300 price 12,191 11,031 week range 11,739 11,060 year range 11,948 3,999 </tbody> <tbody> sharing 20 B base volume 894,454 floating 17% vol ave month 9.059 M </tbody> i want to export...

Hi, looking for some help. A macro is written in Excel VBA to send email through Outlook. I am getting an error, A program is trying to send email on your behalf. Please note that this macro will run on multiple systems where Outlook 365 is installed. In outlook 365, there are restrictions to do...

<tbody> To Subject Content abc@email.com; 123@email.com ABC - 1 Content 1 abc@email.com; 123@email.com ABC - 2 Content 2 </tbody> Hi, i found this code but it only work for email but not suject & content Sub SendEm() Dim i As Integer, Mail_Object, Email_Subject, o As Variant, lr As Long...

Hi folks, hope someone can guide me please. I have a spreadsheet with 900+ rows of data which is concatenated to a point where I have a fully-formed SOAP request in column W for each row. Is there a way that I can either send all of these SOAP requests in one go (which would be great for the...

I am using a macro to send emails. But sometimes I want to see the results first. I can manually reset the options to do so here by changing the remark. ' .send '<-- Send out this email .display'<-- Display instead for the debugging only How can I get a prompt like this one to reset...

I have a daily report I need to send to my manager. Right now, my report has code to copy A1:F30 so I can paste the data into an e-mail. How do I modify this code so that I only copy rows with data instead of A1:F30? Sub Send_Email() On Error Resume Next Dim OutApp As Object Dim...

Hi, I need to send each person his excel attachment , with a template email what would be the solution for 100 more people

Hey, I'm not entirely sure if this is possible - but i'm hoping you can help me if it is. I have a Workbook which contains a number of VBA functions built in. The area I want to focus on is the "Extract worksheet" part. Basically the button will Extract a certain worksheet into a brand new...

greetings i am trying to send out sms using an api http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=username&password=password&sendername=sender id&mobileno=919999999999&message=Hello i want to get the mobileno from a cell in sheet7 of the workbook from "d" the cursor will be in...

I have a list of clients to which i need to send mails. However due to service provider restrictions, i can send these mails at an interval of 10 secs only, or else my domain gets black listed for spamming. I need a VBA code where the comman mail body is used to send the mails to a particular...

Hi all, I have added a checkbox, CheckBox1, to a sheet. When checked, I am trying to send the values of E29 and D29 to the first empty row, to columns A and C on a sheet called Sample. Any help would be greatly appreciated. Thanks, Chris