Computer Support Forum

Set email reminder base on Excel

Question: Set email reminder base on Excel

I have a list of task (maintainance schedule) to do... and they are required to be done in a by certain different dates regularly (eg. every 14 days or every 28 days)

I have a specific maintance date for each task within the same row. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

thanks

Relevance 100%
Preferred Solution: Set email reminder base on Excel

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

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

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

Answer: Set email reminder base on Excel

16 more replies
Relevance 105.78%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Solved: Set email reminder base on Excel

you have another thread here
http://forums.techguy.org/business-applications/1055728-set-email-reminder-based-excel.html
please do not duplicate posts - closing this one
 

1 more replies
Relevance 75.85%

I have searched and read the topics on this, however I am apparently below beginner and need someone to walk me through the entire process. I need an email sent to myself and 2 other co-workers one day before an item listed in my spreadsheet expires. I have the expiration dates are listed in column F. I have not entered any email addresses yet.I would like, as I have read in previous threads, for the system to open and check itself daily. Any help is greatly appreciated, and I will need a very basic, step by step hand holding description.
 

Answer:Excel Email Reminder

Hi, welcome to the board.

I suggest the following link, there enough information and samples there too.

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

2 more replies
Relevance 75.03%

I have a real simple need. Well, it's probably simple for some. I have a sheet built to track employee hire dates and eval dates. I would like to assign excel to open everyday at a time and then evaluate the cells with the eval and raise dates to see if an email needs to be sent to the supervisor. If so a simple "there are employee items coming due" email is sent to the supervisor. The super will go to the document and take care of the rest. Dta is not real. The email with the employee name isn't the one I'll be sending to. The Team Manager at the end is where the email will be going to for all on the sheet. I would appreciate the help. Running windows 7 and office 2013.
 

More replies
Relevance 75.03%

Hello there,

First time posting and very average excel capabilities... Working on generating a code that will send automatic email reminders 7 days prior to the date within rows F-P. Recipients contact information is in column S.

Thanks for your time.

Tim
 

More replies
Relevance 75.03%

Hi,
I'm kinda new to VBA and excel programming and am looking for a way of sending an automated reminder 60 days before the expiry of training already completed. column G contains the email recipients, Column E has a title Asbestos Awareness and the cells in column E the expiry dates for employees.
I would appreciate if anyone has sample code I could try.


Thanks sooooooooooo much for any help or advice.
Regards
Vinny
 

Answer:Automatic Email reminder in excel

Hi Vinny,
welcome to the forum, you're the second one this week with the same question, and just like the other poster I do not think you took the time to search for similar posts.
I suggest you do hat, there are several posts with the similar questions and also with the answres and code provided.
 

1 more replies
Relevance 75.03%

If I am doing an automatic email reminder when something is past due:

do I always have to open the Excel document for the macro to run and the reminder to sent out?

Thanks,
 

More replies
Relevance 75.03%

Hello Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

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 a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel

Hi, I suggest you do some searching, there are quiet a few posts with the same questions and the necessary solutions.
I worked on one or two but cannot remember the names, so just do a quick search and you'll find the answres with the necessary code.
Always to glad to help on if you're still stuck
 

1 more replies
Relevance 75.03%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Set email reminder based on excel

Hi, take a look at some of the posts, there are quiet a few that do just that, they may need a little editting for your purpose but...
Here's a simple module that does just that, all you need to do is wriet a amcro that fills in the blanks

Code:

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

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


P.S. You forgot to mention the Excel versio you're using
 

1 more replies
Relevance 75.03%

Hi guys,
I have a list of some certifications and their respective expiry dates written in Excel sheet. What I want is to be getting Auto reminder few days before, on and after the expiration date.
Attached is the VBA program that I tired to use but it was reading the whole data instead of being selective. Also attached is an extract of the excel sheet.
Pls I will appreciate any help
Thanks,
CJ
 

Answer:Auto Email reminder from Excel

Have you read the Thread under yours -
http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
 

1 more replies
Relevance 74.21%

Hi everyone,

I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its completed, the checkbox would be checked and no mail will be sent.

The email should look like:

To: <email stated in that row>
Subject: Reminder to complete project within (e.g. 60 days)

Body:
Dear all,
Reminder to complete IN1661234 by 31st Aug 2016.

<personal email signature>

Do I need to create a button where I have to click in order for those reminders to be sent or will it be sent automatically everyday as long as the spreadsheet is opened?

Also, is it possible to create 3 different email template for each reminder days, such as 60 days prior to the deadline, the subject of the email would be First Reminder, 30days would have Second Reminder and 7 days prior would have FINAL REMINDER and a urgent marked on the email?

And how do I change the email where those reminders will be sent from?

Any help with regards to the above would be greatly appreciated. Thank you so much.
 

Answer:Auto Email Reminder from Excel when project is almost due

16 more replies
Relevance 74.21%

