Computer Support Forum

macro to allow a date to send an email in excel

Question: macro to allow a date to send an email in excel

Hi there,

I have a workbook which i would ideally like to send an automated mail when the date is within 30 days of "Todays date" .
I have found something similaar on past posts whichprints certain cells to an email but is triggered by a button press not date, but wondered if anyone could adjust it for me as my excel knowledge is very limited.
I really am struggling.

The password for the spreadsheet is Kalibratedbyme (capital K)

Best regards and many thanks!

Relevance 100%
Preferred Solution: macro to allow a date to send an email in excel

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: macro to allow a date to send an email in excel

The content is different but why are you duplicating a post?

3 more replies
Relevance 91.02%

I found this code in this forum.
i want to add recipient as CC or BCC. What is the correct code for that?
Thanks in advance!

Code:
Public Sub email()

Dim SubJ, Recip As String

SubJ = "Enter your suject"
Recip = "[email protected]"


ThisWorkbook.SendMail Recip, SubJ

msgbox "Email Sent"

End Sub

 

Answer:Send excel sheet ( email) through macro with recipient and cc

6 more replies
Relevance 91.02%

Hi:
I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

desantisj, welcome to the Forum.
There are already 3 or 4 posts on this forum that have the VBA code (Macro) that you can modify for your Workbook if you can read the code. Zack has written the code so it is a bit complicated, but it should be a case of substituting your Cell references that hold the data for the ones that others have used.
Otherwise it is a case of waiting for an Excel guru to come along and help. If none of them come along I can probably help you, but I normally work with Access.
 

2 more replies
Relevance 90.61%

I have an equipment list and I would like to be able to be prompted 1 week prior to the date that my calibrations are due without having to remember to check all the time.Can you please help me set it up so that an email alert can be sent saying that a certain piece of equipment is due for calibration within 1 week.

Answer:how to get excel to send me an email when a due date arrives

I have only minimal skills with Macros but see if this site gives you some ideas:http://www.rondebruin.nl/win/sectio...MIKEhttp://www.skeptic.com/

6 more replies
Relevance 89.38%

hi !
I have a spread sheet of 100 of employees , i like every time the expiry date come for there id a notification email come to me , i attach the example excel sheet please help me with that, i am just learning VBA not very good in it i am using windows 8
 

More replies
Relevance 89.38%

I've read the previous post with the same issue, but I'm unable to understand how to use the other codes posted within my product. I would like to send an email based on a date. I will attach my document so it is easier for me to explain the requirement. Columns L37-L45 have due dates - I would like the email to be sent 60 days prior. I have posted some mock emails in R37-R45 and the email message in the EMAIL workbook tab. Any assistance would be greatly appreciated.

Thank you so much!
 

Answer:Auto send an email based on date in Excel

Welcome to the board.
I've had to save it as 2003 version but the code works under 2007

See attached my copy of your sheet with the code in ThisWorksheet module.

This just a simple way of doing it and you will have to edit it for your needs but maybe it can put you on the right track.
 

2 more replies
Relevance 79.13%

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

Answer:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

16 more replies
Relevance 75.85%

I have a word document that includes a form the user must fill in. I want to create a button that will do all of the following:
1. Update all fields
2. Attach the updated word document to an email
3. Enter an address I have stored in the macro into the To field of the email.

I have one module which does the first part:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing
End Sub

I found that if I add this to the before End Sub it attaches the updated Word document to an email:
Application.Options.SendMailAttach = True 'Or False
ActiveDocument.SendMail

However, I can't figure out how have it put a specific address into the To field of the document.

So I tried another tact. I have the email address as a hyperlink in the document, and set a bookmark at the hyperlink. Then I created a module that will go to the bookmark and open the hyperlink. However, this will not add the document as an attachment:

Sub Open_Hyperlink()
Selection.GoTo What:=wdGoToBookmark, Name:="hyperlink"
With ActiveDocument.Bookmarks
.DefaultSorting = wdSortByName
.ShowHidden = False
End With

Selection.Range.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

So then I found this bit of coding on the web, and tried imp... Read more

Answer:Word Macro to attach doc to email, then send address email

I found a solution, but I think it is a bit bulky. It seems to work but I'd love to know if there is a simpler solution:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing

ActiveDocument.Save

MsgBox "Thank you. Your order has been sent", vbOKOnly, "Thank you. Your order has been sent"
Dim bStarted As Boolean
Dim oOutlookApp As Outlook.Application
Dim oItem As Outlook.MailItem
On Error Resume Next
If Len(ActiveDocument.Path) = 0 Then 'Document has not been saved
ActiveDocument.Save 'so save it
End If
Set oOutlookApp = GetObject(, "Outlook.Application")
If Err <> 0 Then 'Outlook isn't running
Set oOutlookApp = CreateObject("Outlook.Application")
bStarted = True
End If

Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
.To = "[email protected]"
.Subject = "Promo Order" '
.Body = "Thank you for your order"
.Attachments.Add Source:=ActiveDocument.FullName, Type:=olByValue
.Send
'**********************************

End With
If bStarted Then 'If the macro started Outlook, stop it again.
oOutlookApp.Quit
End If
Set oItem = Nothing
Set oOutlookApp = Nothing
End Sub
 

1 more replies
Relevance 75.03%

Attempting to have a current date enter into a cell automatically when cell has been highlighted? Any suggestions or answers on how to do so??

Answer:Date macro's in Excel

When you say "highlighted", do you mean selected?If you mean selected, are you working with a specific cell or perhaps a range of cells? I can't imagine that you want this to occur throughout the entire worksheet.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 74.21%

Hi,I'm currently trying to correct an Excel timesheet for the company I'm working for. For their system, employees have access to a workbook with 52 sheets - each sheet has the date of the Friday for the week as its name. The idea is that every employee can simply input the time they've spent working onto their own timesheet, and this will automatically update the master timesheet.On the master timesheet, the A column has a list of every date for all of the Fridays in a year. In the B, C, etc. cells, I need to set each cell's formula to reference a certain sheet (for a specific date which matches the date listed in the A column) in another workbook. Ex: E13, for instance, should reference the file [ts_2005_mfc.xls], the sheet named 11-Feb-05, and the cell W35. E14 should reference the same file and cell number, but it should be the sheet for 18-Feb-05. This continues for every Friday of the year.While I have no issue accessing the other file, the specific sheet, and the correct cell, I'd like to automate which sheet each cell references. Currently I need to manually change which sheet is referenced for each cell, but a macro of some sort or an easy feature that I'm missing to fix this would be wonderful. Just for extra clarification, the formula for a cell currently reads: ='[filename.xlsm]18-Feb-2011'!$W$35And the cell beneath is is exactly the same, but says 25-Feb-2011 instead of 18-Feb-2011.While the initial example I gave is from 2005, the spreadsheet for 2005 is perfect... Read more

Answer:excel vba macro increment date

Perhaps you could use the INDEX function instead of INDIRECT. INDEX is non-volatile so it shouldn't slow the workbooks down.In order to set this up, you'd need to create 52 Defined Names, such as Week1, Week2, etc.Each name would refer to ='[filename.xlsm]A Weekly Sheet Name'!$1:$65536e.g.: ='[filename.xlsm]18-Feb-2011'!$1:$65536(The 65536 is a throwback to Excel 2003 to include the entire sheet. You could use whatever number you want, as long as the range contains all of the rows you are using in your weekly sheets)See here for how to set up Defined Names to external references:http://office.microsoft.com/en-us/e...Then you could use:=INDEX(Week1, 35, 23) to return $W$35 from whichever sheet Week1 refers to.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 73.39%

Hello all,I have used Excel for years, and run macros, but never written one myself. I have a spreadsheet of archived items that I need to review on a weekly basis to ensure boxes get sent back in a timely manner.The relevant columns are:Box number (an 8 digit number)Date recalledRecalled by (this will be a name)Date sent back (date - if not sent back, this will be empty)Review date (this will have a date 9 working days after the date the box was recalled)My ideal scenario is that I open the s/sheet each week, run my macro which will:Check the Date sent back box, if it is populated - nothing happensIf it is empty, the macro then checks the Review date box and if the present date is beyond the review date - the macro forms and email to be sent to the name in the Recalled by box stating: Subject: Box number: (it gets this from the Box number column)Please note this box was recalled on DD/MM/YY and is still in the office.Please advise if this can now be sent back - if not please respond accordingly.This is a big ask, I realise this - and I don't necessarily want someone to do this for me - I ideally want to understand how I do this, so that I can do it going forward myself.Any help would be greatly appreciated!ThanksEmily

Answer:Need Macro to Send email

I'm not an expert on macros by any means, but the few times I've done basic ones it's been okay after a bit of trial & error. There are a couple of good websites that give mini tutorials on how to create basic macros, these may be enough for your needs. Put 'writing excel macros' into Google & look at the first couple of hits. "I've always been mad, I know I've been mad, like the most of us..."

3 more replies
Relevance 73.39%

