Computer Support Forum

Send email notification from Excel/Access Database to Outlook

Question: Send email notification from Excel/Access Database to Outlook


I need to send an email notification(To Outlook Inbox) to specific users that, the excel/Access database has been updated and saved by an user with his name.

This notification should be sent everyday at a specific time.

Can anybody help me out in achieving this using macros or by any means.?

Thanks in advance!!!


Relevance 100%
Preferred Solution: Send email notification from Excel/Access Database to Outlook

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 (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Send email notification from Excel/Access Database to Outlook

Have you looked at the "sendObject" method?

DoCmd.SendObject , , , "YourEMAIL", , , "TEST"

Leave the Object name /format blank and you can send without attachement, you can do with a macro or VBA....this is from Access only, if you need Excel let me know, it is different.

Not clear on how you want to trigger, because essentially the UPDATE, should be the trigger, but you mention same time everyday...that may not be relevant because what ever action does the update maybe able to trigger the send.

I also use this to get around Outlook security...

3 more replies
Relevance 93.89%

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 91.84%

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 84.05%

Please can someone help me.I manage a band and we have a database of 3,000 contacts. The headings are name,location,email, website. I wanted to put all this into my contacts sheet so that rather than getting a mailing list program I'll just use outlook and distribution lists. I was going to set up different address books for each location. i.e USA.

A box saying you have not named the ranges keeps coming up. Honestly i dont have a clue and could really do with a step by step, baring in mind i know nothing.

Problem is that it wont import from Excel into Outlook. Im getting desperate now their album is out in February and i have not used the direct mailing yet.

I cant find a step by step idiots guide to doing this anywhere.

Can someone help there is a free album in it if you can lol

Please help.

More replies
Relevance 82.82%



Please do NOT shout at us by using capitals.You may wish to ask the sender to zip the file before sending. That might reduce its 'threat' level.

5 more replies
Relevance 82.82%



Please don't post multiple messages - your original is click here

2 more replies
Relevance 82%

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 82%

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 81.18%


I am trying to figure out how to get MS Excel to send a few cells of data to an email address. We are a fire department whose dispatch is using an excel spreadsheet as the dispatch log. The goal is for the data to be entered into a few cells. Column H1 would ask to "send page". If 'Y' is put into the cell then an email automatically be with the data in this format:

c1 d1 e1 f1 g1
type;location;street address;details;report #
The email pushes an alert to responders smart phones through an ap.


Answer:Need to send some cell data from Excel to Outlook Email

7 more replies
Relevance 81.18%

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 81.18%

I created an excel workbook and would like to have excel automatically send me a reminder to my Outlook email when certain due dates are coming up.

Is this possible? I tried playing around with Macros but I'm not good at it. Any assistance is greatly appreciated.


Answer:How to make Excel send email alerts to Outlook

7 more replies
Relevance 81.18%

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 80.36%

Hi I would like to get VBA/macro codes to send an automated email to the email IDS mentioned in the file when the invoice due date is less than 2 days of current date. please help me

Answer:Excel 2016 to send Outlook email reminders on various dates

Here's a similar thread on the forum. If you can follow the code, then you can adapt it to suit your needs.

1 more replies
Relevance 80.36%

I'm in HR and I have a spreadsheet that incorporates staff information commencing, with each month in a new sheet. Unfortunately, department managers are forgetting to do staff reviews at 3mth, 5mth or the 6mth probation. I've entered formula to calculate these dates from the staff commencement date.
Now I need to find out if I can have some sort of Macro or VBA coding to email me a reminder to contact the managers a week prior to the the review/probation dates.

Please help! I have no idea with coding/programming etc.

Answer:Excel 2016 to send Outlook email reminders on various dates

Try the attached, one thing to note that you had the probation dates in the wrong place

6mth, 3mth and 5mth

so I changed it to 3\5\6

when you open the workbook the macro will run and generate an email IF any dates is below or equal to 7 and above or equal to zero. Meaning that there is a week until the review is required. This code will fail if the review date is in the past, this can be changed to tell you that a review date has been exceeded.

1 more replies
Relevance 79.95%


I am wondering how to send an email to a list of people in an Access database. The email should have a message in the body, as well as a Word attachment.

I know how to do this using a mail merge in Word where I can send the email using the Word doc as the email body message or attach this Word doc to the email, and I can select the recipients from an Access db. I want to be able to do both - have a message in the body of the email and attach a Word doc. I don't see an option to do this when doing a mail merge in Word using an access db.

Is there a way I can do this?


More replies
Relevance 78.31%


Im quite new to this excel programming thing and could really do with some help.

I need to send an automated email to 3 recipients (always the same 3 email addresses) when a number (formatted from a countdown of days to go) is 10 or less. Also i need a different automated email to be sent when a date is manually entered into a different cell.

I have managed to get the current date and time on my spreadsheet and used the format to work out the days to go to the deadline.

I have looked over all different types of forums but unfortunately because i'm still very green when it comes to excel i get lost and confused when trying to do this.

Is there anyone out there who can treat me as an alien and help me through this step by step.???

Answer:Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

10 more replies
Relevance 77.08%


I have a problem in my office that two systems are taking long time to send Excel attachments in MS Outlook 2003.
Even a 35 kb of excel attachment takes 2 minutes to send email.

The system I have WIN XP operating system
Symentec Antivirus client 10.1.5

I reinstalled the symentec and outlook 2003 but the problem remains the same
Please help

Answer:Symentec email scanner taking long time to send Excel attachments in MS Outlook 2003

You could turn off your email scanner.

Why you don't need your anti-virus to scan your email:
Email scanners can be bypassed:

1 more replies
Relevance 77.08%


I have a problem in my office that two systems are taking long time to send Excel attachments in MS Outlook 2003.
Even a 35 kb of excel takes 2 minutes to send email.

The system I have WIn XP operating system
Symentec Antivirus client 10.1.5

I reinstalled the symentec and outlook 2003 but the problem remains the same
Please help

More replies
Relevance 72.98%


I'm looking for a free tool to to send an email notification, when the partition is 90% full, running on WIN2008 server.

Answer:send an email notification if partition is full

From Vista/2008 onwards Microsoft added the ability to attach actions to events, You can setup a e-mail alert to be sent whenever the event id 2013 (disk drive near capacity) is triggered.
Open the Task Scheduler MMC, start the Create a Basic Task Wizard, give it a name and select on the event trigger. Set the Log to "System" Source to "Srv" and Event ID to "2013".
Then assuming you have a usable SMTP server just set the action to send you an e-mail.
The information you get is pretty basic, there are a lot of good monitoring tools freely available that handle this as well (SpiceWorks is one I recall).

Source: windows server 2008 - E-Mail notification when hard disk full? - Server Fault

Google is your friend

1 more replies
Relevance 70.11%

Is it possible to send an automatic email as a reminder on chosen dates from a field of a table with a message from another field from the table? If so how?Example: automatically email birthday dates as a reminder from an access database to outlook.

Answer:Access database to send emails on chosen dates

You can ..You will need to write a select query to extract the fields you want in the reminder from a table where the date (e.g. birthday) is today: Datefield =Now()Then use a macro to do a send object command a send the output of the select query via e-mail. Hope this helps.

4 more replies
Relevance 69.7%

Is there a way to have an Access database insert a distribution list of e-mails in the "To" field of Outlook?

I have a database where I am able to do this with a single user, but at times I would like to send it to more than one person.

Answer:Access Database - Send E-mail To Group/Distribution List

16 more replies
Relevance 69.7%

I am working for a company that has four people (four different computers) entering data into four different Excel 2010 files on a shared drive. I would like to create a master file on my own computer for the purpose of generating reports. How do I create one Access database that includes all of the information from the four different excel files? Also, can this Access file be continuously updated as the four Excel files are updated each day? Thank you!!!

Answer:Access 2010 Help Merging 4 Excel Files into One Access Database

9 more replies
Relevance 68.88%

I am restating the expired thread at

I have used the exact same code at the thread above but am not having any luck receiving emails. I have the code in each worksheet and the macro in the workbook. When I make a change to the workbook and save nothing happens. Any suggestions as I would love to get this function working.

Thanks in advance for the help.

Answer:Excel email notification when changed

8 more replies
Relevance 68.88%

I am trying to find out if it is possible to send a notification to other users if one user edits and saves a particular document. The notification could be by email or windows messaging or whatever.

Does anyone know if this is even possible?

Answer:Email Notification from excel when changes are made

16 more replies
Relevance 68.88%

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



Answer:Excel email notification by date

6 more replies
Relevance 68.88%

Hello,I got a macro online for sending emails given a condition. It works great if you have 1-2 entries that require email sending based on the condition set. But when it sends up to 10 mails daily to the same person it becomes kind of annoying.I will post the macro I use below, but first I want to say what I would like to do and don't know exactly how (I am a beginner at VBA language):--> I want to modify the macro so that for multiple entries as per the condition, it sends only 1 email with all the entries specified in body.The columns are:A - name of the person to send email toB+C - email and CC emailD - condition, if yes send email, if no don'tE - company nameF - current no.G - sector to be auditedH/I - date to begin / end auditJ/K - days left until beginning / end of the auditL - audit done: if yes, column D becomes no and greenAnd here is the macro I use:Sub audit()
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Application.DisplayAlerts = False
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, "D").Value) = "yes" Then
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = cell.Value
.CC = Cells(cell.Row, "C").Value
.BCC =... Read more