I have a list of jobs (jobs schedule) to do... and they are required to be done in a by certain different dates regularly.

I have a specific jobs date for each task held in a colu. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

Another question - I have a basic dashboard when a job is overdue I want the cell to flash RED

thanks
 

Answer:Set email reminder based on conditions on Excel

10 more replies
Relevance 74.21%

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

Hi Guys,

I have just joined this forum, I found some solutions given by Zack quite useful to me. Thank you so much.

But also need help in taking it further, as I have created a worksheet with lots of data which will have to be incorporated while sending auto email reminders to various admin officers depending on the dates, especially for Statutary payments like Telephone, Electricity etc.

If any body can help....... Please...............
 

Answer:Auto Email reminder from Excel Sheet

http://forums.techguy.org/business-applications/773873-how-make-excel-send-email.html
 

1 more replies
Relevance 74.21%

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

The dates would be as follows:

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

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

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

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

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

More replies
Relevance 73.39%

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

Hi lovely people!

I hope you can help me out - I'm new to macros. In regards to the attached excel file, I need to achieve 3 main goals:
Automated pop-up message - For each phone that is overdue for delivery (ie current date is more than due date), I need a pop-up message upon opening the excel sheet. The pop-up alert should say which phone is due (stock #), and how many days overdue it is (current date minus due date)
Automated email reminders - emails to send to various email accounts (individuals in my team) to remind them of overdue phones. The email should include details like the phone, stock #, supplier, due date and how many days overdue. I want the first email reminder to be sent on the due date itself, then 2nd reminder on the next day, and subsequent reminders every 3 days.
Have a separate sheet listing all the overdue items that need to be followed-up.

Lastly, but is it at all possible to create two versions of the same stock list? I.e. one sheet in English, and the other sheet in French. And any edits in either sheet will update the other version.

Cheers!
 

Answer:Excel help! Automated pop-up box and email reminders, and reminder list

Hi, welcome to the forum.
Have you doen a search in this forum.
There are many posts that relate to triggering a mail message based on calculations and expiry dates, etc.
You will of course need to edit some solutions for your purpose, but I do suggest you take a look (search) and probably you'll find what you need.
The question about the two languages is custom macro coding and will take some time.
Your sample contains onle one row of data, but nothing more to go on.
Do some homework (searching the forum) and someone will be able to help
Please don't forget to mention the Excel version, as far as I cansee it's at least version 2007 but it could be 2010 or newer
 

1 more replies
Relevance 73.39%

Hello Everyone!

This is my first post here. I am using Excel 2013 OS win 7. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

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 a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel 2013 in Windows 7 pc

closing duplicated post
continue here
http://forums.techguy.org/business-applications/1141421-automatic-reminder-email-excel.html
 

1 more replies
Relevance 73.39%

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

Hi All,

My name is Diego.

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

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

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

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

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

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

Closing thread.
 

1 more replies
Relevance 72.57%

Dear Team,

I have gone though the below thread, which helps somewhat on my requirement but not completely. Please need you kind help on VBA code. Sorry if i have missed any other thread which would have met my requirement.

https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

Here is my requirement...
I have a data in excel (attached file) basically its a re-assigment project which needs 3 tasks.

Column A to E are filled manually which need not be automatic.
Column F has a formula for 29 days date for Column B and accordingly Column H for column F.
Column G & H are the status of task action.
every day we are manually opening the WB and checking for daily pending assignments in column H & F for today's date.

Can you please help me with a VBA code which should send a email notification/reminder not to individual email addresses instead it should send an email to me, If the Column F & H has today's date i.e. current date with the table of data in body of email and update the status as Done in excel sheet once the email has triggered.

Hope you will help me on this. Many Thanks in advance

Example of email
 

More replies
Relevance 72.57%

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

Hi, i am new to this forum. Can anyone tell me if i can have a date reminder system for my database in Access? Basically its a licence database and each year a form has to be isgned by each licence holder. is there a way the program can remind me for each name when the form needs to be resigned each year on a particular date?many thanks

Answer:Microsoft Access Data base date reminder?

There doesn't seem to be that facility in Access.Just as easy to use Outlook I would think.

3 more replies
Relevance 55.76%
Question: Email Reminder

Does anyone know how to make Outlook 2000 email reminders continue to remind you of unread messages, say every 10 minutes or so.

Thanks,
Ted
 

Answer:Email Reminder

I think the closest you may get is flags but I am not real sure how they work. You can look in the help files under flags to get more.

Sorry.
 

2 more replies
Relevance 55.76%

Hy there,

Can some1 help me code a script that will send an e-mail reminder with one date before the DUE DATE based on the date that is in excel. Prb is that i have more the 1 sheets and the date is not always on the same column.

Thanks.
 

More replies
Relevance 55.76%

Hi, Its my first post here. I need to send reminder mails from outlook based on excel
I searching for the VBA which according to my needs and I find in this Forum, but I have difficulty understanding. VBA that I adjust not functioning.

I attach the following

I need your expert solution

Any help appreciated and thank you.
 

More replies
Relevance 55.76%

I have ordinary excel table with formulas and dates.When formula in cell fill up another cell with notification "SendReminder" i need to cell send me notification on e-mail. I need also to macro runs even when table is closed. Thank you

More replies
Relevance 55.76%

Hey Guys,

I need some help getting an on-screen (pop-up or message dialouge) reminder based on date entries in my excel workbook. I have gone through other posts suggesting methods to get an Email as reminder, but could'nt figure out how to go about for an on-screen message.

I need a message listing all tasks which have two days left for completion. This should carry on even if the date is passed untill I change the date entry for a particular task.

I wish to have this message at user logon automatically, so will schedule execution of a VBS file which I could find from an earlier post by Zack.

Will be gratefull! for your help.
Thanks.
 

More replies
Relevance 55.76%

Hi All!

I have a list of events and dates for those events and I need to create a system that will email cetain people when those dates approach. I have done a little research but cannot figure out how to make it work. Please help me! LOL Thanks!
 

More replies
Relevance 55.35%

Hi everyone. I am currently setting up a database that will hold employer contact information. This document is going to be used to keep track of when a person called the employer, the part that will require some effort and code is setting up a reminder. In this database I need to add a counter or some form of counter that keeps track of how many days its been since the employer has been contacted.

So in one field we have a spot left for Date Contacted. So based off of the information in that Date Contacted, say I contacted an employer today, what I need is for that counter to basically automatically send someone an email when its reached a predetermined amount of days since that employer has been contact for arguments sake lets just say 5 days.

IF anyone can help me with this I would be grateful, Im not very MS access savey. Currently I am working off of MS Access 2003.
 

Answer:Auto-email Reminder

16 more replies
Relevance 55.35%

I cannot find any way to set an email reminder for an event in Windows 10 Calendar app. Using Calendar at Outlook.com this is an option. Is this by design or am I missing something?

Answer:Set email reminder in Calendar app

How i do it is Calendar App Then Click on the day I want
Click on Event
Fill in the details Click Enter or OK and it is all set to go.
I have mine already done up to Xmas of next year
Just checked and found working ok on mine

1 more replies
Relevance 55.35%

I am working on a long list of temporary employees hired with "termination" dates. These dates vary. I want a reminder set to 5 days before the listed "term" date so it alerts me with a reminder. I have seen many different formulas and they work.

The problem I'm having is that there is a long list and that is a "continuing" list...so there are many blank rows. Currently I am using both conditional formatting to highlight it and I'm using the IF formula:

=IF(I2<TODAY()+5,"REMINDER","")

The problem is that it is filling in REMINDER for all of my "empty/blank" rows. I do not want it to appear other than where the data is, but I don't want to have to remember to carry the formula down. So right now I have about 22/23 rows that are filled. I want to expand my spreadsheet out to about 600 rows. But everything past the 23 rows is showing REMINDER even though there is no data in those rows. Is there something I can do to have it carry through the 600 rows, but not put in the reminder until there is data in there telling it to send a reminder? I'm using a MAC with Excel 2017. Thank you for any information.
 

More replies
Relevance 54.53%

Hi....
Anyone can help me to advice how do i write VBA for auto email reminder for due dates.
I have tried one from internet guidance but it doesn't work.

i want the email reminder to a list of IDs before 60days and it's much helpful if the program can send the email without opening the excel sheet.

please help.
i have attaced the file.

thank you so much.
 

More replies
Relevance 54.53%

Using Excel: I need to send one email reminder to participants three months after they sign up.
This is only done once.
I need to mark a field "sent" after they have been sent this reminder.
The next time I check for people needing a reminder those marked "sent" will not be sent another reminder, only those who have not been marked "sent".
Thanks for the help.
 

Answer:Solved: Excel send reminder and mark it was sent

Hi, welcome to the forum:
Code:

Option Explicit

Sub SendUpdate()
Call MailData("subject string", "status file updated", "[email protected]")
End Sub

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
.Save ' This property is used when you want to saves mail to the Concept folder
' .Display ' This property is used when you want to display before sending
' .Send ' This property is used if you want to send without verification
' .Attachments.Add (Filename) ' Must be complete path'and filename if you require an attachment to be included
End With
Set app = Nothing
Set Itm = Nothing
End Function

You will of course have to add your macro to send the mail and then enter a true or false in the sent column

A handy link to use ... http://www.rondebruin.nl/sendmail.htm
 

3 more replies
Relevance 54.53%

For some reason there is a problem with this programme I have built (with help from Computerman) now I have transferred it to another excel file.

When I try to set a Callback Reminder (my terminology), once I have entered the details an error comes up for some reason. The programme has been tried and tested by itself and worked brilliantly but for some reason it doesn't now.

Please use password lfc1979 on the login screen
 

Answer:Solved: Excel outlook calendar reminder

9 more replies
Relevance 54.53%

Hi

This is a tuffy........

I want a macro so that when i type a message into a cell it will put it into outlook as a reminder, or even a simple macro button that opens outlook in the scheduler.

Any ideas?

Thanks
 

Answer:Excel macro links to Outlook Reminder

Try this link.
 

1 more replies
Relevance 54.53%

Hi, this is my first post here and I will preface this by saying I am not familiar with VBA/VBScript language at all (only that it exists and perplexes me), which is why I'm requesting your help!
I have an Excel spreadsheet that I'd like to have send me an Outlook email reminder 6 months after the specified start date, without having to open the Excel file so the macro can run. The reminder email can be simple, just a short message like "Referral Alert: Check Spreadsheet"

I've attached a test file with the columns needed highlighted in yellow.

If this is too tall of an order, I understand!
 

Answer:Send Outlook reminder on specified dates from Excel

As far as I know, this is impossible in the given scenario. Macros only run once a file is loaded; therefore, not having the file loaded means any code won't execute.
 

2 more replies
Relevance 54.53%

Hello,

I have currently tasked myself with what i thought was an very easy and simple job of being able to set up a way of having an automated email system which uses excel data.

My data contains basic information about calibration dates, i need an email (reminder) sent to a specific email address 6 months prior to the calibration date using the dates in the excel spreadsheet as a reference for the 6 months to trigger an email.

By *automated* i mean the program doesn't necessarily have to be open and doesn't require anyone to hit a command button to send off the email, it should be done without any manual interference if it is even possible to do this.

I hope you can get back to me on this issue.

Many thanks,
Ryan
 

More replies
Relevance 54.12%

GOOD DAY, NEED YOUR KIND ASSISTANCE TO THE FORMULA I MAY FORM TO SEND REMINDER E-MAIL TO MY CLIENTS IF ONE OF THE 3 COLUMNS CONTAINING DEPOSITS DUE DATE IS WITHIN 1DAY AND NOT YET BEING PAID.THANK YOU

Answer:Excel 2013 auto sending of reminder e-mail

This cannot be achieved with a formula you will need a macro. The requirement is fairly straight forward but we need some more information to be able to produce this. How is your workbook laid out? we need to know1) which cell has the dates in it2) which cell has the email addresses to which you want the email to be sent3) what the email body and subject will be Also please note writing it caps is considered shouting, please don't type in caps.