Alright this one might be a bit of a challenge. I am releasing a complex spreadsheet with my product pricing on it. Is there a way to make the program have a "shelf life" of 6 months or so? I would like to set it up to make it inaccessible to anyone without the password after a certain time period. So basically I would like to create a macro that will disable the entire spreadsheet (without the password) after a specific date so I can release new versions (with the new pricing) without the old versions (old prices) getting thrown into the mix. Anyone have any ideas?? Thanks.
 

Answer:Excel Macro - Date Based Protection

Hello CWDENVER, this should be possible to achieve, you can have a date held in a cell in a hidden Protected sheet in the workbook. When the System date = the date in the Cell the Target Worksheet is hidden and can only be made un-hidden by entering a password.
To be effective the Menus would need to Removed from the Workbook as well.
The VBA Editor would need to be password protected as well.
 

2 more replies
Relevance 73.39%

Hi,I just want to know if its possible to do a macro wherein I can select the dates to be read in my report. For instance, I have a Table (below) where column A is the Date, column B is the name of Agents, Column C is the Section and the Column D is the Error Category. A window will pop-up where in I can select the date range the the macro will read.Usually I have a monthly report and I keep on sorting and filtering the Table if my boss is asking for a weekly report. The report usually are:How many errors does each Agents received on this particular dates?What section has most errors in this particular dates?What are the most common errors in this particular dates?What are the most common error of each agents in this particualr dates?What are the most common errors of each section in this particular dates?Date Name Section Error Category21-Nov Peter Delta Name21-Nov Jack Alpha Age21-Nov Mike Bravo Address21-Nov Cris Alpha Name21-Nov Sam Charlie Name21-Nov Noah Charlie Name21-Nov Jack Charlie Name25-Nov Mike Charlie Comment25-Nov Cris Delta Comment25-Nov Peter Alpha Comment25-Nov Jack Bravo Comment25-Nov Mike Alpha Name25-Nov Cris Delta Address29-Nov Jack Alpha Address29-Nov Mike Bravo Age29-Nov Cris Alpha A... Read more

Answer:Date range Count using macro in Excel

re: "I just want to know if its possible to do a macro wherein I can select the dates to be read in my report."Yes, it's possible.Posting Tip: Before posting Data or VBA Code, read this How-To.

5 more replies
Relevance 72.57%

Greetings -

Given:

Target Complete Money
A B C
1 1/1/09 1/7/09 50.00
2 1/5/09 1/12/09 100.00
3 1/7/09 1/14/09 50.00
4 1/17/09 1/17/09 25.00
5 2/2/09 1/26/09 25.00
6 2/5/09 150.00
7 2/6/09 150.00
8 2/5/09 75.00

Currently i have the following formula to calulate how much money that I might make.

{=SUM((MONTH(A2:A100)=1)*C2:C100)}
This works fine as I have no blank cells in column A

If I try to apply this formula to column B I get an incorrect number as I have blank cells in there with no values.

Is there a way to continue to use this formula but have it check for blank cells and if it finds any, don't add those values??
Thanks!
 

Answer:Excel 2007: Date/Sum Macro/Blank Cell

Welcome to the board.

How about the attached? Contains 1 "master" dynamic named range & 2 others based on the "master". Use E2 to define the month you're after.
 

3 more replies
Relevance 72.57%

Hi,

Want a macro to sort data from (Column B,C,D,E) with whatever date mentioned in Cell A2.
Column B,C,D,E have different dates what I want is to sort those columns as per the date mentioned in cell A2.
Suppose if in cell A2 the date is 11/26/2009 then it should sort the data from the Column B,C,D,E with that particular date in a new sheet in that workbook.
And would like to assign that particular macro to a button

Please help
 

Answer:Solved: Sort today date with Macro in excel

16 more replies
Relevance 72.57%

Good Morning,
I am attempting to create a print preview, and then a printing button for one of my documents. I figured out how to do a basic print preview and then print when approved. If possible, I would like to create 5 copies (currently just pressing the button 5 times) and on each consecutive copy, have the date increase by one. I have the start date for printing appearing on a sheet called "WT" in cell C1 and would like it to appear in cell H1 for the worksheets ending in "SI" and then in cell AJ4 in worksheets ending in "TS". Not sure if this is possible, but any help would be greatly appreciated. I posted my current VPN coding for previewing and then printing these lists, but if you could help with one, I'm pretty sure I could figure out the other. Just please let me know if there are any changes in the "printout" phrases, please.
Thanks for your help in advance

Sub PrintPreviewCrewLists()
Worksheets(Array("A SI", "A TS", "B SI", "B TS")).PrintOut Preview:=true
For i = 1 To 5
Range("H1") = Range("H1") + 1
ActiveWindow.Worksheets(Array("A SI","B SI")).PrintPreview Copies:=1
Next i
For i = 1 To 5
Range("AJ4") = Range("AJ4") + 1
ActiveWindow.Worksheets(Array("A TS", "B TS")).PrintPreview Copies:=1
Next i
End Sub

Printing macro has not been updated as I have not figured out how to preview it successfully.
... Read more

More replies
Relevance 71.75%

I am using the following code to email word document (its actually a form) as attachment and to save it to my "P:/" drive. It seems working but the code will need to modify for the following reasons:
Once I am done filling out the form and hit the command button to run the macro? the document (form) actually sent to email and also saved to my "P:/" drive successfully but its over saved the master file. I need the form to be blank at all time.
Also, I want to have the files to be stamp with date and time (as a file name for the form) that going to be email and save to "p:/" drive.
I will appreciate any help. Thanks!!

The code I am using is:

Private Sub CommandButton1_Click()

Dim OL As Object

Dim EmailItem As Object

Dim Doc As Document

Application.ScreenUpdating = False

Set OL = CreateObject("Outlook.Application")

Set EmailItem = OL.CreateItem(olMailItem)

Set Doc = ActiveDocument

Doc.SaveAs

With EmailItem

.Subject = "Insert Subject Here"

.Body = "Insert message here" & vbCrLf & _

"Line 2" & vbCrLf & _

"Line 3"

.To = "[email protected]"

.Importance = olImportanceNormal 'Or olImprotanceHigh Or olImprotanceLow

.Attachments.Add Doc.FullName

.Send

End With

Application.ScreenUpdating = True

Set Doc = Nothing

Set OL = Nothing

Set EmailItem = Nothing

Flag = True

sPath = "P:\"

ActiveDocument.SaveAs FileName:=sPath & ActiveDo... Read more

More replies
Relevance 71.75%

Hi,New to VB and would appreciate some help with the following.I am trying to create a sheet where by i can input my capacity/demand on any new day. However, i want to be able to store the historic data and be able to bring it up again by inputting a date for a specific days data that i wish to view.Lets say that A1 is the cell where a date can be inputted.B1 is where i input todays capacityC1 is where i input todays demandD1 is where i input expected WIPWhen i open up the document tomorrow, i would love these fields to be blank ready to be populated. However, i would like to be able to view yesterdays data by inputting yesterdays date in A1. If the date is not a valid date i.e no data was recorded for that day, a message box could pop up saying 'not a valid date'.Can anyone help?

Answer:Excel: Macro that will display data based on a inputted date

I believe that these 2 sets of code will do what you asked for. However, there is one big piece missing. There is nothing here that will add the current date's new data to the historical data.Since there are so many variables involved with inputting the data, I didn't want to waste time writing code that won't do what you want.For example, when do you want the data copied to the historical data - as soon as the last piece of data is entered into D1? Just before the workbook is closed? Just before the workbook is saved? Do you want to click a button to save today's data? etc.Let's say you enter today's data and then decide to search for another day's data. Would you want to be able to pull today's data back again during that same session?Would you want to be able to change today's data assuming it's still "today"?Until it's clear how you want to deal with the new (current day's) data, it's tough to offer any suggestions.As far as your other 2 requirements, try this in a backup copy of your workbook. This code writes data and deletes data, so you don't want to test this your only copy of your workbook since it cannot be undone.Note: This code makes 3 assumptions:1 - The data entry cells you mentioned in your post are correct, i.e. A1:D1.2 - The data entry cells are on Sheet 1.3 - The historical data is stored in Sheet 2 Columns A:D.You will have to modify the code if it doesn't fit your workbook layout.Right click on the sheet tab for Sheet 1.Paste this code into the pane that... Read more

5 more replies
Relevance 71.75%

I use this VBA code in a Excel Macro to send a email. Actually i send a range of cell pasted in the mail but i can´t send the file (it´s was created in the same macro) attached.
Can you help me?

I send the code. How can i do for send the Prueba.doc file attached.

Sub Envia_CVP_LOTUS()

oldStatusBar = Application.DisplayStatusBar

Dim NSession As Object
Dim NDatabase As Object
Dim NUIWorkSpace As Object
Dim NDoc As Object
Dim NUIdoc As Object
Dim WordApp As Object
Dim WordDoc As Object
Dim EmbedObj As Object

Application.DisplayStatusBar = True
Application.StatusBar = "Creando el correo..."

Set NSession = CreateObject("Notes.NotesSession")
Set NUIWorkSpace = CreateObject("Notes.NotesUIWorkspace")
Set NDatabase = NSession.GetDatabase("", "")