More replies
Relevance 68.06%

I am utilizing Microsoft excel 2007 to create an employee database for mandatory training compliances, I have over 275 employees that have to be notified for upcoming and reoccurring training compliances that are required for each employee. How do I write the VB code for EXCEL to notify each employee of upcoming training modules that have to be completed? I would like to notify each employee via E-mail regarding these training modules. I also would like to know how to (blacken, or darken, or eliminate)cells or modules that only pertain to certain individuals. In other words, if the individual that I am observing in Excel does not have to meet certain requirements regarding training modules that are specific to their field of study how do I eliminate the cell by (shadowing, or darkening), the cell that is under the module that is listed in the column. There are 22 columns and 275 employees. Thank You in an extreme abundance if you can help me with these issues that I am having with Microsoft Excel 2007. I NEED HELP!!

More replies
Relevance 68.06%

I am at a company where items get checked in and out. Nothing has an exact due date but people report when they expect to have their item returned. I would like to notify these people by email:
1. When their item is within seven days of the expected due date
2. When it is past their expected due date

I have Microsoft Office for email so I know it is possible to send an email everytime the document is opened, but I'm lacking a bit in the coding field.

I have attached an example file. Any help would be appreciated.

Answer:Solved: Automatic Email Notification from Excel

16 more replies
Relevance 67.65%