3 more replies
Relevance 54.12%

Hello.
I have been asked to send warning e-mails to a short list of adresses from an Excel file where reminder dates correspond to the actual date, and I have no clue how to do this with Macroís. Iív tryed to understand how some examples of macros dealing with Excel and e-mails with no success as I still have a lot to learnÖ

Here is my problem : I have a spreadshhet containing company names (col.A) and contract renewal dates (col.D). there are about 80 companies listed. When the actual date corresponds to the reminder date an e-mail containing the company name, a fixed blabla and the reminder date should be send to 3 known e-mail adresses.
Could this be done with an Excel Macro
Iím using Windows 7 32bits, Office 2010 with Outlook as mailing system.

Many thanks in advance.
Robert
 

Answer:Solved: Reminder date in Excel sends an e-mail

16 more replies
Relevance 54.12%

how to set auto reminder when a due date is reached mentioned in excel EVEN WHEN EXCEL IS SAVED AND CLOSED?
 

More replies
Relevance 54.12%

Hi,

I am a beginner to excel VBA/Macro (just know basic excel) but I have a task from my work superior. He has multiple contracts on hand and am checking excel by opening manually for the expiry date. He might forget to check when he's busy. Is there any way for an email to be sent automatically/notification pop up to remind him and 3 other colleagues, 6 months before the contracts' due dates? Thanks!
 

