Computer Support Forum

How to make Excel send email alerts to Outlook

Question: How to make Excel send email alerts to Outlook

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.

respectfully,
Edward

Relevance 100%
Preferred Solution: How to make Excel send email alerts 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 http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: How to make Excel send email alerts to Outlook

7 more replies
Relevance 84.39%

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

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel(R) Core(TM) i7 CPU Q 740 @ 1.73GHz, x86 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 3261 Mb
Graphics Card: ConfigMgr Remote Control Driver, 512 Mb
Hard Drives: C: Total - 238064 MB, Free - 186932 MB;
Motherboard: Dell Inc.,
Antivirus: VirusScan Enterprise + AntiSpyware Enterprise, Updated: Yes, On-Demand Scanner: Enabled

I am becoming somewhat familiar with macros and I have done some extensive search but I still need help to automatically send alerts from an excel cell to outlook or desktop.
 

Answer:automatically send alerts from an excel cell to outlook or desktop

Hi welcome to the forum,
You don't tell much like which version of Excel you're using or what triggers actions, etc. etc.

http://www.rondebruin.nl/tips.htm

I suugest you check the link I have attached and I'm sure your answer is there.
 

1 more replies
Relevance 89.38%

hello all,

I'm kinda new at the more advanced features of Excel, so bear with me.

I'm using a pretty basic spread sheet with about 7 columns. One column contains various expiry dates, some dates are two years from now while others are in 6 months.

I was wondering if it is possible to create an alert that would generate an email when the date in the Expiry column reaches 30 days before the date.

Is there a somewhat simple solution? Or do I have to write some code?

Thanks in advance
 

Answer:Email Alerts from Excel to MS Outlook

You will need some VBA code to accomplish what you want. The code is not hard to write but you will need to select an event that will fire the code. In most situations like this the code would be triggered by the Workbook_Open event. This essentially means that the code would fired immediately when the spreadsheet is first opened. The only problem with this is that the code won't fire unless the workbook is physically opened. Is this a problem or do you need a script to automatically open the workbook and check the dates automatically?

Regards,
Rollin
 

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

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

Hello,

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.

Thanks!
 

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

Hi,

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

Regards,
Krishna
 

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...
http://www.contextmagic.com/express-clickyes/pro-version.htm
 

3 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 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 78.31%

Hi,

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%

Hi

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:

http://thundercloud.net/infoave/tutorials/email-scanning/index.htm
Email scanners can be bypassed:

http://www.virusbtn.com/news/2006/12_11a_virus.xml
 

1 more replies
Relevance 77.08%

Hi

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

looking for a program to runs on windows 2003/2008 that I can send snmp traps to and get alerts via email on some. I had a techrepublic article but misplaced it

Thanks
 

Answer:snmp program to send email alerts hopefully FREE?

www.r-u-on.com
 

2 more replies
Relevance 74.21%

I use Yahoo as my homepage. I have two Yahoo email addresses and one gmail address. I want to be able to send/receive all email at my Yahoo homepage and/or MyYahoo location. I also would like to set it up so I receive a sound and written alert immediately regardless of where I am working, on my computer, when I receive and email.
 

Answer:Solved: I want a central location to send/receive email, and get alerts.

9 more replies
Relevance 72.98%

I have a series of cells that are accumulating percentages of defects from samples of our product. Each defect type has its own threshold. What I want to do is setup an email alert through Excel for each time one of these thresholds are exceeded. Can anyone help with this?Thanks..Don

Answer:Email Alerts Using Excel

Hi,If column E contains the % rate then in column F put a formula that changes to "X" when the threshold is reached or exceeded.Add this macro as follows:Right-click the worksheet name tab and select 'View code'In the VB window that opens enter this code:Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ErrHnd

'stop further changes triggering this code
Application.EnableEvents = False

'only run this code if column E (E=5) has changed and next column (F) contains "X"
If Target.Column = 5 And Target.Offset(0, 1).Text = "X" Then
'create the e-mail object
Set objEmail = CreateObject("CDO.Message")
'set e-mail SMTP configuration
With objEmail
With .Configuration.Fields
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") _
= "SMTP.YYYYY.com"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout") _
= "30"
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") _
= "2"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") _
= "25"
.Item("http://schemas.microsoft.com/cdo/configuration/sendemailaddress") _
= "[email protected]"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") _
= "1"
.Item("http://schemas.microsoft.com/cdo/configuration/sendusername") _
= "[email protected] Read more