I have a database in access that I am trying to send to Excel. One of the fields within the database contains about a paragraph of text. When I send it to Excel, I am losing a portion of the text. Any idea how to change that? I have resized the excel cell and that did not work.

Answer:Access Database to Excel?

Microsoft Excel Specifications (Excel Help) gives the following limitations to field contents.

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar Click to expand...

Any greater than 32,767 and you will risk losing them in the conversion, but if its just a para or two you should be fine, but you will see it truncated, with the rest 'hidden', so to speak. Its an inbuilt limitation I'm afraid. You could try splitting the contents to an additional field, though that could be messy to look at and manipulate.


2 more replies
Relevance 67.24%

The following thread helped me to create an email notification upon saving an excel sheet:

The code I used is the following code:

Private Declare Function getUserName Lib "advapi32.dll" Alias "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long

Private Function getLoggedUserName() As String
Dim strBufferString As String
Dim lngResult As Long
strBufferString = String(255, Chr(0))
lngResult = getUserName(strBufferString, 255)
getLoggedUserName = Replace((Mid(strBufferString, 1, 255)), Chr(0), "")
End Function

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim olapp As Object
Dim olmail As Object
Dim LoggedUserName As String
Dim LoggedUserEmail1 As String
Dim LoggedUserEmail2 As String
LoggedUserName = getLoggedUserName
'*****CHANGE EMAIL ADDRESS HERE - part********
LoggedUserEmail1 = "greg.giordano" & ""
LoggedUserEmail2 = "demetra.barlas" & ""
LoggedUserEmail3 = "richard.sullivan" & ""

Set olapp = CreateObject("Outlook.Application")
Set olmail = olapp.CreateItem(0)
With olmail
.Subject = LoggedUserName & " has edited " & ThisWorkbook.Name & "Test 100"
.To = LoggedUserEmail1
.CC = LoggedUserEmail2 &... Read more

Answer:Solved: Excel email notification when changes saved, include changes

10 more replies
Relevance 67.24%

For the past 4 to 5 months I have been using the attached spreadsheet that I created to send out email notifications manual. I would open the spreadsheet daily and send the appropriate email, by clicking on the button, when the due date condition was red. This has been working great so far. Now I would like to be able to send these emails automatically instead of spending time looking through the spreadsheet to find the notices that are due and avoid missing ones also.
I realize that the worksheet must be open to accomplish this automatic send but this is not a problem since I use this spreadsheet almost daily.
I need help in making his spreadsheet as automatic email friendly as possible.

Using – Excel 2007 & Outlook

Thanks in advance.


More replies
Relevance 67.24%

ok, this code below is working but it does not show a pop up from outlook instead it sends the mail automatically.

I want to have a pop up as a new email message with the to list populated from the query when i click the button on the form. anyone can help?
Dim MyDb As DAO.Database
Dim rsEmail As DAO.Recordset
Dim strEmailAddress

Set MyDb = CurrentDb()
Set rsEmail = MyDb.OpenRecordset("Query Full Director", dbOpenSnapshot)

Do Until rsEmail.EOF
strEmailAddress = strEmailAddress & rsEmail("Email") & ";"

strEmailAddress = Left(strEmailAddress, Len(strEmailAddress) - 1)

DoCmd.SendObject , , acFormatRTF, strEmailAddress, _
, , strSubject, strEMailMsg, False, False

Set rst = Nothing

Answer:Solved: Email Button to send email in a form access 2010

7 more replies
Relevance 67.24%

I am using office 2003 and need to combine 20 plus spreadsheets with identical headings into an access database. Each spreadsheet contains about 1-2000 records and there could be about 500 spread sheets. Maybe some type of lookup table - any ideas welcomed.

Answer:Inserting Excel Into Access Database

File menu > Get External Data and then click Import.
I don't recall whether the merger happens during import or whether you will merge several new Access tables into one later.

Make sure you have simple column properties, really clear dates, text, numbers. You can tweak things in Access but only if the initial conversion didn't mess up.

2 more replies
Relevance 67.24%

In Excel, I want to type a SKU into A1. This SKU will query a access database and import specific data into cells B1 C1 and D1. A2 will have a different SKU, A3 yet another one, etc. The query must pull information based on what I type into the A* fields.

Answer:Query Access Database in Excel