Answer:Email Reminder to be sent 6 months before contract expiry

Yes this is very possible, how is your workbook laid out, in fact it would be better if you upload a copy REMOVING all sensitive information, or replacing that information with dummy data. Then we can have fun coding it.
 

1 more replies
Relevance 54.12%

which one is best , and anonymous..I found this list ..click here any ideas one which one might be best..?

Answer:simple free email reminder service

for regular reminders-click here

2 more replies
Relevance 53.71%

Hi,

i have used the following to get automatic alerts setup when a due date is near:
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

but instead of this looking at the due date column, i would like it to look at a conditonal formatted column, which shows status as either "due" and "expired" depending on due date. i would like it send out to all those with "due tag and not "expired"

I have name in column A, details in column B, emails address in column C, status in column i, and reminder in column k
Somethng else i would like to do later on, if at all possible,is to get a particluar email from outlook be transfered to excel and and then emailed to specific people based on a status column. So if an email is recieved to say a project is extended or cancelled,, it contents is copied to excel and emailed back out to certain people.
Thank you for your support.
 

More replies
Relevance 53.3%

Hello,

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

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

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

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

More replies
Relevance 52.89%

Hello all,

I'm receiving mail alert based on date only, it is not considering the month into the account.. Kindly suggest..

Attached the excel file with macro...
 