If Not NDatabase.IsOpen Then
NDatabase.OpenMail
End If
'Create a new document

Set NDoc = NDatabase.CreateDocument

With NDoc
.SendTo = "[email protected]"
.CopyTo = ""
.Subject = "Previsión Marginal de GN para el " & Date + 1

'Email body text, including marker text which will be replaced by the Excel cells

.body = "Envío la previsión de máquinas Marginales de GN y Combustible Alternativo para el día de mañana." & vbNewLine & vbNewLine & "Donde CVP USD = CVP / ( Fn x Cotización U$S)" & vbNewLine & _
"**PASTE EXCEL CELLS HERE**" & vbNewLine & vbNewLine & &qu... Read more

More replies
Relevance 71.34%

I have searched the net but cannot find anything specifically what I'm trying to accomplish.

I have a timesheet, of sorts, that I added buttons to move around and I would like to add a button for the user to click and it will send the Excel spreadsheet to me when they're done entering their data. I can get the email to open a new email message with the file attached but I'm stuck on getting my name in the To field, as well as a subject and body. Then I would like for it to send and display a message that the email was sent.

I am using Office 2003

Any help would be appreciated.
 

Answer:Solved: Macro to Send Email with Spreadsheet as attachment

7 more replies
Relevance 70.93%

I have the following macro below which works great for when any value is entered in Column C, it time/date stamps the adjacent cell in Column D. However, I need it to do the same thing a few columns over (ie, when any value is entered in Column H, it will time/date stamp the adjacent cell in Column J)

For the life of me, and cannot get it to repeat . Any ideas? I'm a bit new at this, but thanks in advance for the help. Feel free to spell it out - I won't be offended.

Thanks! Here's the current macro:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("C3:C9999"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub

 

Answer:Solved: Excel Macro - Repeat Time/Date Stamp for Different Column?

6 more replies
Relevance 70.93%

Hoping to get some help on this question please. I have reviewed the forum and found a similar post, but the sample data is more predictable than mine and the Macro posted doesn't work on my data. See post "Excel Macro to Move data in Rows to column" 28-Aug-2008, 05:47 AM".

On my data, I would like to be able to take the yellow row, and move the data up to the previous row starting in column "R". The rows I would like on the same line, all begin with a date. I don't know how to make a looping Macro that will identify the "date lines", and take the "second date line", and move it to the "first date line's" row.