6 more replies
Relevance 67.24%


I'm trying to write some code that will take some info from excel and update a table in Access, but unsure how to go about it. I know haw to do what I need with SQL, and how to execute it in VB code, but can't get it to work from Excel.

EG I need a control button in excel to select the data from one row in a workbook and add it to the table in the access database.

There are other things I will need it to do, but if I can get this bit sorted then I will work the rest out from there.

Thanks in advance!


Answer:Using VB in Excel to manipulate access database

is it worth just linking the exel spreadsheet in access as a table and then using an access query to update from the exel spreadsheet into the table you have in access

1 more replies
Relevance 67.24%

Hello All,
Our company had a photo booth with an F-35 fighter jet at a recent technology show. Individuals were allowed to have there pic taken in front of the aircraft with a pretty model. Now I have over 2500 pictures and over 2500 individuals that need their pic emailed to them. I have an Access database with a name, email address and a picture. Each name has a different image. How can I automatically send each person their picture through Outlook? I would like it to automatically populate a new email with the address and corresponding pic then have it be sent on its way while I am home sleeping. Can this be done? Is there a command that can run a VB script in Access to accomplish this? I thank you profusely in advance.


Answer:Solved: ACCESS: Email pic from Access database

16 more replies
Relevance 66.83%

Hi guys,
I would like to be able to move an email to a sub folder of my mailbox and get Outlook to send an email to the sender of the email I moved into it. Hope that makes sense.

I found this archived thread which has proved very helpful and I've managed to get it working for me.

I would like it to send more than just a one line email reply but I don't know how, maybe get it to use a text file for the body of the email?

Any help would be great


More replies
Relevance 66.42%

When using Outlook for email, Firefox for a browser, and Vista Home premium 32bit for an operating system, a small pop-up appears in the lower right-hand corner of the screen when an email is received.

I am not sure if it comes from Vista, Firefox, or Outlook/Office.

Is there a way to disable this function?

Thank you.

Answer:Email notification pop-up when using Outlook

The notifiction comes from Outlook. This is how you make changes in the notification system
Stop Notification

2 more replies
Relevance 66.42%

When I normally click on send receive I use to get a pop up box that told me I had contacted each separate email account but this has now disapperaed and I do not know how to get it back?Help?sanap


Can anyone solve this?sanap

3 more replies
Relevance 66.42%

I have just linked an Access Database to my web site. It displays email addresses in a table format. I want browsers to be able to click an email address and open an email client. Using HTML (I use Dreamweaver) it is easy - one just creates a "mail to:" link. However I cannot get the email address from the database to display correctly as an emai link on the HTML page. Does anyone know the answer to this problem?

Answer:Email link from Access Database

I can't answer you question, but I can offer a bit of advise...Look to using javascript for displaying email addresses, otherwise you'll find that spambots will trawl your site and collect the addresses.There's a link in Dave Winders column in this month's PC Pro on useing Javascript to obfuscate email links.

1 more replies
Relevance 66.42%

I need to import an Excel spreadsheet into Access such that the data is divided into several Access tables instead of just one. Is this possible? How?

Answer:Iimport some fields from Excel to Access Database

This can be done using VBA with the TransferSpreadsheet command.

DoCmd.TransferSpreadsheet [Transfer Type], [Spreadsheet Type], [Table Name], [File Name], [Has Field Names], [Range]

Transfer Type - Refers to how you want to move the data into the database. For what you described, you will want to use acImport.

Spreadsheet Type - Refers to the type of spreadsheet you are trying to import. If you are using Access & Excell 2007, then you would use acSpreadsheetTypeExcel12. The context menu will give you all of the available options when you are typing out the code.

Table Name - The name of the table you want to import the data to. If this table exists, then Access will append the data to the table, otherwise it will create it. Note: if you are appending to an existing table, you will want to make sure that the column headings in your spreadsheet are identical to their respective columns in the table.

File Name - The name and full path of the file you wish to import.

Has Field Names - Specifies whether the first row of the spreadsheet contains the names of the fields. If you select True, Microsoft Access uses the names in this row as field names in the Microsoft Access table when you import or link the spreadsheet data. If you select False, Microsoft Access treats the first row as a normal row of data and will name the columns in the table Field1, Field2,...

Range - The range of cells to import or link. Leave this argument blank to import or link the entire spre... Read more

3 more replies
Relevance 66.42%

I am a newbie when it comes to access. I am just wondering if anybody can help me. I have an access database with a user and admin logon. However, I would like to prevent this access database from being opened in Excel. Apparently this can be done by opening ALL Files in Excel and viola! All tables, Querries and reports can be opened.

Please I really need help ASAP.


More replies
Relevance 66.42%

Hi, I have a database of contacts, each contact has a reference number. In Excel I use the same reference number in column A, I would like to use this number in Excel to lookup from my database the full name of my contact from my Access database. Is this possible? thank you

Answer:Solved: Linking Access database to Excel

8 more replies
Relevance 66.42%

I have a customer whos looking to get a solution created for their office