Answer:Automatic Outlook mail due date reminder based on Excel file

16 more replies
Relevance 52.89%

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is 7 days 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. D), with subject "Project (Col. B) is due on Due date(Col. C)", and body "Dear Name(Col. A), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. E) 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 a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

Answer:Automatic Outlook mail due date reminder based on Excel file

8 more replies
Relevance 52.89%

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a payment is 10 days 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. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

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

I have scored the forum for similar problems, and although I found a number of threads, I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Outlook mail due date reminder based on Excel file

15 more replies
Relevance 52.48%
Question: email data base

Can anyone tell me how to create / setup an email data base that can be used for my website and front page?
 

Answer:email data base

It depends on how you want the database set up. Do you want visitors to fill out a form and have the results go directly to the db? Like for a mailing list or something? Do you have a host for your site? Most hosting companies have a mailing list/database manager. You would then just need to set up the form and have the results go to a file on the server.

TT
 

3 more replies
Relevance 51.66%

I need a simple data base to keep track of inventory items, mainly just simple data like cost, taxes, shipping, sales price and profit.

I have a Access DB started up and everything seems fine and I can get a over all sum of items from the top down but if I want it to autofill, like I have on colum that is purchase price, the next one is tax, the third one is total, how can I make it auto add or subtract within the same row?

Maybe it would be easier to use excel for what I need but I would rather use Access since it seems like it is a lot more powerful for DB's

Any other ideas or suggestions on inventory software? One day I will plop down for an expensive ap if I need it but until then I need to get by.

Answer:Access, Excel, Inventory data base help.

http://office.microsoft.com/en-us/ac...879071033.aspx

That should give you some ideas.

2 more replies
Relevance 51.66%

Does anyone know of a converter to change a WDB file to an Excel file? Or, does anyone know how I can get the WDB file to open in Excel?
 

More replies
Relevance 51.25%

Hello,
I have four computers at home, one on a VPN that my wife uses for her work and it's strictly hands off for me. Then I have a desktop as my main home computer, and two laptops. All are connected to the cable modem, two by Ethernet cords, two wirelessly.

My workplace has a Web-based email service. Most of the time, I can access it just fine. But now and then, and never with any consistency, I can't access the email portion of that site. I can access everything else on the site, just not the email. This is the same for all three of my home computers. When I hop onto my Sprint card via my laptop, I can access my work emails just fine. When I resync my modem, then all is well and I can access my email just fine.

I have tested my network by running a wire from my Comcast business modem to my one desktop computer, bypassing the wireless router. Still, I can't access the email portion of the Web site.

Any suggestions. Please keep it simple, I'm not as smart about the ever-emerging technology as I once was.
 

More replies
Relevance 50.02%

An Excel Macro to find only the exact wordn & copy rows based on a keyword listI am using the below scriptSub carHunter()'Determine last row with data in Sheet 3 Column A lastSrc_rw = Sheets(3).Range("A" & Rows.Count).End(xlUp).Row'Loop through list of cars For Each car In Sheets(3).Range("A1:A" & lastSrc_rw)'Search for each car, copy row if found With Sheets(1).Columns(1) Set c = .Find(car, LookIn:=xlValues, lookat:=xlPart) If Not c Is Nothing Then firstAddress = c.Address Do'Find next open row in Sheet 2 nxtDst_rw = Sheets(2).Range("A" & Rows.Count).End(xlUp).Row + 1'Copy row containing found car c.EntireRow.Copy Destination:=Sheets(2).Range("A" & nxtDst_rw)'Search for same car again, stop when no more found Set c = .FindNext(c) Loop While Not c Is Nothing And c.Address <> firstAddress End If End With NextEnd SubBut if this script is searching for es then it wll copy all words whch has ed on it.Please help. want to copy only that row which has the exact value.

Answer:An Excel Macro to find only the exact wordn & copy rows base

First a posting tip...Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum.As for your question, the Lookat argument for the .Find method is set to xlPart which means that it will return any value where the search string is found, even if it is only part of the cell.e.g. Searching for the text string "hat" will find "hat", "that", "top hat", "hate", etc.If you only want to return values that are an exact match, change that argument to xlWhole. In that case the entire cell must match the search argument exactly.Since I can't see your data from where I'm sitting, I am going to guess that the cells that contain "ed" also contain "es" somewhere in the cell.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 49.61%

I dumped Firefox as a browser because of 'plugin-container' gobbling up all my mojo.

I loaded Google Chrome and it's very spiffy, but a different program (my database manager) when you click the button next to the email address it will no longer open a virgin email in Windows Mail like it used to. I don't know what code to drop into the "path" box on my program to get it back. Jack - [email protected]

More replies
Relevance 47.56%