Any help would be appreciated.
I have attached some sample data. (I hope that's okay?!)

Thank you!!!!
Christine

PS - The range on data varies.
 

Answer:Solved: Excel Macro to sort data by date, then move to new cell

Christine,

this macro below works well with the sample data.
Code:
Sub sorting()
Dim Rng As Range, c As Range, i As Long
Set Rng = Range("A:A").SpecialCells(xlCellTypeConstants, xlNumbers)
For Each c In Rng
i = (i + 1) Mod 2
If i = 0 Then
With c.Resize(, 15)
.Copy .Offset(-1, 17)
.ClearContents
End With
End If
Next
End Sub

How it works:
1. Takes all those cells in column A of the active sheet that contain numbers. (Dates are actually numbers, only formatted to look like dates.)
2. In a loop, it takes every second cell of the set of cells selected in Step #1.
3. Takes a 15 cells wide region starting with the cell selected in Step #2, and copies it to the region starting with the cell positioned one row up and 17 columns to the right.
4. Deletes the content of the original 15 cells wide region.

Caution:
1. If there are any numbers in column A besides dates, then the algorithm is wrong and the macro will fail.
2. If the dataset in the second date line is wider than 15 cells wide then the rest will remain in place. But the macro can be easily updated, just change the Resize line.
3. Don't run it twice on the same worksheet.
4. Always make a backup copy of your data before running the macro, because it is not Undo-able.

Jimmy
 

3 more replies
Relevance 70.93%

I have a spreadsheet that is used by a number of users and has a macro built into it to collect updates from several other sheets. I want to add to the macro so that once it has been updated and saved the macro then saves another version of the sheet in a seperate folder with the date and time it was saved as part of the file name.

I have tried

ChDir"H:\Resourcing Teams\Placements\Weekly activity\Archive"
ActiveWorkbook.SaveAs Filename:= _
"H:\ResourcingTeams\Placements\Weekly activity\Archive\" & Now.Day & Now.Month &Now.Year &" .xlsx", _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False

But get errors

Any suggestions greatly appreciated
 

Answer:Solved: Excel Macro to save a copy of the file in new location with the date

9 more replies
Relevance 70.93%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5 CPU M 430 @ 2.27GHz, Intel64 Family 6 Model 37 Stepping 2
Processor Count: 4
RAM: 3956 Mb
Graphics Card: ATI Mobility Radeon HD 5650, 1024 Mb
Hard Drives: C: Total - 447861 MB, Free - 189776 MB; Z: Total - 150428 MB, Free - 86495 MB;
Motherboard: Acer, Aspire 7740
Antivirus: avast! Internet Security, Updated and Enabled

Hello. in Windows live, in the inbox, the "Date" and "Sent" date is almost always the same, even if the mail was written hours or days before receipt of the message. Why does the inbox not show the date that the mail was sent from the senders machine ?? They are sometimes a few seconds differant, I presume this may be something to that happens if download takes a longer time.
Thank you
Niedernsill
 

More replies
Relevance 70.93%

Hello all,

Am hoping someone may be able to help me with a task I am trying to complete.

I have a work book that I need to edit on a daily basis, and I ideally want to be able to send an email to specific email address when a date is input.

I have attached a copy of the workbook for perusal.

To try and explain - rows 3 to 11 contain data that I would want to be emailed to the email address listed in column c (drop down menu). But what I want to achieve is that the email is sent as a meeting/apt for the user listed in C (from the drop down menu of email addresses). But I want that meeting/apt to be made for the date in the BOOKED TO field.

I appreciate that this may not be possible as an automated process, so if it is possible, to have a 'send mail' button configured at the end of each row to send an email to the recipient that would also help.

I have done a fair bit of searching and looking at various bits of code - but I will have to be honest and say I have no idea on how to implement the code into what I am trying to achieve.

If anyone is able to spend time looking into this for me I would be ever so grateful - appreciate all are busy!

Many thanks in advance.
 

More replies
Relevance 69.7%

Hello,

I was able to successfully apply Hans' module and have the spreadsheet send an email when it was opened if something was out of the calibration date.

My question is now if it is possible to have it send 2 weeks in advance, and then again in 1 week later. I know that because the cell will be occupied that it was initially sent, it will not read it again for another send. Is there a way to automatically clear a column so that it just sends an email every time its opened within that range?

Finally, where do I add the column for a CC email?
Code:
Option Explicit

Public Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim EBody As String
Dim ws As Worksheet
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Set ws = Sheets("Master Equipment LIST")
Sheets(1).Select
lRow = WorksheetFunction.Max(3, ws.Cells(Rows.Count, "K").End(xlUp).Row)
If ws.Cells(lRow, "K").Value = "" Then Exit Sub
For i = 2 To lRow
toDate = Replace(Cells(i, "K"), ".", "/")
Debug.Print WorksheetFunction.Days360(Date, ws.Cells(i, "K").Value)
If WorksheetFunction.Days360(Date, ws.Cells(i, "K").Value) <= 14 And Len(Trim(ws.Cells(i, "M").Value)) = 0 Then
' If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 30 Then
t... Read more

More replies
Relevance 69.7%

Hi all,

I am looking for help on VB script to send automated emails based on the date column in excel sheet..

Uploading the excel sheet as well. The email should trigger on dates in column F to corresponding email addressed in column E ..

The email body should say :
Hi,

Your employee "Column C" is approaching his probation period on "Col D". Kindly confirm if you want to confirm on the date of "Column D" or modify it.
 

Answer:Need help to send automated email based on the date field

Have a look at the attached I have written the code necessary however if you have any changes you would like made let me know.
 

1 more replies
Relevance 69.29%

Hi all,

I know there has been a lot on this subject (so apologies) but as my knowledge in this area is limited and as I can't find anything that matches my exact needs I am struggling.

Basically, as part of my job I manage records in the office but I sometimes forget when things needs renewing etc.

What I would like is a for an e-mail to be sent through and to my outlook when a date has been reached.

Please see the attached: CSCS.xlsx

If CSCS tests had to be done every year for example, Paul Smith would be due another on 01/01/2014. I would like to set up a code so that when it got 2 weeks before that time, I got an e-mail saying 'CSCS Test due' and 'Smith' (i.e.. cell C1 and Column A for reliant person, in this case A3).

Is this something that is do-able and easy to set up?

Thanks, charli
 

Answer:Solved: Excel Send E-mail (via Outlook) When Date Reached

10 more replies
Relevance 68.88%

I have an Excel model (office 2000) which has a range of cells that contain if/then statements. I'm trying to get Excel to automatically send an email if any of the cells within that specified range were to provide a value that was false. Is this possible? Thanks for any insight.
 

Answer:Email Macro in Excel??

16 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi All,

I have a spreadsheet and i am needing to create a macro that will opena new message in Outlook and populate the 'To' Field with one cell and then the 'CC' field with 2 email addresses, one from one field and the other from a different field. then the subject from another field and then the body from another. it then leaves the message window open so i can check it right and hit send.

I found the script the other day but can not find it anywhere including this site.

Any help on this will be great.

JPL

Any
 

Answer:Excel Email Macro

Hi JPL,

You could use this function, just pass the values to it
Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function

It's from one of the posts, I do not remember which one
 

1 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi

I am trying to write a macro in Excel 2003 to automatically send an email using Outlook to a list of individuals asking them to confirm their personal details using the attached template. Could someone show me where I am going wrong with the script please?

Many thanks
 

Answer:Excel Email Macro

16 more replies
Relevance 68.88%

Any way of controlling the time a email is sent via a excel spread sheet using vba?
 

Answer:Excel - macro email-

6 more replies
Relevance 68.06%

Windows 7 --------------------------------------------------------------------------------First thing...I know nothing about macros!! I do know a very little about formulasI have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" numorous times,then hit send again on all the emails, can we automate this some how, like a macro that engadges when I open my outlook every morning?Thank u

Answer:Need Macro to automate email from excel

I have written code in Outlook, which is essentially a template, you fill in the details, all sorts of stuff happens accordingly to what you have selected, and you press send and it will send the emails to whoever it is you want. Iv done this in Outlook, so my question is, why do you need this to be done in Excel? is Outlook acceptable?

3 more replies
Relevance 68.06%

I have a user who wants to create a macro which will automatically send an excel spreadsheet into outlook and email it.
Any suggestions welcome. Thanks.
 

More replies
Relevance 68.06%

Hello all;

I am new to this forum and also to Excel macros. I have a large Excel file detailing financial accounts with my small business.
Anyway, I would like to email any customer who has an overdue balance as per column V in my attached sample file (any customer with a greater than zero value in V). I would like to send an email; something like this:

Joe Wilson;
As of 2/28/11 (latest date in the row that is on/after the current date), your account is currently overdue and you owe $1500.00 (G3).
Thank you.
Treasurer
I found several other threads explaining how to send an automatic email from Excel, but I haven't found one for sending an individualized email to a list of recipients. If this question has been answered, please feel free to redirect me. Otherwise, I'd appreciate any suggestions. Please let me know if I can detail my needs any better.
Thanks!
 

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

PS: I just corrected something I came accross and have re attached the corrected sample
 

2 more replies
Relevance 68.06%

My sense is this is a pretty simple request, but I'm completely illiterate when it comes to VB.

I have an excel spreadsheet with a number of data points. I'm looking to export the entire sheet to a CSV file and send it via Outlook. Any suggestions?
 

More replies
Relevance 67.24%

Hello

I need to come up with a simple outlook macro (or script?) that fires off whenever a new email meeting certain criteria is received.

1. new email is received with "please refresh quotes" in the subject
2. outlook runs a macro that causes another macro to run (the second macro is located in a excel workbook which is already running in my office pc)
3. the excel (attached) is simply refreshing market prices and emails whenever the macro is triggered. because the quotes are obtained via a DLL feed I can only get it at work.

the purpose is simply to get live market quotes on my personal email from my work email whenever i need.
thanks in advance for your help.
 

Answer:Solved: Run excel macro when new email is received

9 more replies
Relevance 67.24%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.
 

More replies
Relevance 67.24%

Hi - I have a list of names for a particular company where I have the first name and last name of the customer plus the email naming convention their company uses. For example the company's email naming convention is: [email protected] Is there a way I can create an Excel Macro that will automatically create the email from the available information? For example if I create three columns where one has the first name, last name and the @companyurl.com?I hope someone can help with this as it will save a lot of time!!Thank You!

Answer:Need Excel macro to creat email address out of just a name

This can be done fairly easily, but I'm not going to offer any suggestions.Since it appears that you do not work for this company, I can only assume that this will be for some sort of mass, unsolicited mailing. If your project was sponsored by the company in question, they would supply you with a distribution list and you wouldn't have to build your own.For all I know, I'm on that list of names that you have and I don't need any more unsolicited email.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 67.24%

Hi all,

I got this Excel worksheet, where I need a server(or service) to send a e-mail out at due dates.
Using Excel 2010, and the worksheet got the dates at A4 and down... I was thinking of a vbs scribt that is run by a schedule every evening and checked the worksheet for dates.

Let say that there is a date at A13 that says 26-09-2012 it should send out a reminder 4 days before, so that it sends this out at 22-09-2012 reminding using e-mail, with something like:
"Reminder that Mr. John have last work day at: 26-09-2012"
This is for new employees entering/leaving the company, so the rest of the worksheet are:
B = Name, C = Initials, D = Department, C = Location and so on.

I have read many posts on this forum regarding this, but none of them fits my needs.
Is this possible? I imagine this running on one of our serveres for smaller tasks like this.

Regards
 

Answer:Email from Excel on date

Hey JohnG welcome to TSG.

Look at the zip file in Post #8 of this TSG thread. In the VB you can hard code a file name rather than doing the drag and drop thing (after you get it working for your criteria).

To run on a server with admin rights you can remove (comment out) msg boxes and change the MyItem.Display to MyItem.Send and it will work seamlessly.
 

1 more replies
Relevance 67.24%

Hi All,

I need help.
I have a preventative maintenance spreadsheet for 30 pumps. (rows 2-31)
Each pump has different servicing dates (some weekly, monthly etc).
Each week i would like excel to send a reminder (via outlook email) and auto filter the list based on which equipment needs servicing.
In columns H (row 1) onwards I have put in weekly dates (every friday) and then put a 'Y' in the relevant cell for each pump (if they require servicing that week) and left the cell blank if it doesn not.

Can this be done?
 

Answer:Email from Excel by Date

12 more replies
Relevance 66.42%

Hi
I need help writing a macro that takes an Excel file to email.

The Excel file is a data base, I wanted the Macro to take the email from a column of the Excel file, and send out the email to all the emails in the database, if possible also adding a column of the Excel file to address the specific person.

thank you.
 

Answer:need help writing a macro that takes Excel file to email

Can you post a sample file? Please remove any sensitive data.

Rollin
 

2 more replies
Relevance 66.42%

Hello,

My first post, sorry to be a leech right off!

I'm trying to automate some of my day to day emails. I'd like to get a macro set up that will send an email from Excel and paste the range I select in to the body of the email. Would be great if it would send to a list of addresses listed on the page as well.

Using the attached example, I'd like the macro to take whatever range I highlight on the table, copy it to the body of an email and send it to the group of emails listed on the right side.

I'm learning excel, this would help me a lot! I'll be editing this to fit a variety of other tasks. I hope it can be flexible. Thanks in advance.

Chris
 

Answer:Macro: Email Range/Selection to group from Excel

http://www.rondebruin.nl/mail/folder3/mail4.htm

I have done the looping attached.
 

2 more replies
Relevance 66.42%

Hy guys

2nd time i am posting stuff for help, and as i was helped before i will again look forward the response.

I have a file of excel, in which i am sending emails to different candidates of admission, with scan letter placed in the same folder by name.

I want to edit this code, which could select attachment based on Column A list adjacent to the email address

I am attaching the file also pasting the code

Sub Test1()
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
'Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim SigString As String
Dim Signature As String
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

On Error GoTo cleanup
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

Set OutMail = OutApp.CreateItem(0)

strbody = "We at Graduate School of Engineering Sciences and Information Technology are extremely pleased to know that you have selected Hamdard University as preferred choice for your graduate/post-graduate Studies. " & vbNewLine & vbNewLine & _
"Hamdard University is a pioneer Higher Education Institute (HEI) of Karachi producing Masters and PhDs in the fields of Engineering, Computer Sciences, Information Technology, Energy and Environment since 19... Read more

Answer:Attachment based on cell value in a excel email macro

anybody ???
 

2 more replies
Relevance 66.42%

Hi there - Using MS Access 2007.
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.

Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.

Can someone suggest a better way of handling this that is not time consuming?

Thanks In advance!
 

Answer:MS Access 2007 - Macro > Excel > Auto Email

Access can open Outlook and send an attachment to mutiple recipients either as a list or as individual emails.
So are the attachments all the same for the recipients?
 

1 more replies
Relevance 66.42%

Hi guys, new users here!

I have an existing work book containing 4 tabs all with multiple columns.
The information contained within this workbook is a maintenance schedule for repairs on air conditioning for a few thousand different sites.
The cells in question simply contain a "1" in the relevant month column as to when the maintanence is due.

I currently use very basic conditional formatting to change the colours of the cells if the maintenance is due this month, overdue last month, or a warning if a maintenance is a week away from being due.

(NOTE: I'll refer to the maintenances as PPM's)

It has become imperitive that I find a better way to track overdue PPM's, my director has asked if there is a way we can send an email notification (just to one person if needs be) if the date in the cell has become overdue / due that day.

I have very little experience with VBA but I have played around with Python and Java so programming isnt completely new to myself.

Anyone that can provide any help would be greatly appreciated!!

Regards,

Tom
 

Answer:Excel email notification by date

6 more replies
Relevance 66.01%

I'm using an Excel worksheet (2007) that has macros to populate a form that I want to email to various people. I used to do it with no problem in the 2003 version, but now I get a message that says, "Unable to Sign - If using Microsoft Publisher or InfoPath Please resend as an attachment." This error message is in a dialog box that has the label, "Send as message not supported from Microsoft Publisher or InfoPath" I wasn't aware that I was using either of those applications, just Excel and Outlook. I don't care if the message is digitally signed before sending or not, I just want to send the form out. Any ideas?
 

More replies
Relevance 66.01%

If someone with access to a excel 10 spreadsheet makes a change in it is it possible to have an email sent to my outlook email address?

Answer:I'm trying to send an email from Excel.

Yes, you can achieve this by using the 'BeforeSave' function. Open the VBA window, expand 'Microsoft Excel Objects' if it's not already, then double-click on 'ThisWorkbook.'Copy and paste the following code into the window: (Note: you will need to change the email addresses and the servername at the minimum!)Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim MailObject As Object
Dim Cconfig As Object
Dim SMTP_Config As Variant
Dim Email_Subject, Email_Send_From, Email_Send_To, Email_Body As String
Email_Subject = "User Has Saved Changes to Your WorkBook"
Email_Send_From = "[email protected]"
Email_Send_To = "[email protected]"
Email_Body = "Someone has made changes to your workbook and saved them."
Set MailObject = CreateObject("CDO.Message")
On Error GoTo debugs
Set Cconfig = CreateObject("CDO.Configuration")
Cconfig.Load -1
Set SMTP_Config = Cconfig.Fields
With SMTP_Config
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "PUTYOURSERVERNAMEHERE!"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With
With MailObject
Set .Configuration = Cconfig
End With
MailObject.Subject = Email_Subject
MailObject.From = Email_Send_From
MailObject.To = Email_Send_To
MailObject.TextBody = Email_Body
MailObject.send
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub
Law of Logic... Read more

6 more replies
Relevance 66.01%

I'm trying to send an excel worksheet via email. I currently use Office 2003 and I'm use Windows Live Mail for my email. I have the icon in the file menu on Excel but it is grayed out and I am unable to access it. Does anyone know how to fix this?

Answer:I'm trying to send an email from Excel.

hi mom2otto,i found this for you..it may be helpful to you...rondebruin[dot]nl/sendmail[dot]htm

2 more replies
Relevance 66.01%

Hello,

I have a list of email addresses that have either:
[email protected]
[email protected]
[email protected]
or no corelation to [email protected]

I'm looking for a macro that will take the emails with dots in them and put the first and last names into cells next to the email. The others I can do by hand. PLEASE HELP!
 

Answer:Solved: Excel Macro to convert email addresses to names

16 more replies
Relevance 66.01%

I found how to send an email from an Excel Macro (http://forums.techguy.org/business-applications/1056070-solved-excel-email-outlook-code.html)

Here is the code I'm using:
Code:

Sub Email_Test()
'
' Macro11 Macro
' Keyboard Shortcut: Ctrl+r
Dim eSubject As String
Dim Sendto As String
Dim CCto As String
Dim Body As String
Dim app As Object
Dim Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
'Populate variables

mSubject = "Excel EMail Test"
Sendto = "[EMAIL="[email protected]"][email protected][/EMAIL]"
CCto = ""
mMessage = "You have received Knowledge Document Feedback for your domain."

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Sub
Is there a way to format the message section with bullets? How about paragraph breaks?

Name: John Doe

Date: 6/15/2012
Doc #: KM123456
Etc:
Etc:
Comments:
I'm perfictly willing to look at how-to documentation if someone can point me in the right direction.

Thanks
firstshot
 

Answer:Solved: Formatting Excel Macro Email Message Section

Hi, I haven't really looked myself but instead of bullets I generally use a dash and a tab
Paragraph as such are not possible but you have the linefeed and carriage return

example to add to your macro code before calling the mail proc
Code:

Dim mytext as string
mytext = vbnullstring
mytext = "Dear Jon Doe" & vbclrf & vbcrlf
mytext=mytext & "-" & chr(9) & "Date :" & the date variable & vbcrlf
mytext=mytext & "-" & chr(9) & "Doc #:" & the dos variable & vbcrlf
mytext = mytext & "-" & chr(9) & "Etc :" "etcetera"
mytext = mytext & vbcrlf & vbcrlf
mytext = mytext & "Sincerely yours," & vbcrlf & vbcrlf
mytext = mytext & "Jane Doe" & vbcrlf

vbcrlf can also be replaced wij Chr(10) or Chr(13)

See it this helps.

Maybe html formattingis possible but this works just as fine.
 

3 more replies
Relevance 65.6%

Hey all
I am having a problem trying to send automated messages from the below excel file using the date column
all i need is the sheet to send an email alert a day before the dates mentioned in all the sheets in the workbook

Thanks in advance
 

Answer:Automatic Email using the date on the excel sheet

Hi,

See if this site helps.

http://www.rondebruin.nl/win/section1.htm
 

1 more replies
Relevance 65.6%

Hello,I sort of got stuck with a very tedious Excel tracker that tracks when people are due for their vaccinations.I know that there are ways to set up formulas in Excel 2007 but I am pretty ignorant in the whole process. I humbly request your help.Here is a gist of my Excel tracker:Column A=Name | Column B=Job Title | Column C=Due DateAnd then the rows fill in accordingly.So, let's say I had this:John Smith | Janitor | 09/15/2010Could I somehow synch those three rows up with my Outlook contacts list and send a formatted email to them? Could I also set it up to CC me?I would want something like, " Hello, if you are seeing this then you are due for your annual vaccination. Please complete your vaccination as soon as possible. Thank you."Thanks for your help.

Answer:Excel Due date tracker-- Auto email when due?

Hi,I can offer some help with formulas.If you have the following arrangement A B C D E F
1 Name Position Vacc. Due Status Rem. sent Vacc. Date
2 Smith J Janitor 15-Sep-10 Due 15-Sep-10
3 Smith K Clerk 10-Sep-10 Done 10-Sep-10 12-Sep-10
You can start by getting a warning when a vaccination is due.In Cell D2 enter this formula:=IF(C2-TODAY()<8,IF(F2="","Due","Done"),"")This tests to see if the due date is 1 week or less away from today's date, using "IF date difference is less than 8 (days)" : IF(C2-TODAY()<8For a longer warning increase the 8 in the formulaThe formula then uses a second IF to see if the vaccination date cell has been completed : IF(F2="","Due","Done"). This returns "Due" if there is nothing in the vaccination date cell, else it returns done.To avoid "Due" showing up when there is no date in cell C2 you can add an extra test for an empty cell:=IF(C2="","",IF(C2-TODAY()<8,IF(F2="","Due","Done"),""))Now to improve the visibility of vaccinations due, you can use 'Conditional formtting' which changes the appearance of a cell based on values in that (or other) cells.Select cell D2.From the Ribbon select Home - Styles - Conditional Formatting, From the drop down select 'Manage Rules' and select 'New Rule'In the dialog box select the last item in the list 'Use a formula to determine which cells to format'Enter this formula in the box =IF(D2="Due",TRUE,FALSE)Note that TRUE and FALSE do not have double quotes - they are Excel's logical values true and fa... Read more

2 more replies
Relevance 65.6%

Hi everyone

I hope all are fine and reading my message in the best of their health.. I am stuck with a job to do on various dates where i have to email those candidates whome progress reports are due, which due dates are mentioned in the sheet.

Can some body please help me to come up with a excel automatic mail solution that an email should be generated via outlook without opening the file or even if needed opening the file. The email should contain

Dear Student

Your progress report / proposal defense is due on (due date),

regards,
this email should be generated and sent before one month and one copy on the date on which it is due.. the cc list also needed to be grabbed from somewhere, where cc of this email should go.

I shall be very thankful if somebody can look the attached file and help
 

Answer:Solved: Excel Automatic Email on due date

16 more replies
Relevance 65.6%

Hello,

This is my first post here. I have been searching all over the internet trying to find an answer to my excel problem. I am pretty new to excel and my goal is to have excel automatically send an email out to me when the due date of a training is approaching. I have already set it up using conditional formatting to fill the due date box yellow if a due date is less than 30 days away but I would like excel to email me a reminder so I don't have to remember to check the spreadsheet every month.

I have it set up with a training summary sheet that shows the # of trainings due within 30 days so what I really need is a macro to send if the cell is greater than 0.

I have done a lot of searching but am new to excel programming and can not figure out how to adapt the codes I have seen to satisfy my needs. Or where to enter them

I attached the workbook I am trying to do this for. Im looking to apply the macro to the 'Training Summary' sheet.

Any help would be greatly appreciated.

Thanks,
Brandon
 

Answer:Automatic Email From Excel When Due Date Is Approaching

Hi,

In order to do this we need more information.
Will the workbook be opened every day?
If so you can set the code to check the date and E-Mail you.
If the workbook will not be opened every day then you can use the "Task" manager
and have it open the workbook to check the date.
You can also set a code than when the workbook is opened it will check the
Date and if you need to review it will activate the sheet and then Highlight the Date.
 

3 more replies
Relevance 65.6%

I can trigger e-mail from a fixed date, which doesn't work if excel is not open on e.g. 60 days ahead of todays date. How can I trigger an e-mail ONCE, if a workbook is opened at any time between today and 60 days?Many thanks, Mike

More replies
Relevance 65.6%

Hi everybody,

First time poster. I currently have 9 tabs open and hours of researching trying to figure this out. I can say I'm more educated now with excel than I was this morning. Very powerful software.

I seen current thread that were very close to what I need but was unsuccessful with achieving what I needed.

I'm trying to set an email reminder sent to my team when a task has not been completed (Column D) by the due date (Column C) and some indicator on column H when completed. It would be most ideal if the subject had the part number "123453 Rev 06 Doc Control Update" and body said Dear Andy(Task Owner) reminder, please update documentation related to your department. Thanks.

I currently have a macro for 'Task completed' be filled in a green color when complete. I'll copy and paste below what i currently have. I know this is probably a long shot but I am getting somewhat stressed and losing hope with this, please please please help. function is more critical for me then the looks, if i have to move some cells around I don't mind one bit.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim... Read more

Answer:Automated email in excel, driven by due date

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(1).Select
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
toDate = Replace(Cells(i, 3), ".", "/")
If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Cells(i, 4) 'gets the recipient from col G
eSubject = "Document Control Status update "
eBody = "Reminder," "Please update your project status."

On Error Resume Next
With OutMail
.To = toList
.CC = ""
.BCC = ""
.Subject = eSubject
.Body = eBody
.bodyformat = 1
'.Display ' ********* Creates draft emails. Comment this out when you are ready
.Send '********** UN-comment this when you are ready to go live
End With

On ... Read more

1 more replies
Relevance 65.6%

Hi Guys,Currently am working on a Excel VBA to alert me through Outlook email based on the following conditions,I've the deadline dates for each tasks listed in Column 'G'. Now i want the VBA to check this deadline date and if the deadline date is 7 days from today, then it should copy the particular Row data and email the data to my email address.This should be performed everyday automatically, without opening the excel sheet.Am very new to VBA. So,Your help is much appreciated.Cheers,PK

Answer:Excel VBA To Email Row Data Based on Date

re: "This should be performed everyday automatically, without opening the excel sheet."I don't think that Excel or VBA for Excel is not going to be able to do this with opening the file - or at least some file.You can't have a macro running inside a closed file, constantly monitoring itself. Something has to trigger the code and/or update the formula that checks the dates, such as the file being opened or perhaps another open file pulling data from the closed file, etc.I guess you could schedule a windows task to open the file once a day or something similar, but there is going to have to be some "action" that initiates the running of the code.

14 more replies
Relevance 65.6%

When I start in Word or Excel (office xp pro) and hit
file, send to, send as an attachment the word email
editor will pop up with the word document as an
attachment (as it should). I then put the address I want
to send it to and hit the send button. The send button
greys while the mouse button is pushed (as it should) but
the message stays there. It does not send. I can hit the
button 7 million times and the email and attachment just
sit there.

Does anyone have any idea what may cause this?

Side notes: It doesn't mater if outlook is open or closed same effect either way. I can send attachment directly from outlook.
OS Win XP Pro. Network 2000 Server with 2000 exchange.
Newest Service Packs on all software from server to local
machine including office.
 

More replies
Relevance 65.6%

Hi All,

Let me take the pleasure to introduce myself as Vasu, beginner in this forum.

I know that there are many on going threads related to my this new thread. But, actually I had gone through some of the posts (like Rollin, OBP, and Diego) as per my need and I did saw OBP used to share some links which already covers this my new thread, but since I am totally beginner to MS Excel, so I could not understand many of the things. So, with left chance I thought initiating the new thread, so that I can aware of step-by-step to "automatically send an email from excel on date basis". Hope you all fine with this.

So, here is what I need, I have a sheet (which contains columns Request No, Owner, Run Date, Due Date to Close Request). Usually sometimes we miss to close the requests as per the due dates.

So, could you please share detailed information on how can my excel automatically send an email whenever the "Run Date" crosses??

As per my understanding after reading the existing posts, I thought of giving you some sample data from my side. In my attached workbook, there are two sheets ("Request Tracker" and "Email"). "Request Tracker" sheet contains the base data on which "Email" sheet contains what I need in my email when excel send an email.

I would be more than happy to give you any additional information if required.

I use MS Outlook and MS Excel on Windows.

Thanks for your assistance and help to get my problem ... Read more

Answer:How to send an automatic email from excel?

15 more replies
Relevance 65.6%

In the attached xls file, the user would have this file open and would populate all the fields that are marked "User". When a date is entered into Column C, the Status (Column D) changes to "Resolved" and Send Email? (Column D) changes to "Yes".

Here is where I get confused looking at some example vba to send a selection from the worksheet to a specified email address in the same worksheet.

I would like to send the following to the email address in that row:

"Your issue {row A#} regarding UWI {row G#} has come off confidential."

When the email is sent, the Email Status (Column F) changes to Sent. Only rows with a null email status will be processed. This will prevent multuple emails from being sent.

Hope this makes sense.

Mike

PS - All data is just sample data.
 

Answer:Solved: How to send email from Excel

16 more replies
Relevance 65.6%

Hi all,

I have an excel file from which I want notifications to be sent to a particular email address. I have seen several threads which are related to mine however I could not manage to do it. I am new to this stuff and need your help to explain the coding.

I have 2 columns (in red in the attached file) and I want a notification to be sent via outlook if the expiry is due within 2 months, 1 month and on the day as a reminder.

Another query I have is that this excel sheet will be used by multiple users. Will the notifications be sent each time a user will use this sheet?

Your help is much appeciated.
 

More replies
Relevance 65.6%

I have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" then hit send again on the email, can we automate this some how, like a macro that engadges when I open my outlook every morning

Answer:send email from excel based on

This should be in the Office forum here: http://www.computing.net/forum/offi...

2 more replies
Relevance 65.6%

Hello,

First time post from me! So hi everyone.

Im a begginner at this so any help would be appreciated.

I have created a training matrix on Excel, and it obviously peoples training runs out regularly. Somehow i need to try and get an email sent to 4 different email addresses when somebodies training is a month before running out. Then, if its still not updated, another email to be sent out 2 weeks before the 'date expiry'.

I've tried messing about with Task schedular and have got an email to be sent out every Monday morning at 9am, to various email addresses. However, ideally i need something which would send an email alert as i explained. Ive tried with macros and visual basic codes, but its just a bit too much for me! haha

I understand there have been similar posts, and i have tried to adapt to them, but still doesnt seem to work out.

Any help whatsoever would be fantastic.

Look forward to your reply.

Thanks
OW
 

Answer:How to send an email from excel when a cell changes.

16 more replies
Relevance 65.6%

I am looking to write code that will send an out an email automatically if 2 conditions are met in excel. The first condition being, is this a repeat design "Y or N" and the second is the number of days shown in another column. The criteria is, if "Y & over 42 days then send email" or if "N and over 14 days then send email" otherwise do nothing.I have my repeat design in Col G & Number of days in Col K. I have been trying to adapt the code below that I found online earlier on. Unfortunately, it uses a limit instead of the IF function I would like. It is currently set to send out an email as soon as any number in Col K goes over a 200 day limit, that's the bit I would like to change.Private Sub Worksheet_Calculate() Dim FormulaRange As Range Dim NotSentMsg As String Dim MyMsg As String Dim SentMsg As String Dim MyLimit As Double NotSentMsg = "Not Sent" SentMsg = "Sent" 'Above the MyLimit value it will run the macro MyLimit = 200 'Set the range with Formulas that you want to check Set FormulaRange = Me.Range("K8:K100") On Error GoTo EndMacro: For Each FormulaCell In FormulaRange.Cells With FormulaCell If IsNumeric(.Value) = False Then MyMsg = "Not numeric" Else If .Value > MyLimit Then MyMsg = SentMsg If .Offset(0, 1).Value = NotSentMsg Then Call Mail_with_outlook2 End If Else ... Read more

Answer:How to send an email from excel if certain conditions are me

Thank you for reposting the code with the pre tags. That really helps.As far as your example data, your column letters don't appear to line up correctly, but based on your earlier posts, I'll assume that Column K contains the 443, 18, etc.Another posting tip:Since we can't see your workbook from where we're sitting, telling us that the VBA code is "coming up with an error" doesn't give us a lot to work with. VBA can present all sorts of errors, including syntax errors, compile errors, run time errors, application errors and even the dreaded Fatal Error. (Ouch!)It would help us help you if you told us what the error says and, if possible, which instruction caused the error.Allow me to offer you this before I address your question:If you are going to be using VBA, either writing your own code or just trying to figure out how code that you find on the web works, it helps to have some debugging techniques in your toolbox. I suggest that you practice the techniques found in the following tutorial. Not only can these techniques help you find errors in your own code, but they can be used to reverse engineer code that you find elsewhere. I am essentially self taught in VBA and much of what I have learned came from my application of these debugging techniques on working code, which helps me understand how and why the code does what it does.https://www.computing.net/howtos/sh...OK, as for your current problem, let's take a look at what you said:"I cut and replaced "My Limit = 200" in m... Read more

7 more replies
Relevance 65.6%

HI All,

Can any one help me on this.

I want to auto send email from file whwnever a cell value changed.

In attached excel file if the value of cell "C" get changed to yes then excel should automatically send email to the addreess mentioned the column D.

Help on this .

shishir kumar
 

Answer:Excel to auto send email

Hi there, welcome to the forum,
There are quite a lot of postings with similar questions.
Have you checked this? You can search for then and I'm sure that the solution is there for you.
Some minoor editting may be needed but it will work
 

1 more replies
Relevance 65.19%

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike
 

Answer:Excel Macro -> email created with field data as subject line

8 more replies
Relevance 65.19%

Hi all,

I need to know if is it possible that a macro in Excel sends an email containing the visible cells using Microsoft Outlook.
btw, I saw some code on the internet, that saves the visible cells in a new excel file and attach it in a new email using Microsoft Outlook, but I don't want to have attachments in the email.

thanks for any possible help.
 

More replies
Relevance 65.19%

Hi all

Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Code:
Sub SendThis_ActiveWorkbook()

Dim Recip()
With ActiveWorkbook

ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="[email protected]"][email protected][/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="[email protected]"]example[/EMAIL][EMAIL="[email protected]"][email protected][/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With

End Sub
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!
 

Answer:Solved: Excel email macro auto-populate subject line

Subject:="Vacancy Authorization " & Range("A1").Value & " " & Format(Date, "dd/mmm/yy")

Regards,
Rollin
 

2 more replies
Relevance 64.78%

I have a personnel tracker that tracks required documents that need to be renewed every year. There are 4 of these and each has a seperate column for each date. They are J,L,T and U.

I would like excel to scan each of these columns every time the document is opened for any of those dates that are 60-65 days from expiring, I use Now()-300 to check this.

But if the cell is blank I want it ignored, which right now it does not. If it finds 1 or even 80 that are in that range I want 1 email generated to a list of management personnel.

Currently it generates how ever many are blank or expiring. I use outlook.

My data starts on row 3 and goes down to 331, the required and maximum number of people allowed on the contract.

If I can get just one email with a generic message I would be happy. But if I could I would like the info that is actually doing the triggering to be copied and pasted in the email to include the info in A, C and D.

Here is my current code, I would change .display to .send once I have it working. please help.

Private Sub Workbook_Open()
Dim Cell As Range
Dim DateRng As Range
Dim Msg As String
Dim olApp As Object
Dim olEmail As Object
Dim RngEnd As Range
Dim Wks As Worksheet

Set Wks = Worksheets("Work Site Info")

Set DateRng = Wks.Range("J3")
Set RngEnd = Wks.Range("J331")
Set DateRng = IIf(RngEnd.Row < DateRng.Row, DateRng, Wks.Range(DateRng, RngEnd))

'Change this to what you want.
Msg = "This is message is the bo... Read more

Answer:Solved: Automatic email from excel based on date

16 more replies
Relevance 64.78%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-a...s-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email from Excel based on Date in Cell

16 more replies
Relevance 64.78%

This is prasanna from india. i need a help in my company i want to trigger mail automatically based on the date.. its kind of probation tracking mail... Example :- IF an employee has completed three months automatically mail should trigger to concern person.. is it possible in excelThanks in advance

Answer:Sending automatic Email based on the date in row in excel

Look here:http://www.rondebruin.nl/sendmail.htmYou should be able to find something you can work with.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 64.78%

Hello Everyone,

I am a beginner at using vba and I am trying to use excel to send an email automatically before 5 days of due date. I have a an excel sheet of bank loan repayment but every loan due at a different date.

If possible i would like to use an email template that excel would place the values specific payment details and their due date and then send the email to the email address on the specific cell.

I have attached my excel sheet format for your referance.
Thank you so much in advanced

Regards,
Nilesh Jagtap
 

Answer:Excel - Trigger Auto Email Depending on Due Date

Welcome to TSG niljag!

Working on one of these right now at this TSG thread . Practice1.xls in Post #4 is lastest. See if you can adapt to similar. I didn't look at your attachment.

There are many of these(excel emailers) in TSG. Search "excel email" and find one you like. When you get to an issue let us know and we'll try and help.
 

1 more replies
Relevance 64.78%

Hello Everyone,

I am a beginner at using vba and I am trying to use excel to send an email automatically depending on a past due date. I have a an excel sheet that has over 200 companies and we require an annual report but everyone report is due at a different date. I am using conditional formating to change the color of the text depending on how long it has been since we have received the last report. If the last report is 366 days since it has been submitted then I would like an automatic email to be sent.
For conditional formatting i used this "=(TODAY()-365)"

For email i am using;

Sub Send_Email_Using_VBA()
Dim Email_Subject, Email_Send_From, Email_Send_To, _
Email_Cc, Email_Bcc, Email_Body As String
Dim Mail_Object, Mail_Single As Variant
Email_Subject = "Trying to send email using VBA"
Email_Send_From = "[email protected]"
Email_Send_To = "[email protected]"
Email_Cc = "[email protected]"
Email_Bcc = ""
Email_Body = "Your annual report is Due"
On Error GoTo debugs
Set Mail_Object = CreateObject("Outlook.Application")
Set Mail_Single = Mail_Object.CreateItem(0)
With Mail_Single
.Subject = Email_Subject
.To = Email_Send_To
.cc = Email_Cc
.BCC = Email_Bcc
.Body = Email_Body
.send
End With
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub

If possible i would like to use an email template that excel would place the values specific to the co... Read more

Answer:Excel - Trigger Auto Email Depending on Date

Hi welcome to the forum.

You already have the send_email_using_vba, weel you will need something that checks all the cells where the due date is x days old and call this macro

Sub CheckSomething()

<< here you will have to put the code that checks each rows in the
<< date column and if the condition is met then call the send email macro

End Sub

Since I have no idea of your sheet's layout you will have to do your own homework

I suggest you also tell us what version of Excel you're using,
 

1 more replies
Relevance 64.78%

Hi.

I have attach the sheet

Need your help on auto sending of email from the excel via Lotus note.
I have my data in excel which has Email ID to whom I need to send an Email. with subject in one column and Body of the message in one column.

I need to send email every day as per today date, by refering the cell B1 which has (Date) Today ().
Then accordingly I need to go to the Col "E" which has the Email Date as heading, I need to sort todays date from the Email Date, and send email accordingly to the respectively persons in that row( I have mentioned only email Id of the persons in Col "C" & "D").

Now what I want is,it should sort the date for the Email Date by refering the cell B1 (means according Today() date in B1).
I have created 2 Buttons one in the Cell C1 & the other in Cell D1 What I want is when I click on Button "First Name Contact" it should send auto email to that respective person email id in that column/row along with the subject and body of message which is in column F & G.
And when I click the other button "Both Contact Name from column E & F" it should send auto email to both persons email id in column/row C & D along with the subject and body of message which is in column F & G.
I have Lotus notes installed on my system and I'm using excel 2003 version.
I would appreciate if you could help me on this as I'm not familier to coding.
 

Answer:Send email from excel via Lotus notes

16 more replies
Relevance 64.78%

Hi there,

I am looking for a way that Excel can automatically generate an email alert for my colleagues that is triggered by data in my Excel file. I haven't generated the Excel file yet as the advice you give me may have an impact on how I go about it. Basically, the database will be a record of marketing activity we have undertaken as a company and will include dates for us to complete follow up actions. If possible, I would like for an email to be generated when todays date matches up with the follow up date. This should go to the staff member whose details are against that entry.

I hope this makes sense!

I have seen a previous thread which appeared to be on the right tracks, but it has been closed so I can't see the outcome!

Many thanks,

Carly.
 

Answer:How to make Excel send email alerts

16 more replies
Relevance 64.78%

This is my first time posting on here so I hope this is the right place.

I have attached a spreadsheet I will need to populate and we would like to send staff members an email reminder before they need to do their task. Maybe a day or the morning of the day is fine, as long as they get the reminder. I was just wondering how I would go about doing that?

As the Excel file would need to be opened in order to work , I was also wondering how I would be able to set it to open on the start up of everyones machine. Even if it can only start up the programme then it will be obvious to people what they need to open.

Could the email or subject include as much info as it can. Like name, company, job title and contact number. and for it to be sent to the Asignee.

We will then change the next contact date once completed.

Any help would be appreciated!

Thanks
 

More replies
Relevance 64.78%

Dear All,

I would like to seek your advice to find out a solution for the below query:
Daily I would be having plenty of documents on hold which I need to intimate to respective people for the reasons on the same : so…..
Every time I need to send an e-mail for these, so I wanted to create macros for sending an e-mail for the excel on their respective documents like:
Dear Sir/Madam,
You’re so and so document and code no is on hold due to the “reason”, please provide us the clarification to process further
Data is like below

A B C D
Doument # Code Reason fo hold E-mail id
12 1 Due to Mismatch [email protected]

13 2 Wrong doc [email protected]

15 3 amount mismatch [email protected]

17 4 Wrong Details attached [email protected]

19 5 Wrong person details [email protected]

21 68 Due to Mismatch [email protected]

23 455 ddsss5 [email protected]
Please provide us Macro code for the same ,
Thanks in advance
Your’s friends
 

Answer:send email from excel to multiple recipients

6 more replies
Relevance 64.78%

I am attaching this excel sheet which has codes on sending email automatically on due date once the file is opened and then closes it as well. However there seems to be a problem as it doesn't send emails automatically and comes up with a error. It would be grateful if someone could correct the codes in the file.
Thank You
 

Answer:Send Email using Excel and Outlook Automatically

7 more replies
Relevance 64.78%

Send Email from Excel when cell is populated.

I have no knowledge of VB, but know that this is possible based on other threads and limited articles that I have read.

Can anyone provide me with the script to send an email out of excel when data (date) is entered into column Q or R or T of the attached sample spreadsheet? A prompt to send the email including text that the field has changed as well as text from column G & H would be great.

Whatever help you can provide would be greatly appreciated.

Thanks.
 

Answer:Send Email from Excel when cell is populated

Hi, welcome to the forum.

Check out the post created by mightybekah. I put some VBA code in the sample file which when modified to your needs will work for you.
Try it and if you still have any issues just post.
 

1 more replies
Relevance 64.78%

0down votefavoriteCould you please help me to automatically send an email from Excel only when the formula value in column M (=IF(VAL.EMPTY(K15);"";MAX(K15-Today();0))>200. Unfortunately the Sheet1 code triggers the email code if the condition is met (>200) in formula value cell in column M if the date in column K is altered manually or by writing manually Not Sent in column N. Instead my goal would be: 1) to understand why this code in sheet1 doesn't send the email automatically as supposed to do (the only thing it does is to put Sent in column N without sending the email. This make me think that this code works) 2) to find the way to send the email automatically without changing anything manually in the cells in my sheet1. H I J K L M N Date Score Description Next Due Status Days till expiration 15 28/09/2017 13 Medium Risk 25/07/2018 Valid 284 Sent 16 11/10/2017 13 Medium Risk 10/08/2018 Valid 300 Sent 'Sheet1 (FormulaValueChange)Private Sub Worksheet_Calculate()Dim FormulaRange As RangeDim NotSentMsg As StringDim MyMsg As StringDim SentMsg As StringDim MyLimit As DoubleNotSentMsg = "Not Sent"SentMsg = "Sent"'Above the MyLimit value it will run the macroMyLimit = 200'Set the range with the Formula that you want to checkSet FormulaRange =... Read more

More replies
Relevance 64.78%

Hello folks. Just a general opinion required at the moment, please. I might need to create something to monitor due delivery dates against actual delivery dates. It's pretty easy to use an Excel wbook and conditional formatting to highlight late deliveries, but what I'd like is an automated email sent to a couple of relevant people as soon as an item becomes late. That also might not sound too hard, but what I think might be a problem, is this. Is there a way for this to happen even if the program is not currently open and running? And would this sort of thing be easier to achive in Access or Excel? (Assuming it is possible at all)Thanks

Answer:Excel or Access to auto send email

If the program is not running, then that's it. The only thing I can suggest is that you run the program automatically using Schduled Tasks.

5 more replies
Relevance 64.37%

Hi, I am hoping someone can help me with a macro for Excel 2007. I wish to "reverse" the following macro, so that it sends the contents of an entire column (in this case the second column) back to the previous column as Cell Comments, without interfering with the contents of the cells.

Sub CopyCommentText()
Dim CmtText As String
Dim CmtCount As Integer, i As Integer
Dim CommCell As String

CmtCount = ActiveSheet.Comments.Count
For i = 1 To CmtCount
CommCell = ActiveSheet.Comments(i).Parent.Address
Range(CommCell).Offset(0, 1) = ActiveSheet.Comments(i).Text
Next i
End Sub ​
 

More replies
Relevance 64.37%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

1 more replies
Relevance 63.96%

Basically, I have created a very simple Excel spreadsheet as an example, but what I would like to do is the following:

I have several employees (100 +/-) that require training in various fields. Each training certification is good for 1-yr. I am trying to figure a way for Excel to automatically send an email to my Microsoft Outlook whenever that training date is set to expire. I would like to have it email me 30-days before it expires. The problem is that I don't record and notate it by the date the training expires, but rather by the date they were trained. An example would be that I trained someone on 5-3-13 and they will be expiring 30-days from now. I have it entered on the spreadsheet as 5-3-13. How can I make Excel automatically generate an email warning me of the upcoming expiration date? I am admittedly not very proficient in computer language, but I am more than willing to learn.
 

Answer:Trying to send automatic email notification from Excel 2010

6 more replies
Relevance 63.96%

Hello to everyone that reads this post.

I have seen several threads on this request, and have not been able to see exactly what I have been looking for.

Below is what I am looking for:
we will receive emails from one of our departments indicating that, what we call a disclosure, occurs. It is our responsibility to do the research on the cause, and email back our findings. Each of these requests have a due date. We have started to create a log to help keep track of these disclosures so that we can respond by the due date. I would like to make this easier by having an email sent that has not been completed. I have attached a spreadsheet as a sample, everything is fictitious. As you will see on the sheet, there are several data elements that are recorded. The fields that I want to have looked at to determine the criteria for sending the email is due date and email sent date. which is columns O & P. I would like to have an email sent automatically each day whether we open the sheet or not, that has a due date but not a date in the email sent column P.

An added piece but not necessary is to have sent in the email is that there are x amount of days left til the due date and/or it has been x amount of days past the due date.

I would appreciate any assistance, and if you need further clarification please don't hesitate to ask
 

More replies
Relevance 63.96%

In Excel 2010 I use the Review tab to hit the Mail button which opens my Outlook-attaches the spreadsheet and sends the email with the Spreadsheet successfully. However there is no message text in the body. No matter what I type (e.g. Mary, how are you today?) it just sends a blank email with a good attachment. Any ideas?

More replies
Relevance 63.96%

Hi everyone,

I'm new here, and kind need your assistant on this spreadsheet. Been searching all over from this forum but non are helpful.

As attached, I created an excel workbook and would like to have excel AUTOMATICALLY send to me and other colleagues as well a reminder to Outlook email which the password going to expire soon WITHOUT opening the workbook. Is it possible?

Can someone help me on this ? as I don't have much exp on VB. Thanks!
 

Answer:How Excel AUTOMATICALLY send alert to email when is duedate

May be this thread is what you looking for http://forums.techguy.org/business-applications/574148-e-mail-cell-data-excel.html
 

1 more replies
Relevance 63.96%

Hi All,

I am new to VBA and although there are many links in the forum regarding the topics of using Excel to send Email reminders to Outlook, my requirement requires an additional option which i do not know how to program to make it work. I hope I can be assisted.

I am currently using Outlook & Excel 2010, Windows 7.

Using the attached test example, I have created a spreadsheet which is used daily. It requires a reminder email to be automatically sent out ONLY if the following is triggered.

Row H (Send Reminder) must show YES, then it will only send on the date shown on Row G (Due Date). However, if Row H shows NO, it will not send even though Row G has Due Dates.

The body of the reminder message would say:

Subject: Reminder

The project assigned to you under reference number, "cell D3" in the name of "from cell E3" for the confirmation date of "from cell N3" is now G3 - C3 days old.

If this has been completed, please ignore.
 

More replies
Relevance 63.96%

Okay - here goes... I know I have seen a few questions similar to mine but no final answers.

I am trying to send a mass email to my distributors - approx 100 of them. I have their names, log in ID's and email addresses in an excel spreadsheet.

What I am trying to do is have the email for letter pull the info from the spreadsheet, put it in the email, and send it out but personalized to each person/company.

Fro example, I need it to pull XYZ co from the list, use their email address to send it to them, insert their contact name in the "Dear so & so" part of the letter, pull their ID for the log in from excel and place into the email, and send it out personalized with each companies info.

PS - If you give me programming info like some of the other posts showed - I need to know where do I put it/enter it etc? I'm not all that knowledgeable on this stuff but need to figure out how to make it happen.

Thanks in advance!
irishki
 

Answer:How to use Excel Sheet to send personalized mass email

http://spreadsheetpage.com/index.php/tip/sending_personalized_email_from_excel/
 

3 more replies
Relevance 63.96%

I have a list of associates (14) that require taking company regulated courses throughout the year. I first would like the cell to change colors based on the date, i.e.: 1 week before, date it is supposed to complete and 3 days late. I also need to send an email (Lotus Notes) from my excel spread sheet, to the associate on the day it is supposed to have been completed. I aatached the file, thank you for your help.
 

More replies