25 more replies
Relevance 72.98%

hello all,
i've searched through old threads to try to avoid a duplicate question and found the one below that is quite similar but i have a couple of different problems...

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-4.html

in a nutshell, i also need an email alert when a condition in a certain cell is met. i'm not very versed in VBA so bear with me; but from what i've read what i need, seems to be very doable by some of you guys that look to be very versed in VBA.

basically i was thinking of writing an IF stmt that would send the email if it is true and does nothing if it is not true.

like the link above i also have a data feed into my spreadsheet so the cells are constantly updating when a price changes. i need to be notified when a cell triggers the barrier event that i specify which will be different for each item

i have excel 2002/2003 and i use outlook. from the previous threads it seems that i need another outside application too.

i have another question regarding selecting a min/max value from a range of cells that update but only using values that have updated in the last 15 minutes. should i start a seperate thread for that question?

thx in advance for your help
 

Answer:email alerts via excel

9 more replies
Relevance 72.98%

hi I would like to set up an email alert in excel what I am doing is that when my plan comes up for renewal it will automatically send me an email alert to remingd meis this possible to do ?

Answer:how to set up email alerts in excel

re: when my plan comes up for renewalWhat plan?Please give us a little more detail as to what you are trying to do.

4 more replies
Relevance 72.98%

Hi I have a developed a spread sheet that shows the expiry date of our contractors insurance documents and need an email alert to be set up to request the new documentation. Table Example:Column A= Company name/Column B=type of insurance/Column C=expiry date.The Spreadsheet shall only be opened once a week so I would need that to act as a trigger and for the email to be sent 2 weeks before the actual expiry date. Many thanks for the help!message edited by gillkate

Answer:email alerts on Excel

Look here, should be everything you need:http://www.rondebruin.nl/win/sectio... MIKEhttp://www.skeptic.com/

6 more replies
Relevance 72.57%

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !
 

Answer:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?
 

1 more replies
Relevance 72.16%

Hi all,

First post so please be patient! I've got quite a simple worksheet that tracks when the MOT, Road Tax and Services are due on our fleet of vans. I have windows task scheduler emailing this report out each week to all of staff. The problem i'm having is that as the data rarely changes these emails are ignored. I found the below post asking for something similar, with more conditions regarding buying stock.

I have mine set up with some basic conditional formatting changing the cell to yellow if the cell >=today()-30 and red if the cell >=today()-7. Now this is set up for MOT, Road Tax and Service. So ideally what i would want/need is for an automated email to say "Registration - MOT due in 30days" or "Registration - MOT due in 7days" and a similar process for the road tax or service intervals.

Now from reading the post below i'm aware that changing the cell colour doesn't suffice as a trigger so i have some cells that now string together the above sentences in hope this simplifies things. So now if Cell F,G or H change i would like an email alert to tell me what the text is in those cells. However once we have MOT'd, Taxed or Serviced the vehicle and change cells C, D or E this will change the text in F,G or H to blank. If this happens i don't want an email sending as it would be blank.

I'm running Windows 7 and Excel 2007. I have attached my current work sheet.

Any help would be hugely appreciated.

Th... Read more

Answer:Automatic Email Alerts - Excel

7 more replies
Relevance 72.16%

I am using MS Excel 2007. I need to send email to the departments linked to the worksheet automatically on the date mentioned as a reminder how can I do it. For E.g
I have Activity on B4 and the date of reminder on C4. I need to send a reminder mail to the concern person who would be performing the activity.How can I do so.
Note: I am not using MS Outlook.
 

Answer:Automatic Email Alerts using Excel

Anurodh, welcome to the Forum.
Have a look at the Business Applications Forum and use the search function to look for Excel email, there are quite a few Threads on there on that topic.
 

3 more replies
Relevance 72.16%

I am trying to set up a SIMPLE Excel spreadsheet that will contain dates of reviews etc, however some of the reviews are scheduled for 2014 onwards and I would like to be able to set up the spreadsheet so that it triggers either an email reminding that the reviews need to be actioned, or an Outlook appt to trigger the same response.

I'm sure someone has probably asked a similar question, but I'm a bit of a novice and any help would be greatly appreciated.

Thanks
 

Answer:Creating email alerts in Excel