I am having some connection problems to a mysql database for a small shop, which is located on a shared hosting server. I am using Open Office Base as a front end on Windows 7. I will create a form which is simple and easy to use for someone that is non technical, I could not use for example phpmyadmin or something that exposes too many options to the employee. OO Base does connect successfully but after a short time of inactivity there is an error message which is SQL Status: HY000 Error code: 2006 MySQL server has gone away. The reason for this has been determined that there is a time out of only 30 seconds which unfortunately I cannot change, as it is set by the hosting company in the my.conf file on the server. They also as most web hosts are of limited help. OK fine so I should just be able to reconnect. The problem is that Open Office proceeds to crash and I have to go through a file recovery window and there are several steps including having to re-type the password again to connect. I really need to solve two things here, prevent OO crashing and also having it realize it lost the connection and just re-connecting, without having to type in the password again. I have tried turning off the auto recovery of files but it didn't work, I have tried adding no restore as an option in the shortcut, also didn't work. I have tried enabling connection pooling, it also didn't work. For reconnecting I tried adding ?autoReconnect=true to the end of the database name a... Read more

More replies
Relevance 46.74%

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

I have a download speed of up to 20Mb and assume that a 10/100/1000 modem will not be any faster than the 10/100 one. The reason for this is that the 10/100 modem is 5 times faster than the download (theoretical) speed of 20Mb. Am I correct in this assumption? Any input gratefully received. My decision to switch from Virgin to Sky maybe influenced by your input. Thank you.

Answer:10/100t base versus 10/100/1000t base

It is the Router's Network Switch (i.e. its four LAN ports) which is either 100Mbps or 1000Mbps (1Gbps). With a 20Mbps internet connection, the higher port speed won't make any difference to your internet performance.
Where it will make a difference is if you transfer large amounts of data, or large files, between computers in your local network. However, all computers/devices connected by ethernet cable in the network also need to have network adapters that support Gigabit.

2 more replies
Relevance 44.69%

HiIn word you can drag an email into it and it will appear as a link to the said mail. Is this possible in Excel also?thanks

Answer:Excel - drag an email into excel

I can't get it to work in Excel.

3 more replies
Relevance 44.28%

I'd like to suggest having the Off Base and Way off Base news items in the XML News feeds section...possibly as a separate feed or include with the downloads feed. Is this viable?
 

Answer:Off Base and Way Off Base in XML News feeds

I will have to ask Jim, I am unsure.
 

1 more replies
Relevance 44.28%
Answer:convert email id to another email id in Excel

Please do post your question more than once.I have deleted your previous post of the same question.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 41%
Question: Email from Excel

I have the code working but i want to make sure I don't screw it up. It is set to send an email 14 days before the due date. But i want it to send another email 7 days before and then at 1 day before.

Also i would like it to send the emails without having to open the excel file.

Thank you in advance. I am new at this coding and trying to learn to improve my companies communication.

I have attached my workbook.
 

More replies
Relevance 41%
Question: Excel to email

I have a list of 27 email addresses in Excel and need to use these to send out a newsletter. I normally get this amount each month and am sending out newsletters by manually copying the address from Excel, pasting into Outlook, adding the attachment (newsletter pdf) and pressing send. It takes up a half of my working day!The newsletter is the same in each case. The subscribers to the newsletter is slowly growing, so I would prefer not to spend a whole day cutting and pasting addresses1Is there an easier way to do this?Many thanks in advance.

Answer:Excel to email

You may be able to e-mail 'directly' from Excel. There is a lot of example code by Ron de Bruin click here and an add-in click here but these are all to do with sending Excel files (or parts thereof).Take a look. If you see something potentially useful we can probably modify it to send a PDF.

10 more replies
Relevance 41%
Question: Excel- Email

My OS is windows vista home edition and gmail. With my Excel 2007 gridlines checked, the gridlines does'nt appear in the email.
Please help.
Thanks.

More replies
Relevance 41%
Question: Excel email

Hi, in excel when I send a document with gridlines to email with outlook via the email icon on toolbar , the recipient gets the document without the gridlines.
 

Answer:Excel email

Hi Painter guy, welcome to the board!

If you go through your mail client (i.e. Outlook) and attach the file, then send, do you have the same problem? Which version are you using? Have the user go into Tools | Options | View and make sure gridlines is checked.
 

3 more replies
Relevance 41%
Question: Excel by Email

My brother has created a spreadsheet using Excel that he wishes to send to me. I do not have Excel software nor have I ever used Excel. I have Windows 98, 433MHz, 96MB Ram, Outlook Express 5.0. Can this spreadsheet be sent to me in usable form by Email? Thanks for your help.
 

Answer:Excel by Email

Suppose that depends on what you mean by 'usable form'. You can download <a href="http://www.zdnet.com/downloads/stories/info/0,10615,28292,00.html">Microsoft's free Excel viewer</a> which will allow you to open the file but not to edit it.
 