they input alot of employee data into spreadsheets now, but are looking to save time and energy, as well as pull reports faster.

i know i can make the spreadsheets alot better and more efficient

but would access be better for them?

also, im unsure of what to charge

Answer:access vs excel price wise for a database

well i have no idea as i do not know what they are putting in the reports. Maybe maybe not.

Access is great for database stuff maybe inventory or something. Everyone can access it (locate it on a server) and you can lock people out from changing things too.

Both programs have there place it just depends on what they are doing.

8 more replies
Relevance 66.42%

Hi All,I am currently looking for a way to translate an inspection matrix (where inspections are planned by week using a dropdown menu (per week)) like this:Reference | Description | WK 1| WK2| WK3| etc..1 | pump | PIP | PIC |2 | valve | PIM | IEC |FAP | a table structure in another sheet where it would show up like:Reference|Description|Kind of inspection|WK1 | Pump |PIP |11 | Pump |PIC |22 |Valve |PIM |1etc.I understand that this makes use of VB in a LOOP function. I have some understanding about Visual Basics am not a complete newby but this is over my head.Could someone please help me with this?Thanks in Advance

Answer:Excel Matrix to Access Database Table Help?

Please repost your table after following these instructions. It will make it easier for us to read and understand the output you are looking for.Thanks!DerbyDad03Office Forum ModeratorTo line up your data in your post, please use the pre tags found above the Reply box.1 - Click the pre icon found above the Reply box.2 - Enter your data between the tags.3 - Click Preview Follow Up to see if you like the way it looks. 4 - If you need to fix the layout, fix it in the Message box below the Preview box.5 - Click the "Check To Show Confirmation Page Again" box.6 - Click either Confirm button to Preview the post again.Repeat steps 4 ? 6 as often as necessary until you like the way the post looks and then click Confirm.

8 more replies
Relevance 66.42%

hi guys,

i want to copy an excel table into a new access database is this possible

Answer:copying excel table to access database

done it

2 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 may be helpful to you...rondebruin[dot]nl/sendmail[dot]htm

2 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("") = 2
.Item("") = 25
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
If Err.Description <> "" Then MsgBox Err.Description
End Sub
Law of Logic... Read more

6 more replies
Relevance 66.01%

send receive receive is good--cannot send messages

More replies
Relevance 66.01%

I monitor multiple mailboxes under one account, and would like to set up an audio notification for one of the mailboxes, so when a new message comes in, Windows will play a sound.

I have created a rule in Outlook 2010 to do this, but I am not hearing the sound. I can hear other system sounds (ie logon/logoff sounds) and the audio from videos that play, but only the "new message" notification is not heard.

The mailbox is not my personal mailbox, I don't know if that is why, but it's a separate mailbox that I can view when logged into my own mailbox. There are other people that monitor the same mailbox, but they do not want sounds to play.

The rule is a "client" rule, so only runs when Outlook is open, which is fine. I just want an audio notification when a new email comes in, but only for this one particular mailbox.

Answer:Outlook email sound notification

I think the only way to get a sound to play from a shared mailbox is a clunky workaround. You can create a rule on the shared mailbox to forward emails to your personal mailbox, and then create a rule on your mailbox to automatically delete emails forwarded from the shared mailbox. Then you get the sound in your mailbox, but the email stays in the shared mailbox so you don't inadvertently respond from your own account.

2 more replies
Relevance 66.01%

Does anyone know of a screen notifier that will notify me of Outlook 2007 email without me having Outlook 2007 running? I am currently using IncrediMail but would prefer Outlook except for it's notification method.
Thanks. jhindle

More replies
Relevance 66.01%

HelloI have downloaded a .wav file to announce the arrival of new emails, and I have followed this tutorial: sound email notification does not work after having closed and then reopened the software. I do not have Exchange server; my Outlook works only in the sense that it is linked to my Hotmail/Outlook account.Does that make any difference?ThanksHigh1

More replies
Relevance 66.01%

I have searched near and far to enable sound notifications for incoming emails in my outllook email. All online "advice" has not been associated with my outlook. It seems my outlook settings are different from all the posts I have seen. I don't consider myself a comuter wiz but this topic is one that I should be able to understand.    Please help. Thank you

Answer:outlook email notification sounds


1 more replies
Relevance 66.01%

I have searched near and far to enable sound notifications for incoming emails in my outllook email. All online "advice" has not been associated with my outlook. It seems my outlook settings are different from all the posts I have seen. I don't consider myself a comuter wiz but this topic is one that I should be able to understand.    Please help. Thank you

Answer:outlook email notification sounds


1 more replies
Relevance 66.01%

Is there any way, in Outlook 2003, to edit the alert pop up/notifications
one gets when a new email arrives (that box that appears in the lower
right-hand corner) so that no text is displayed?