Have a look through these old posts and see if that does it for you atall - dont worry if not, just post back a reply if any good or no good

http://forums.techguy.org/business-applications/907393-automatic-email-alerts-using-excel.html
http://forums.techguy.org/business-applications/897801-solved-excel-alert.html
http://forums.techguy.org/business-applications/893239-email-excel.html
http://forums.techguy.org/business-applications/889493-e-mail-reminders-excel.html
http://forums.techguy.org/business-applications/909530-excel-email-alerts-beginner.html
 

1 more replies
Relevance 72.16%

hi

as the subject suggests I am a total beginner with macros and vba. I looked through this forum for days now and found some topics related to what I am looking for but - I have no clue how to modify it for my needs or anythink that like.

I need to set up a Training calendar, and some supervisors should receive reminders for Training which is scheduled, so that they can sign up there people.

In column B I put in the date the email needs to be send, according to the date now() which is in column B as well. in column C I have to indicate the people this email should go to. In colmun F I have to indicate the Trainer that is scheduled. Both parties should get the email at the same day but with different text. The text for the supervisors should include the Training name as subject and Column D as body. For the Trainer a 'you are scheduled as Trainer' in the body is enough.

As I said I have found several codes here and read that it works most of the time fine but I have not enough skills to write such a code. Could anyone help me out?

Attached you find a small example of what I mean so its easier to understand
 

Answer:Excel email alerts for beginner

If you would put in the links that you found (I am a bit too busy to look myself right now) someone will help, I am sure - and those can be rather complex to set up, so it would save someone a lot of time not having to write it all again.
Also, as you may have read, it helps a lot if you use Outlook for your emails. If you don't, there is another method that must be used, so do you use Outlook?
 

3 more replies
Relevance 71.34%

Hello guys, I need some help. I have an Excel spreadsheet that I use to watch financial information about companies that I buy stocks from when certain conditions are met. I use a program called XLQ which works along with Excel to extract the financial information from the internet and displays it on the spreadsheet. The numbers constantly change based on the stock market movement. I have two conditions that need to be met in order for me to buy a stock, when such conditions are met the cells change color, I have set it up that way to let me know when it is time to buy a stock.

So my question is... Is it possible to have Microsoft Excel automatically send me an email to my email inbox or cell phone when those two conditions are met and the cells change color. I would really appreciate any help with this. Let me know if you need more details about this problem I am having.

Thanks,

Eleazar Botello

 

Answer:Solved: Automatic Email Alerts using Excel

16 more replies
Relevance 70.52%

Hi All,
i have seen some fantastic success in the previous thread, "Automatic Email Alerts using Excel".... But i cant seem to work it out all by myself... its doing exactly what i want it to do as described in the thread, but ive had no luck in my own sheets.
Could someone please make a blank workbook, that sends an email with the contents of A1 if A1 is not empty for example...
This would be a huge help to myself, and many others as there seems to be many threads but no cut and dry solution for a humble newbie!
Best regards,
Westy
 

Answer:Solved: Automatic Email Alerts using Excel - Please Revisit!

sorry, should have mentioned, this is for excel 2003. outlook 2003, win xp, and have clickyes file installed thanks!!
 

3 more replies
Relevance 70.52%

I have read reviews on forum on same . But still could not find a soultion probably becoz i am not savy with excel . We are basically in to procurement of material . Currently the problem we are facing is that we are not able to track ,whethe the credit period of the supplier has finished and we have paid him or not ? From best of my excel knowledge i was able to establish a formula for same and was sucessful too .i was getting information on Gap b/w payment date and todays date .Moreover I got visual indicator for same , by conditional formatting . Now my boss wants me to make a provision in the excel sheet that once teh payment date has expired , he should keep on getting reminder for same as outlook message with suppliers name and order detail . I have tried alot for same on base of information given on the forum and infact downloaded and installed Click yes active. ver1.2 too Since i dont know VB so i am not able to solve thsi problem. Can any one help me on ths issue as it is important for my promotion .The file is ready for me and can be uploaded on request .
 

Answer:Automatic Email Alerts for conditions in excel cell

9 more replies
Relevance 68.88%

