Find Totals And Send Emails To Different People
Jul 3, 2009
to create a macro to send emails.
1. Attached is an excel spreadsheet. In column A, each time the word total is seen, i want an email to be sent to to someone with the total in colum E.
Eg.
A B C D E
UAFEQ1 TOTAL xxxx xxxxxxxx xxx R 15 000
ALPROP TOTAL xxxx xxxxxxxxx xxx -R 20 000
For UAFEQ1 TOTAL I would like a mail to be sent to john@example.com
For ALRPOP TOTAL I want like a mail to be sent to peter@example.com
If the total in column E is positive i want the mail to say:
Please see deposit of R 15 000
If the total in colum E is negative i want the mail to say:
Please see withdrawal of -R 20 000
The currency is Rands (South Africa)
Sometimes, i need to send 20 or more e-mails. And these can repeat themselves so, there may be two totals for UAFEQ1 TOTAL and a mail must be sent each time. See attached as an example.
The macro can stop when Grand Total is reached. No email needs to be sent for the grand total.
View 13 Replies
ADVERTISEMENT
Nov 25, 2013
I am look for a way to send out an individual email to a list (Column A) in my excel spreadsheet.
I need to send out an email with a signature in to a lot of addresses.
View 2 Replies
View Related
Sep 15, 2009
I've sent out an excel spreadsheet to a whole load of people and some have received emails back saying that it won't open properly. It's got a form which pops up and populates two data sheets behind it.
One of the issues I've had so far is that the Microsoft Common Controls library isn't installed on some computers so the form won't work. Are there any other controls that are likely to not be installed and thus prevent the form from opening?
View 9 Replies
View Related
Feb 5, 2012
I have an excel workbook which is a result of a sports survey I conducted. It basically shows who likes which sport, what level they're at, preferred time of play, etc, and their email address.
A colleague has created a type of form (using formulas, not VBA) wherein you select your criteria (Sport, Gender, Level etc) and it displays the matching names.
What I'd like is to be able to select, via a check box or similar, 1 or more names from the list of results for that sport, click a button, and their addresses automatically open in a new Outlook mail window for the person to send a mail to those people.
View 4 Replies
View Related
Feb 3, 2009
I was wondering if there is a way to get rid of this? There are about 300 emails that are going to be sent out and this comes up every time.
Or if there is a way to only do it once no matter how many emails get sent.
Here is part of the code..
View 12 Replies
View Related
Feb 3, 2013
I have attached a sample workbook. The workbook already has a macro that can send an email after working out if the date is overdue. I have put a button on the screen, but I would like to remove the button and automate it, I got the initial macro from,( whoever initially put it together) but I have since made some changes to it regarding how the message displays etc. i, 15 or i, 16 in the macro means, There isn't anything in column i and I can't work out the relevance of it.
View 1 Replies
View Related
Feb 13, 2014
I got this VBA code from a colleague which he uses when sending multiple emails from Outlook. This code sends email based from the last cell. What I would like to do is send emails to all the recipients listed in column C. Column A will be the sender and column B will be email subject. Attached is the sample file.
[Code] .....
Send email.xlsm
View 2 Replies
View Related
Apr 30, 2012
Here is how my spreadsheet is set-up. This is unfortunately not something I can change :
- I have a list of products A to Z, starting in A2
- I have email addresses in row 1, starting in B1 up to Z99
- I have a matrix with 4 possible values in B2 to Z99. The values are either "L", "C", "I" or blank.
Here is what I am trying to do :
I would like to have a macro created for each product (column A) to send emails to those indicated in the matrix.
When the email is identified with "L" in the matrix for particular product, this email should be in the To:, when "C" or "I" it should go to CC:
View 7 Replies
View Related
Sep 19, 2008
I have a spreadsheet showing MOT details of vehicles. The details include 'Customer', Vehicle Reg', 'MOT due date', 'email address'.
Basically.. I want a method that will check whether or not the MOT due date is in 28 days time (so exactly 28 days from now).. and if it is.. then I want to use the email address that is on the same row to send the person a standard notification.. and if possible.. include details of the Vehicle Reg.
View 9 Replies
View Related
Jun 7, 2009
I am trying to send to multiple people so everyone sees each other received the email. How would I add other addresses?
View 2 Replies
View Related
Jun 16, 2014
I am working on a spreadsheet that keeps track of upcoming contract and service renewals. Within the spreadsheet there is a column named "Status"; using a formula based on the renewal and engagement dates this column will automatically state one of the following -
"Contract Status OK"
"Up for Renewal"
"Renewal Due"
When I open the the file I would like excel to email 2 specific email addresses. The email should only contain data from the rows that state "up for renewal"; this email will act as trigger for my team to engage with the suppliers in question.
View 2 Replies
View Related
Apr 29, 2014
I have specified the email addresses in the code to whom the email will be sent when the user presses "Send Email" button but now I want to add all the addresses in the Access table and write down the code that will send an email to those people whose addresses are in the Access table.
[Code] .....
View 5 Replies
View Related
Feb 18, 2014
get the code for sending multiple emails as per the spreadsheet list. Assume the spreadsheet has 100 line items and each columns specifies the name of the person, value, recipient email address ("To" and "CC") and sender name.
And the Body of text is :
Hi "Name of the person" Please find the value of "Value" to be paid for the moth of xxx and kindly let me know for further clarification.
View 1 Replies
View Related
Feb 20, 2009
I am trying to send emails using a table in Xl2002 via outlook2002.
The code below is from Walkenbach's VBA Bible for Excel 2003 and I am getting "Uesr-type not defined" error with the 1st Dim statement.
Do I need a different statement such as set OutObj = blahblah or similar?? I have searche dthe net hi & lo for a solution to this problem & I do have JW's excel VBA bible.
Sub SendEmail()
'Uses early binding
'Requires a reference to the Outlook Object Library
Dim OutlookApp As Outlook.Application
Dim MItem As Outlook.MailItem
Dim cell As Range
Dim Subj As String
Dim EmailAddr As String
Dim Recipient As String
Dim Bonus As String
Dim Msg As String
View 9 Replies
View Related
May 18, 2009
I am trying to find the first and last names of people in a cell. I have a userform to get their first and last names separately. I am trying to run a VBA macro to determine if each cell in a column contains both first and last names, and then put a "Y" in an adjacent column. The Code I have is as follows:
View 5 Replies
View Related
Dec 22, 2008
I have a query where I am trying to find out how many people passed in green, amber and red from a series of data. I know (from the attached file) how to find out how many greens, ambers and reds there were, but how can I find out how many of the 7 in cell B12 passed in Green?
View 2 Replies
View Related
Feb 28, 2007
Is there any way to find out how many people are scheduled between certain time ranges.
For example : I have 5 people scheduled with various start and finish times ie.:
1. 10:00 to 15:00
2. 11:00 to 16:00
3. 08:00 to 14:00
4. 13:00 to 15:00
5. 12:00 to 16:00
Is there any way to analise this schedule in format:
08:00 till 9:00 1 scheduled
09:00 till 10:00 1 scheduled
10:00 till 11:00 2 scheduled
11:00 till 12:00 3 scheduled
12:00 till 13:00 4 scheduled
13:00 till 14:00 5 scheduled
14:00 till 15:00 4 scheduled
15:00 till 16:00 2 scheduled
16:00 till 17:00 0 scheduled
View 10 Replies
View Related
Dec 26, 2013
table1.jpg
I am looking for a formula that will satisfy the following:
1) find all the values in column "A" that match
2) In column "G", sum up all the values in "F" that go with the matching values in column "A"
3) For example, in rows 14-16, the values in column "A" match. Cell G16 sums up F14:F16
View 3 Replies
View Related
Sep 7, 2008
I used Scheduled Task to set up my spreadsheet to open daily. I have the code with assistance to pull out the due date items and place them into an email.
I have come across XLSTART/AUTOEXEC/ACTIVATE...ETC...
But cannot figure out the code that will automatically "enabling macro" once Scheduled Task opens the spreadsheet?
Then once the macro runs, the email with the due dates, how can this auto send without user interaction?
(currently I would have to hit send)
I am trying to make the process totally automated to open the spreadsheet at a certain time, send the email with due dates and close the spreadsheet.
Following code in ThisWorkbook--
Private Sub Workbook_Open()
Check_Date_Send_Mail
End Sub
Code in Module1--
Option Explicit
Sub Check_Date_Send_Mail()
Dim wbBook As Workbook
Dim wsSheet As Worksheet
Dim rnDate As Range, rnValue As Range
Dim stAddress As String, stMsg As String
Dim stRecipient As String, stSubject As String
Dim stPost As String
Set wbBook = ThisWorkbook
Set wsSheet = wbBook.Worksheets("Sheet1")
With wsSheet
Set rnDate = .Range("d2:t23")
End With
View 9 Replies
View Related
May 16, 2007
We use proprietary software to connect to an oracle database. The proprietary software has its own login form. I connect to 4 or 5 different databases randomly throughout the day. I wrote a script that I thought would alleviate my login woes but it doesn't work. The login, password, and database info get sent to the form but they all end up on the login line. Instead of the tab character being sent, I get a Beep generated for each line of code that is supposed to send the tab key code. My code is below and is stored in a *.vbs file.
setwshShell =wScript.CreateObject("WScript.Shell")
wshShell.AppActivate "Title Of My Login Form"
wScript.Sleep 100
wshShell.SendKeys "My Login Name"
wScript.Sleep 500
wshShell.SendKeys "{TAB}"
wScript.Sleep 500
wshShell.SendKeys "My Password"
wScript.Sleep 500
wshShell.SendKeys "{TAB}"
wScript.Sleep 500
wshShell.SendKeys "Name of My Database"
wScript.Sleep 500
wshShell.SendKeys "{TAB}"
wScript.Sleep 500
wshShell.SendKeys "~"
View 8 Replies
View Related
Jul 12, 2014
I have used a database template from this site and changed it to suit my needs but I have a bit of a problem with some of the code. I know how to update the worksheet with the relevant userform text fields and in another project I did I have successfully sent userform text fields in the body of an email.
For this project I want to update the worksheet AND send an email at the same time. However, using the two pieces of code together is causing an error that I can't seem to solve (using my very limited vba knowledge!). The code I am working on is below and I have highlighted the line that is getting the error message. C
VB:
Private Sub cmdSubmit_Click() 'Submit new record
Dim ws As Worksheet, lRow As Long, Str As String [code]....
View 1 Replies
View Related
Mar 11, 2014
I am trying to write a macro to send mail on every Friday and also on last day of every month. If the last day of the month falls on Saturday or Sunday then the macro should mail on Friday. I have written a separate macro to send a mail. I have also written to check day(ie Monday, Tuesday etc) of today. If today is Friday or month end i can send mail. I dont know how to tell the macro to send mail on friday if the month last date is saturday or sunday.
Sub done()
Dim Dat As Date, x As Integer, y As Date, sorry As String
Dim str As String
sorry = "Today is not friday or month end. So i cannot send mails"
str = WeekdayName(Weekday(Now()))
[Code] ........
View 1 Replies
View Related
Sep 16, 2009
In column G of my excel 2003 worksheet named: Data, I have a list of people's first names. These names were extracted from an external database.
Some of the first names actually contain peoples second names or partner's names.
Example:
John & Jill
James and Sue
Kerrie-Anne
Joanna Lyn
I need a macro to please delete people's second name.
So in the example above I need to keep all names that are joined by: & or and or - (such as John & Jill, James and Sue, Kerrie-Anne).
Also, in the example above I need to delete all names that are joined by a <space> (such as Joanna Lyn).
View 11 Replies
View Related
Feb 10, 2010
It runs fine for me, but when others (who are using Excel 2003) try to run it, it won't fire. The second macro entitled "Delete Foothill" runs fine though. "Run Foothill won't fire.
Sub Run_Foothill()
Sheets("Foothill Plaza (Weekly Call)").Unprotect Password:="Foothill"
'
' Run_Foothill Macro
'
'
Sheets("OC").Select
Range("B37:C44").Select
Selection.Copy
Sheets("Foothill Plaza (Weekly Call)").Select
Range("B4").Select
ActiveSheet.Paste
Range("A12").Select
Application.CutCopyMode = False
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlMedium
End With
View 9 Replies
View Related
Jun 16, 2006
In a desperate attempt to find a solution, I thought I would try what seems to be a very good and helpful forum filled with loads of expertise (yes I'm creaping here).
Out current mainframe systems churns out *.DOC reports for various managers all the time. I am trying to extract the data from these *.DOC files to a meaningful Excel spreadsheet. The first hurdle is killing me and I know that once I get past it I will be heading for the finish line. The email that comes to the inbox has the same title each time. I would like to open the *.doc file in excel, do my calculations and then move the email message to another email folder ready for deleting.
View 4 Replies
View Related
Oct 24, 2013
I have two columns with emails. I would like to delete the emails that have duplicates. I want to delete them from both columns.
View 3 Replies
View Related
May 9, 2009
I have a macro which uses Outlook to send an email. I know it's not possible to over-ride the annoying 'Another program is trying to send an email....' dialogue box but I wonder if there is a way of exiting sub if the user clicks No on that dialogue box?
View 7 Replies
View Related
Jan 21, 2010
I'm trying to send sheets to an email.
My code up to now saves a copy of the sheet in a file, and I send that file out.
Unfortunatly when I run my macro it ends with the email opening, the file being attached, and I need to input the email adress. Also, i need to automatically overwrite what is in the folder.
My code looks nothing like the one on Ron's tutorials.
View 8 Replies
View Related
Jul 9, 2013
I want to run a macro dailly where he is going to look in a specific column and based on that value he needs to send emails based on several other cells.
It is a contract database. So for example in:
column A = Country
B = Supplier
C = Days untill end
D = SPOC
E = Manager
What do i want that when i run the macro he looks at column C and where-ever he finds "90" he send automaticly an email to the personnes in column D and E.
In subject i want to see the name of the supplier.
In the email i want to put a text like :
Hello,
Hereby i want to inform you that the contract "Supplier" is going to expire.
Please take the necessary action!,
Also i want to do the same thing when it hits the "30" with other text but i guess that it easy to do when the "90" works
View 9 Replies
View Related
Jul 21, 2014
I have successfully adapted some code to create e-mails in outlook, insert text, add an attachment and specific who to send - all from within excel.
However, all of the recipients are contacts in our internal address book and what I would like to do is use the "shortened" version of their contact to send the e-mail.
e.g. Simon Jones e-mail address might be simon.jones@mycompany.co.uk - but if I simply type in Simon Jones; and then tab to the next line, outlook works out who this is all on it's own.
The problem is, if I specify in my code to send to Simon Jones; it does not convert it / work out who it is.
Is there a way of doing it via VBA?
View 8 Replies
View Related