1 more replies
Relevance 41%
Question: Email from Excel

I have been reading and reading and have seen you guys help out. But most of the VB have been more then what i need, at least i believe so, not sure.

Also been trying to learn code. It's harder then I ever thought.

I have been trying to find a way to have excel auotmaticly sent me an email when a bill is coming due. I already have a column "G" that change to true or false. I would like the email to be created when "G" reads "true" and sent me email saying is due. Also if and how to have it open and update on is own??? Saw something about ClickYes???

Thanks for your help, John
 

Answer:Email from Excel

10 more replies
Relevance 41%
Question: Excel And Email

I am using Windows XP system with 250 mg RAM. My email program is through MSN.

I received an Excel spreadsheet as an email attachment. When I attempt to open it, the document opens in "Word Pad" and is scrambled. I am not given the option to search for the appropriate compatible program either.

I have Office 2000 installed and I can open spreadsheets created in Excel format through the "My Documents" folder with no problem. I can also create spreadsheets, so I am certain the program is functioning correctly. Additionally, I have no problems opening email attachments that are in Word format.

All suggestions are welcome. Thank you.
 

Answer:Excel And Email

Look at the file extension on the attachment. You may find it has been zipped or something in order to get it through a firewall.
 

2 more replies
Relevance 40.59%

This is my first post so be kind if it doesn't have everything you need.

I would like Excel to automatically send an email to a unique email address when a trailer is logged as complete. I've included a spreadsheet as an example. What I would like to happen is when a date is entered in column E, excel would look up a carrier email address based on what is in column B that would be kept on a seperate tab and then email the following..."Trailer # (data from column C) is empty."

I use Excel 2002 and Outlook 2002
 

Answer:Using Excel to trigger an email

You can add as many rows as you want to either sheet, but don't change the layout of the colums or it will break.

I warn you now, it works, so don't click the button unless you are prepared to send an email to the listed contacts on the second sheet. I'd change them all to your email address for now until you are ready to go live with it

I opted for putting a button in because the only other way to do it would be to link the macro to a change cell event which would make it run EVERY time any cell is changed. A button is much easier. Type in all the dates then hit the button and it disperses all the emails to the listed emails for the carriers. I added a column also for the macro to mark a "Yes" in once it has emailed it. That way the next time you press it, those ones are ignored

And i accidentally sent a test email to one of your contacts on the sheet. You should use fake emails when posting examples. I apologized to the guy but he didn't seem to mind.

I didn't comment any of the code as i was in a hurry, if you need more done just write back and i will make the alterations and fully comment the code for you so it can be understood better
 

1 more replies
Relevance 40.59%

So I need help on something very easy.
I need to have excel email just one person when a due date is met.
This is really simple
the cell in A1 will be the current date, aka =today(), and the cell in C1 will be the impending due date, like =A1+45, and B2 would be the function, in which =IF(C1=A1, "alert", "not due")

I need the email to be sent if B2 reads alert.

OS Windows 7
Office 2010
 

More replies
Relevance 40.59%
Question: Excel Email Macro

Hi All,

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

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

Any help on this will be great.

JPL

Any
 

Answer:Excel Email Macro

Hi JPL,

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

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

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

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

1 more replies
Relevance 40.59%

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

Answer:Excel - macro email-

6 more replies
Relevance 40.59%

HI,

I am running office 2003, I did updates to suite and can not send emails from Excel. I get a not implemented error and that Microsoft Outlook could not be started. Word works fine.

Any ideas, running Norton Antivirus and everything was working till I did the office updates.

Thanks,

Sandra
 

Answer:email issue from Excel

11 more replies
Relevance 40.59%

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

Hi All,
I am new to this sort of stuff; this is the first forum I have joined.
What I want to do is set up a worksheet in excel 2007 e.g.:
Course A
Course B
Course C
Name A
29/12/12
30/12/12
31/12/12
Name B
Name C
And 7 days before the date in a cell is due, the course name and the personís name and the actual date will be sent to me via email automatically. Possibly, without excel even running.

I do not know if this is possible but any help would be much appreciated.
Thanks
 

Answer:Automatic Email from Excel

7 more replies
Relevance 40.59%

I create a excel database file with vlook up function. It's sort of a stock list with product ID and name stuffs. someone send me several items with product ID via outlook. When I tried to paste those product ID to the vlook template to look up for the product name, it didn't work nothing is showing up.(100% sure the product ID is exactly the same from the excel database and email) . It worked when I type the product ID to the template. Is it something deal with code or format? Can anyone help me ? I don't wanna enter 600 product ID to excel for product name. Need you folks help !!!!! THANKS

Answer:email to excel vlook

Excel questions are best asked in the Office Software forum.That being said, it sounds like when you copy & paste, the Product ID numbers being pasted as TEXT not real numbers.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 40.59%