UPDATE #2 - Seems this problem is inherent in Outlook 2013 design - see http://www.howto-outlook.com/howto/newmailalert.htm
The "OutlookTools" App does not seem to work with Outlook 2013, but I did change the Registry Key as stated so that the Desktop Message stays up for 5 hours (long enough for me).
I would still like the Envelope Icon on the Task Bar for emails with Rules applied, if at all possible.
I also found this link useful and have implemented the changes. . . http://www.howto-outlook.com/howto/newmailalert.htm#allfoldersrule
UPDATE: This fix does not solve the problem . . . http://www.msoutlook.info/question/398
Right click Task Bar and under PROPERTIES / CUSTOMIZE I have checked the box which says "Always show all icons and notifications on the taskbar."
But even if I uncheck this box and tell Outlook to show Icons and Notifications, it fails to show up if I have a RULE set in Outlook.

-------------------------

In Outlook 2013, how do I keep the Play a Sound and Desktop Message and Email Alert icon in the Task Bar if I create a new RULE for incoming email?

With no RULE (Filter) in place, when I receive an email in Outlook 2013 I get all three of these. Fine.
These settings are made in FILE / OPTIONS / MAIL under "Message Arrival"

But if I make a RULE for incoming mail, e.g. to redirect it from the INBOX to another FOLDER, I still get a Desktop Message and Sound Alert, but the ENVELOPE ICON in the task bar is disabled.
I cannot s... Read more

More replies
Relevance 68.88%

I setup the rules for sending my email to my outside email address and cell phone and it never works. I tried forwarding the mail and redirecting it and still no go. I also tried the out of office assistant and still no go. It will work if I send it to my internal work address but no outside anything!! I have zero clue what the problem is with it. Any help?

Thanks
 

More replies
Relevance 68.88%

I've created an Excel file for the traders at work that list all the securites we hold and the dates the the hold on trading them come off. What I'd like to do is have an email sent out say 3 days before the hold comes off and the day the hold comes off.

I've read around a bit and it seems that there has to be some event in Excel that would trigger the emails. The problem here is that the Excel file will probably be closed most of the time. It'll just be opened every so often to add a new security or if someone wants to check something. There may be several days where it goes without being used.

Is there any other way I could create some sort of database that can automatically send out emails via Outlook without requiring any action on my end (maybe Access?).

The files will all be saved on a networked server and the emails will be send through an Exchange server. Most people are using Office 2003, a few people are using Office 2007. Everyone is on Windows XP.
 

Answer:Best way to automatically email alerts via Outlook?

8 more replies
Relevance 68.06%

I get false email alerts in the systray while using Outlook Express with my AOL email account.

Is there a check box or setting I missed
 

More replies
Relevance 68.06%

Hi,

I've just set up a shared journal to act as a log for our team. I've created a form to act as a template to use each time we add a new entry. Now I want to set it up so that everyone with access to the journal is automatically sent an email with a copy of the form once it is saved.

I've hit a brick wall trying to set this up (although I know it is possible). Any help greatly received! Thanks.
 

More replies
Relevance 68.06%

I installed MS OFFICE 2010, without Outlook, over 2007 with, thinking that Outlook would remain. Not so, and after a long phone conversation with MS Rep, who couldn't adjust settings to repair, offered to ring back after the weekend. Before she rang off I very tongue in cheek suggested she asked her manager if Outlook 2010 could be installed free, for my trouble!Great result as, when call back came manager had agreed, for my trouble to install, free. Great stuff.One up to Microsoft. Only slight niggle, and I can't complain really, I don't get the email alert message in corner of monitor.I don't think the problem is caused by Outlook.I've checked the necessary boxes in Settings and Options, but think cause may be because I use an IMAP email server.Can anyone confirm, and suggest a solution please?

Answer:Outlook in Office 2010 and email alerts

go to File, Outlook Options, Mail, Message Arrival, and ensure 'Display a desktop alert' is ticked.

3 more replies
Relevance 67.65%

I have office Outlook 2007. When I am receiving new email; I am not receiving any notifications to let me know that I have received any email, the only way I know is when I load up Office Outlook 2007 and see that I have a new email. I have my Office Outlook 2007 setup to use my Hotmail account. I was wondering if anyone can advise me on how / if I can enable alerts so that I know the instant I receive the email, any help would be much appreciated.

Answer:Office Outlook 2007 no email alerts for new mail

Tools > Options > E-mail Options > Advanced E-mail Options > 'When new items arrive in my inbox' and take your pick.