Seems w/ older versions, (Outlook 2000/2002), either you could, or no text would show up in the box, but no more (I'm not completely sure of this, but taking their word for it). In "tools>options>preferences/email options>advanced email options" there's the check box to either receive, or not receive that pop up box, but nothing to edit what's in that box.

We're on exchange 2003, and have a couple of users who want the option of having the pop up box serve as their mode of notification, but don't want any text displayed for various reasons.



Answer:Outlook 2003 email notification help

7 more replies
Relevance 66.01%

Having just moved over from Outlook xp I am trying to find out how I can make the email notification remain on the screen until acknowledged. It appears to fade away after about 10 seconds.

In Outlook xp it appeared on the screen and you had to click OK to get rid of it. In 2007 it appears as though you can do much more with the alert but seems to have a maximum timeout of 30 seconds.

The reason I ask is that in my work I do not sit in front of the computer, but need to keep checking whether emails have arrived. Now I can't just glance at the screen from across the office, but have to come and see whether there is a tiny email icon amongst all the others on the toolbar, a real pain as I need to do this frequently.

I appreciate that maybe most people don't need this, but why not leave as an option instead of taking it away it wasn't hurting anybody.

Is there any workround or 3rd party software which can do this?



More replies
Relevance 65.6%

I have a new laptop using Win7 Home Premium and Office 2010.
If I export a file from Access to Excel the exported data keeps the original Access formatting of Calibri 11 point but the blank cells in the Excel spreadsheet all reduce in column width to 5 and the font changes to MS Sans Serif 8 point.
Any ideas what I am doing wrong.

More replies
Relevance 65.6%

I work for a large global engineering construction firm. I have recently been tasked with setting up a database to store all of our contractor information. This information includes

name of company,
contact information for the company,
what is the general scope of work for the contractor (out of a specified list of 12, and each can have multiple),
what regions the contractor works in (out of a specified list, and each can have multiple),
the date we last received pre-qual information from them,
whether they are union/non-union/both,
what is their safety score,
what is the last job they bid and/or won for us if any,
and whether they are small, female, or minority owned contractor(which needs to be tracked for government work).
This information is currently housed in way too many unorganized excel files that need to be consolidated. From what I'm reading an Access database is the way to go because of one company having multiple scopes of work, multiple regions, and multiple projects, BUT there are two problems.

1. I am an Access beginner. That being said, I'm VERY computer savvy, just need some guidance and instructions.

2. The end user of this database information is NOT computer savvy and would need a very user friendly search form that they could pick from specified criteria and get a report that displays the contractors that match that criteria (for instance a contractor who specializes in scaffolding in the NW of the United States). This report would ... Read more

More replies
Relevance 65.6%

I try to print the "Relation", but it's in a big mass.

Many sheets there

Sheet/Awards: Awards Numbers; Applicant ID; Awards; Year; Reference Numbers
Sheet/Certificate: Certificate Numbers; Applicant ID; Certificate; Institute; Keyword; City; Country; Reference Numbers
Sheet/Education: Education Numbers; Applicant ID; Education Degree Type; Education Course Name; Education Institution Name; KeyWord; City; Country; Start Year; End Year; Education Graduated On; Education Comments; Reference Numbers
Sheet/Education & Experience: Number; Applicant ID; Employee Last Name; Employee First Name; Education Degree Type; Education Course Name; Education Institution Name; Education Graduated On; Education Comments; Language; Licenses Issue Date; Licenses Renewal Date; Licenses ID; Licenses Description; Licenses Comments; Training or Skills Completion Date; Training or Skills Group Name; Training or Skills Training Name; Training or Skills Proficiency; Training or Skills Renewal Date; Training or Skills Renewal Date Comments; Awards; Certificate; Work Experience; Reference; Reference Phone; Reference Business Phone; Reference Mobile or Cellular; Reference Email Address; Reference Company; Reference Position
Sheet/Employee Name: Applicant ID; First Name; Last Name; Marital Status Single or Married; Date of Birth yyyy m d; Age; Dependents; Gender Male or Female; disabled; disabilityPerCent; DetailsOfDisability; Address 1; Address 2; City or Township; State or Pr... Read more

More replies
Relevance 65.6%

Hi all,

I have access database for which the source file need to be from excel file from SharePoint. I am doing this manually download the excel file from SharePoint and upload into access database . Is there any way to create command button in access to download the file from SharePoint based on the URL provided by us.

I think for this we should use some VBA codes to execute this download.

Thanks in advance.

Answer:access database download excel file from sharepoint

You can use WebDAV that will make SP site look and use like a normal folder structure. Our Network admins implemented shortly after upgrading to SP10 and it has been a live saver.
I am able to acces folders like \\MySharePoint\DavWWWRoot\DDS\QA\Consumers and access files stored in sharepoint folder. I think configuration is available to allow the skipping of the wwwRoot part as well.

You might also try using the url path and replaceing the %20% with a space.

1 more replies
Relevance 65.6%

I've been asked to see if I can recover some data from a WDB file. Excel and Access don't seem to be able to cope with it and I sadly don't have a copy of MS Works to use.Any options?

Answer:MS Works Database file - conver to excel/access?

You will find several useful utilities here - click here

2 more replies
Relevance 65.6%
Answer:Ms Access Database & Excel - Import/export Data???

This one has really got me stumped....please help me..I need to Attach a button to a form in access (Called CarDetails, that displys individual data about each car) to transfer specific fields from the database (SUCarSales.mdb) to a spreadsheet (SUCarStickList.xls). The fields and references are as follows. "RegNo" - Cells A7:A21 in excel"StockNo" - Cells B7:B21"Mileage" - Cells C7:C21"Make" - Cells D7:D21"Price" - E7:E21I need to transfer the appropraite details from the database to the spread sheet. Also a button (in the spreadsheet) that transfers these details back to the database. If it would be easier the files are located here:click here(in the speadsheet, the markup is 9%)I realise that this is a bit specialised, but there has to be someone who has had experience woth this. Thanks agian Rja

10 more replies
Relevance 65.6%

I would like to know if I could send an outlook email via command line while also attaching a file via command line. I am trying to have a Windows 2000 or 2003 server inititiate an email when it sees a certain text file arrive on the server. The email should run automatically with the file attached. I've found this attached link on how to do the command line: But no mention of attaching a file. Anyone have any ideas? Thanks!

Answer:Outlook - Send Outlook email via command line w/attached file

9 more replies
Relevance 65.6%

I am new to excel VBA and am just about realizing the vast capabilities of coding.

I have created a spread sheet that contains delivery dates. I want to automate an email 7 days in advance 2 days in advance and the day of delivery. The less action required to initiate the macro the better. I tried tweaking some codes found online but to no avail. I'm surrendering to anybody out here that can help me accomplish this task.

I've attached an image of my sheet with column J being the delivery date to reference. The mailto list can be encoded in the VBA editor. Once the email is sent it shouldn't send again. In addition the may be a few blank rows before there is a row with more dates in them. I would need it to pass over the dashed rows and continue to the next row with a date.

Any and all help is greatly appreciated,
Thanks in advance.

More replies
Relevance 65.6%


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.


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

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

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:

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

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.


PS - All data is just sample data.

Answer:Solved: How to send email from Excel

16 more replies
Relevance 65.19%

Transition from Office 2007, Outlook to Outlook 2010, Cannot send email
The following has been performed:
1. Re-installed Outlook
2. Deleted profile and re-loaded
3. Look at pssible error from MS updates
Problem still exist, any takers?

Answer:Cannot send email after upgrading from Outlook 2007 to Outlook 2010

What error did it give you?
What email service are you trying to setup?
Do you have "My Outgoing Server (SMTP) requires authentication" checked on the Outgoing Server tab of the account setup menu?

4 more replies
Relevance 65.19%

I think i set (not sure) the appropriate Rules and alerts in Outlook 2010, and File-Options Mail..tick "show an envelope icon in the taskbar" (attached) to show the envelope (see attached) when emails arrive in my inbox, but the envelope doesn`t appear. It will appear when i send an email to myself.
Could someone take me through the settings for the envelope to appear on all emails. The sound happens when emails arrive. My computer-
Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: Intel(R) Core(TM) i3-4130 CPU @ 3.40GHz, Intel64 Family 6 Model 60 Stepping 3
Processor Count: 4
RAM: 3974 Mb
Graphics Card: Intel(R) HD Graphics 4400, 1024 Mb
Hard Drives: C: Total - 476137 MB, Free - 441209 MB; D: Total - 953866 MB, Free - 545897 MB;
Motherboard: MSI, H81M-P33 (MS-7817)
Antivirus: Windows Defender Enabled

More replies
Relevance 65.19%

we're using OUTLOOK EXPRESS is there a way to get a wave file or tone to play every x. minutes when mail is received.

in general setup, one can choose play sound when mail arrives, but no wave file, or frequency of sound can be specified it appears.



Answer:repeat notification receipt email OUTLOOK EXP

Hi jkoppel

Start>Settings>Control Panel>Sounds, scroll to New Mail Notification and select a wave file to associate with that command.

3 more replies
Relevance 65.19%


I have a problem with my Microsoft Outlook 2003. Sometimes my email notification works, sometimes it doesn't. It seems to not work for internal email.

I am using Windows Professional 2000.

I've checked the notification, turned it off and on again, but still not work for internal emails.

Thanks for ur assistance.


Answer:Microsoft Outlook email notification not work...

9 more replies
Relevance 65.19%

I have several imap mail accounts.  I just switched over to outlook 2003 from 2000.  In 2000, when there was a new message it would notify me automatically and put a little icon in the bottom corner.  Now, it does not notify me when there is a new message, but if I go to the inbox of that folder, the new message is there.  Is there a way to make outlook 2003 give me a notification when there is a new message even if I am not currently looking at that folder?

More replies
Relevance 65.19%


outlook does tell you when a new email shows up in a sub folder thru somthing like this: (5) for example.

i would like to see the new email notifications also in the sub folders! if i get mail i a sub forlder nothing shows if the folders are collapsed

is there a way to do so?

Answer:outlook 2010 sub folder new email notification

Hey paascal,

You got to go to Rules,
Click on Manage Rules and Alerts. Select the rule you have created for which you want to have the alert and then click on change rule.

Go to Edit rule settings, It will open a new window "Rule Wizard", click on next. On the second window scroll down to bottom and check the option "display and Desktop alert". Finish the setup and you are done.

Next time you get a mail from that specific user and it goes to your sub folder, you will get a desktop alert.

You can do this for any rule you have set.

3 more replies
Relevance 64.78%

Can receive email in outlook but cant send email has been like this for months now...I called my ISP and they didnt have an answer for it...Im running xp however I dont have the Xp disc to re install windows...its an older desktop computer I bought off of someone...Its a Dell PIII.

Im not to worried about not being able to send email on the XP puter because I have another desktop where the email works however its running on windows 2000.

Ive heard some people have problems with outlook using XP though.

Answer:Can Receive Email In Outlook But Cant Send Email.

you have this log thread open at present and it might be a good idea to await a respose on there before you start to make any changes; it is most possible that an infection has gotten TO your e mail client to the information yu have provided ON that log thread your computer is used by others for P2P file sharing? one OF the problems WITH file sharing programs is what the 'program ' comes baggaged with that can and will infect the computer

3 more replies
Relevance 64.78%

every time I try to send out an email I get this message [ there is a problem with sending messages from [email protected] check with your provider for info ] every thing was working good until I downloaded 8.1 after that I could not send out any emails yet I still receive emails from everyone I don't have a contact info that I can go to so I don't know what to do pleas help !!!!!!!!!!!!!!!!!!!!!!!!

Answer:i cant send email with my outlook . com email adress

If that's your email address then block out the first part with X's immediately otherwise you'll get spam email forever. An Edit option is available on here.There have been several issues with Windows 8.1. Check for Windows Updates now (the bulk arrive on the second Tuesday of each month or next day depending on your time zone).Check also with your computer manufacturer to see if there have been any new network drivers offered for Win 8.1. Best update them anyhow.Always pop back and let us know the outcome - thanksmessage edited by Derek

2 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%


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%

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.


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%

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!


More replies
Relevance 64.78%

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!

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

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

6 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,


Answer:How to make Excel send email alerts

16 more replies
Relevance 64.37%

Hi there,
I really hope that someone can help me. At work I received an email 3 days ago from 'Microsoft Outlook' asking if certain emails were important to me. This is in relation to their frankly appalling new thing called a 'clutter' folder. I have had no incoming email since. I can send, but not receive/view. I didn't click on anything in that email, until today when I finally read it properly. Yes, I did stupidly click on the link and log into my Outlook 365 account (which I have never used because I didn't know anything about it. The IT person at work told me that we do have this and reminded me of my password etc. Like, thanks for letting me know...).
I use a Mac, with Windows for Mac, but don't use Outlook.
Basically, I am so very busy at work and obviously need to get my emails and do my job! Does anyone know what might be the problem - I'm thinking is this a virus or what? The IT person at work said they will look at it on Monday but I need to sort it before then.
Also, this 'clutter folder' is being slated big time on ms forums, mostly because it is a pile of pants and unwanted by everyone.
Really would appreciate any help! Thanks.

Answer:No incoming email since notification about a 'clutter' folder in Outlook

It sounds as if you are using Outlook for Mac and are connected to an Office 365 mailbox.
What version of Outlook are you using?
If you are using Office 365, log into and check your inbox. Do you see any recent emails in the browser version of Office 365?
The "clutter" folder is where Office 365 routes mail that may not be junk, but is from senders you don't interact with often.

1 more replies
Relevance 64.37%

Hey i have outlook xp, and i would like windows to show me how many unread emails i have on the Login Screen. I know you can do it with Outlook Express, but is there any way to get it to work with Outlook XP? Thank you.

Answer:WinXP Login Screen Email notification w/Outlook XP

Download and install TweakUI (from M$ site).
Click on Logon/Unread Mail.

2 more replies
Relevance 64.37%

I am reposting this question. I was unable to get back to it in a timely manner to provide the data so here is my question again with supporting files.

I have an access application that produces a report that can be downloaded into excel using the option on the toolbar to 'Analyze in Excel'. I am having a problem with one of the columns which is getting the data converted to a negative number in some cases or some other type of char data. I assume it's because the data some of the data is all numeric so it assumes a numeric field but then it runs into char data and is making some kind of data conversion. I am trying to see if anyone knows how I can fix this. The data is automatically being loaded into access from a teradata relational table and it is defined as char(7) in the table and that's what it should be in excel. It is also defined as text data in the access database, which is correct. But when loading it into excel from access, it is not always correct.

I am attaching a sample of data. The file beginning with database is what my query returns. The file beginning with rpt is what the report returns and then is put into excel using 'Analyze it in Excel'. The data that gets converted incorrectly is in a column called 'MPN'. Look for a value of '5766472' in the column called 'CPN'. This is the CPN that has the incorrect value in the file beginning with rpt. I included the entire file because I wonder if it has ... Read more

Answer:Problem converting char data when using 'Analyze in Excel' from Access database

Please reply to your existing thread where you are already receiving help.

1 more replies