Is this possible. We have an Excel Spreadsheet with Data.
We want to put a mark in the date field and when the expiry date is maybe 7days away.
For it to either highlight its due
or if possible link to outlook and send an email notification?

http://www.yourfilelink.com/get.php?fid=595994

Or got a good suggestion
 

Answer:Excel email notifications

hi woodland81,

For highlighting the expiry date you can use Conditional Formatting, select the column, Format/Conditional Formatting
then set the condition to be Cell Value Is / Greater than / =Today()+7
, set the format pattern to be say RED.

You can automate emailing with a macro , or alternatively use your data as input to a WORD email merge.

lol
Hew
 

3 more replies
Relevance 40.59%

I am new to this so be easy with me. I am trying to have Excel (2003) send an email out 60 day prior and on the date set in the "E" column (see file attached). I would like the email to go to the email address set in column "K" and say your CSA contract with "insert company name from column "A"" is about to expire in 60 days. Then basically the same for the email that is sent on the date of expiration but to say that it is expired.
 

Answer:Automatic email from Excel

13 more replies
Relevance 40.59%

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

Hi,

I want to create a kind of a program where if I enter data into an Excel spreadsheet, that data will be printed onto either a Microsoft Word document or as an email. For example, if I had a Word document or an email written as:

Dear ______,

Thanks.

I want to be able to type a list of names and email addresses in an Excel document, and have it automatically send to those email addresses with the names filled in the blank. Please advise. Thanks.
 

More replies
Relevance 40.59%

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

I have read a couple of posts here on this very subject, but admittedly, this is over my head and I need some help. I am currently using Windows XP, Excel 2007 and Outlook as my email client however, others in my office may be using something other than Outlook.

Attached is a page in my worksheet that better reflects what I trying to accomplish. Basically, I need to keep my clients informed of my activity on their project so I want to send them, my boss and others, a form letter containing my notes. A sample form letter is on the second page of the attached file.

My notes are entered into a row of merged cells and at the end of those cells I have placed a button for me to click to send the emails automatically. Additionally, I would like the word "Done" to appear beside this button once I have sent the emails.

Any help would be greatly appreciated.

Thanks

James
 

Answer:Email Data from Excel

7 more replies
Relevance 40.59%

I have an excel spreadsheet with some questions on it. I can create a form with the questions on it using "Data - Form". What I would like to do is email this form to about 12 people (instead of the whole Excel spreadsheet) and ask them to complete and return to me. Is there any way that this can be done?Thanks in advance.

Answer:how to email an excel form

I don't use Excel but normally, in the case of MS programs and applications, from (generally) File you can usually Send To i.e. in this case a mail recipient or recipients.

6 more replies
Relevance 40.59%

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

After 20 years I am using Excel again but, obviously, it has changed.
I have created a worksheet and saved it as a template.
I want to send it to my son via email.
Once he receives the email how does he get it into his Excel program to use.
Probably a silly question but I'm an excel user from the last century.
 

More replies
Relevance 40.59%

Hi everyone,

I am Frank and I need some help from all you experts out there. I want to setup my Excel to send me an email alert to my email account when a certain criteria is met. For example in a cell number that I have specified it calculates the sum total of a range of cells to return their sum value. The next cell monitors the value of the preceding cell to see if reached a fixed threshold value. How can I setup my email to make Excel trigger an email to me when the threshold value is reached? Appreciate all your help. Thanks.

FYI, I am using Windows Vista 32 bit with Microsoft Office 2007.
 

Answer:Need help with email setup for Excel

16 more replies
Relevance 40.59%

Hi there

can someone help me trigger auto email from the attached excel sheet ?

The email should be triggered upon the 'status' with corresponding message from 'remarks' column
 

More replies
Relevance 40.59%
Question: Excel Email Macro

Hi

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

Many thanks
 

Answer:Excel Email Macro

16 more replies
Relevance 40.59%
Question: excel email list

I have a excel document with columns of usernames and email address, i need to some help getting them email compatible, in this form:

"########" <#######@####>, and so on.........

The info is sensitive, so i will email it to you.

Thanks
Danny
 

Answer:excel email list

9 more replies
Relevance 40.59%

hello,
i am trying to sent out an automatic email anytime the workbook has been changed and for example 3 days have passed from a certain date on the worksheet. this would have to be applied to close to a hundred rows per sheet and would be sent to outlook 2007. not express or anything. wondering if it would require multiple VBA codes or not.
i have looked on the Ron site and many postings but i just found out what a macro was and would love to learn how to write VBA but dont have the time. looking to try and solve this. also need to know if the computer im working on has to have outlook or if i can do it from one that doesnt.
Have an example and any details for further assistance just ask. any help would be greatly appreciated thank you.
 

Answer:Auto email using excel

16 more replies
Relevance 40.59%

Hi all,

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

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

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

Regards
 

Answer:Email from Excel on date

Hey JohnG welcome to TSG.

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

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

1 more replies