3 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 http://forums.techguy.org/business-applications/439567-outlook-reply-email-when-mail.html 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

Thanks
 

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%

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%

send receive receive is good--cannot send messages

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: http://support.microsoft.com/kb/192341/en-us 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%

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%

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%

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,

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%

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%

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,

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%

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

Can receive email in outlook but cant send email...my 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 http://www.bleepingcomputer.com/forums/t/129909/google-links-wont-work-properlybtcar-hijackervirus/according 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%

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%

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%

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%

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

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

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

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%

I have read this thread http://forums.techguy.org/business-applications/775756-how-use-excel-sheet-send.html. I am looking to do the same thing but withh Outlook. What must I do differently?

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

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

Thanks for the info - that looks like exactly what I need ! Your awesome!
One more question tho ( please don't laugh me out of here)
Where do I enter the VB programming to make it happen - in Outlook?
In the email itself? In Excel?

With the workbook open in Excel, press ALT+F1... Read more

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

I've read through numerous posts relating to this topic, but I'm having challenges. What I would like is to create a macro that will send an email to defined recipients IF a range of cells have values that meet a certain criteria (either the colour code or the value).

I'll make a button to run the macro manually.

Any help would be appreciated. Perhaps someone can look up a specific post that relates to my question...cause there are so many, I can't find one.

Thanks!

TBaker14

 

Answer:Solved: Excel send email with selected cells

16 more replies
Relevance 63.96%

Hi there,

I am using Office 365 Excel 2013, but we do not have access to the Cloud features. I think we are on
Windows 7.

What I am trying to do is create a spreadsheet for our managers to check off when a task has been completed. When they check the forms control box, the forms control box in B17 is assigned to say M17 and the word TRUE populates M17. The other form boxes are relative to the "results" cell. (Note if there is not check in the forms box then the "results" cell is either FALSE or is blank). Once all the boxes are checked, I want to change the cell color of A16 (title Accounts Payable) to green and generate an email notifying me saying Accounts Payable tasks are complete.

Here is a sample - I have also uploaded a copy of the excel document.

I realize that the email being sent out takes VBA programing and I think I have an example of this but haven't tried it yet. Is what I want to do possible? Is there a better way to go about doing this?

Thank you for the help.
 

Answer:Excel count true statements then send out an email

Are you still looking for a solution to this?

It seems possible. If you have any code (even if it's not working), please share it. Additionally, it sounds like the real bulk of the code is going to come from sending an email. The rest of it pretty much seems done or seems like one line of code.

How do you plan/want the email to be sent? What email program are you currently using on your computer? I would assume Outlook since you have Office, but not sure.

It also seems like other people are accessing this file. Is it stored on a network folder and everyone accesses it that way?
 

2 more replies
Relevance 63.96%

Hello ,

I have one excel file with one column with expires date.
I want script or something else to check every day this excel and if one cell is small than 10 then
run a batch file (i have it) with blat emailer (command line emailer) to send me email.
Is it possible ?
 

Answer:Script to check column of excel and send email.

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

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

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 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
Relevance 63.14%

Hello Friends,I am leading the finance team. I need to create an excel worksheet which tracks all my invoices raised on different clients alongwith the due dates. I want excel to send an auto email to client after 2 days of due date and second reminder after 7 days or so.I am from finance back ground and thus do not have any idea of running any codes or macros.Can any body help me with this on priority basis?Thanks and regards,Manish

Answer:Excel worksheet to send auto email reminder to clients

Try here:http://www.rondebruin.nl/sendmail.htmLook under the section: Add-ins and Worksheet TemplatesMIKEhttp://www.skeptic.com/

2 more replies
Relevance 63.14%

Hi,

I have multiple Excelsheets where in I use it for day today activites & tracking.
I have attached one of the simple one so that I can know the codes for sending mails & I can do it my self for the rest of the workbooks.

There is a sheet(dash board) where in all the details get updated.
When there are any changes to the value in column F, a mail should automatically sent to me giving the detials of the row. The file will be always live in the server.

I am very poor in coding & I need someone to help me in doing this.

Thanks in advance.
Rgds
Ganesh Hassan
 

Answer:Solved: Automatically send email from Excel based on the conditions

8 more replies
Relevance 63.14%

Hi Everyone!

I need your help in sending automated email and text message, when the due date of a PO is a week away from the current date. The script should preferably run automatically every time the PC is running without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. E), with subject "PO (Col. A) is due on Delivery date(Col. C)", and body "Vendor (Col. D), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found most of threads using Outlook only (my default email is Mozilla thunderbird),I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

Answer:Send email reminders thro Thunderbird from Excel sheet

16 more replies
Relevance 63.14%

System: Windows Vista and Microsoft Office 2007

When I Right-Click an Excel file, go to Send To, then select Mail Recipient, to send it to an email addressee, as I type the first characters of the address it automatically fills in a previously deleted email group. I have deleted an Outlook Email Group and renamed and restructured it, but the system keeps inserting the old deleted entry. Since the separate addressees are still in the system, it remembers and inserts them via an erased group. Its memory is too great! How can I purge this from memory and utilize the “New, Improved” email groups? Lastly let me say, “Thank you” in advance.
 

Answer:Email; Excel (Right Click) “Send To” – “Mail recipient” problem

Hi BudParker

Outlook automatically inserts, the e-mail group, in the To: field? It doesn't give it as an option in a drop down list?
If it is appearing in a drop down list, try hitting the Delete key, when the e-mail group is highlighted.
The autocomplete list is stored in an .nk2 file for Outlook 2007.

http://www.slipstick.com/config/backup2007.asp
 

2 more replies
Relevance 63.14%

Hi Friends,

I wonder if anyone can give me some instruction on how to send through Excel an email with an HTML file as message body.
I tried something out but does'nt recognize the html but placed it in the body message as text.

I know how to send email and even how to send it with a spreadsheet as message body, but an HTML message body would give me much more flexibility.

Thanks a lot,
Elad.
 

Answer:Send email (Excel VBA) with HTML file as message body

elad11 said:

Hi Friends,

I wonder if anyone can give me some instruction on how to send through Excel an email with an HTML file as message body.
I tried something out but does'nt recognize the html but placed it in the body message as text.

I know how to send email and even how to send it with a spreadsheet as message body, but an HTML message body would give me much more flexibility.

Thanks a lot,
Elad.Click to expand...

Welcome to TSG.

I recommend you attach a excel in the attachment, it's the way we can do.
 

1 more replies
Relevance 63.14%

I am working with the attached spreadsheet in Excel 2010 and am trying to figure out how to code certain parameters that will make Excel send myself, my client or other individual an email (with text in body) if certain dates have not been entered into particular cells, or if a cell has exceeded a certain number of days in a particular cell. I have attached a sample spreadsheet and have listed at the bottom 8 points in which I need an email sent, what the trigger is and what the action (email sent to) is.

I just know enough to be very dangerous with Excel but have found that there is a way to code in Excel to send emails which would greatly help my business but I just don't know that much about codes at all.

Can anyone please help me??

Thanks!!
 

Answer:Excel Coding to Send Email based on Cell Entry

Hi, welcome to the forum.

I suggest you do a find in the forum, there are many posts that gao about this and there are many answers, I'm sure there is one that will help yu and of course one of us can help you if you're still stuck
 

2 more replies
Relevance 63.14%

Win 7 update. Now, Outlook says unable to open file an error occurred. An error occurred try again later.

I use Win7. Restore didn't work. I updated windows, did the repair and have no luck.

Error 0x80070002 when I try to e-mail a file. Also mentions memory and disk space. I have 1.5 GB RAM and well over 150GB of HD space.
 

More replies
Relevance 63.14%

I'm having trouble with an Outlook Express installation. Since about 2 days it's stopped sending email. I don't get any error messages, haven't changed (and have verified) my provider's server settings and checked all the basic options. "Send&Receive at startup" and "Send messages immediately" are both checked but my emails get sent to my outbox and stay there no matter what I do.

Any thoughts on what could be causing this?
 

Answer:Outlook won't send email

I am having that same problem since I installed outlook. It seems like I can never can get it to work from the start. Any help will do, because it is an useful program. Thanks!
 

1 more replies
Relevance 63.14%

I was using my wifes laptop and went into outlook to send a email after composing it was unable to find the send button.Can anyone tell me where it is located.She is using Office 2003 on Windows 7

Answer:How to send email using outlook

On mine the "Send" square button is in the top left of the message being composed , to the left of the "To" and "CC" buttons. You have to have the message on show. To forward a message, right click it in its category list and select "forward".

4 more replies
Relevance 63.14%

Hi,

I am using a btinternet.com (BT Yahoo) email address with outlook 2007. I have used it for ages with no problems, then suddenly a few days ago I could receive, but not send email. The messages would appear to have sent, would show in my sent items folder, but they didn't actually get sent.

I tried to change a few settings, which didn't work, and have now put it back as before, but now the messages don't even leave my outbox. When I click send/receive, it just stays on sending for ages, but I get no error messages.

I connect to the internet through TalkTalk broadband, and the settings I was using were POP3 - mail.btinternet.com SMTP - smtp.talktalk.net.

Please help, this is driving me crazy!

Answer:Outlook Email Won't Send

it might have been helpful if this thread in the HJT section http://www.bleepingcomputer.com/forums/t/126471/cant-open-some-websites-hjt-log-please-help/had been linked TO this thread as it is probably relevent to your issues so one needs to await THAT threads replies first

6 more replies
Relevance 63.14%

I've been using Outlook this morning and everything ok until just now. Composed a forwarding email from an incoming email, clicked on send and...nothing. But get this message (helpful, not) "Cannot send this item". Also tried changing email accounts, same thing. But tried sending test emails from variety of accounts, all ok. Is there something about the email that is preveting outlook from sending this email. It was generated from Windows mail by my daughter and I've replied to her previous emails with no problem so its just this one. Anybody got any clues? Thanks in advance.
Update: I created a new email and attached the email from daughter and this was sent successfully.
 

More replies
Relevance 63.14%

hey i'm having a problem with sending "both" my email accounts... they both use diff servers so i know it has to be a problem with outlook

Your server has unexpectedly terminated the connection. Possible causes for this include server problems, network problems, or a long period of inactivity. Account: 'pop3.****.com', Server: 'smtp.****.com', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 10053, Error Number: 0x800CCC0F

i get that error with both accounts.. i know the SMTP server is right because its been ok for the last 2 years and know all of a sudden both emails will not send..

thanks for any help

boo

Answer:Outlook will not send email

First thing to check is if you have a firewall. If you do, try disabling that and see if it sends. If not, and you are sure the addresses are correct, try setting up a new identity with that account. Sometimes they do become corrupt and simply resetting the account may clear it up.

9 more replies
Relevance 63.14%

Hi,

I have been running outlook 2003 for almost 3 years ok.

However, today I find I can not send email via outlook (receiving incoming email works fine).

The message I get reads;

"sending reported error; 0x800ccc0f. the connection to the server was interrupted...."

It has been like this now for 2-3 days and causing a real pain.

Is there anyone on this board with the expertise in outlook 2003 who would be kind enough to help me fix this problem?

I am running XP, outlook 2003 etc. I have tried to restore XP to earlier in the week but still the problems persist.

Any help much appreciated

Thanks

mike9inch
 

Answer:Outlook NOT able to send email - Help, Please

8 more replies
Relevance 63.14%

I know my settings are all correct cause I talked to tech support before posting this issue. I can recieve, but can't send. The tech guy suggested reinstalling Outlook. I did so by reinstalling 2k. I had other reasons for reinstalling 2k besides the Outlook issue. Anyway, he had no solution and I figured someone around here can gimmie some good ideas.

Here is the error.

The message could not be sent because the server rejected the sender's e-mail address. The sender's e-mail address was '[email protected]'. Subject '', Account: 'Bill', Server: 'outgoing.verizon.net', Protocol: SMTP, Server Response: '553 Authentication is required to send mail as <[email protected]>', Port: 25, Secure(SSL): No, Server Error: 553, Error Number: 0x800CCC78

Any suggestions?
 

Answer:Outlook 6 won't SEND email

7 more replies
Relevance 63.14%

I migrated to att.net.yahoo.com, I'm using MS outlook '07 (windows XP). AT&T helped me set up the email account: I receive email in outlook but can't send any email. AT&T helped all they could and said it is a MS outlook issue. Is there a fix for this problem? error message: 0x800CCC0F connection to server interupeted
 

More replies
Relevance 63.14%

I CAN'T SEND EMAIL OUT ON OUTLOOK

More replies
Relevance 63.14%

I have Outlook 2010 and back in May my email stopped sending.  I just got frustrated and stopped using it.  We have SmarterMail so I just went directly to that.  I really miss
my Outlook program, can you help me fix this issue please?

Nancy

More replies