Computer Support Forum

Automatic Outlook mail due date reminder based on Excel file

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

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,

Relevance 100%
Preferred Solution: Automatic Outlook mail due date reminder based on Excel file

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: Automatic Outlook mail due date reminder based on Excel file

15 more replies
Relevance 128.76%

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

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

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

HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
For this i should not open excel neither i know VBA scritping for this.
Please provide help on this.
As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
 

More replies
Relevance 93.67%

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

Hello Forum member,

I am working on an excel file with hundreds of records and tens of columns. There is a column"L" which gives the date when the license key given in column "B" of a particular software is going to expire. I need to check the column and send email to Person X [email protected] 3 months in advance so that he can take poper action to get the license renewed. It is too much of a manual work every week.

I am looking for a macro that can send an email to person X stating that license key value given in coumn B is due to expiration in 3 months from today(based on value given in column L)

I have seem a similar thread in the forum giveb below but i need changes to it. Unfortunately, the thread is closed and i can not contact the person who gave the solution. I am not able to modify the code shared to match my requirement.
Automatic Outlook mail due date reminder based on Excel file

http://forums.techguy.org/business-applications/1129238-automatic-outlook-mail-due-date.html
Can anyone please modify the code given in the above thread to match my requirement. Please!!Thank you!
 

Answer:Automatic Outlook mail based on a column value in excel file

8 more replies
Relevance 77.43%

Dear All,

I am creating a tracker file for Purchase Orders in which end date in column 'J' is very important.
Column 'J' has following conditional formatting
1. If cell date is in between todays date + 14 days --- YELLOW
2. cell date <= today's date ------------------------- RED
3. cell valus > today + 14 days ---------------------- GREEN

So now when the cell turn Yellow I want the excel should send the mail to the concerned person whose mail id will be mentioned in same row of column 'G'

One more requirement there should be two mails. Reminder 1 & Reminder 2.

I use officer 2010 & mail is outlook 2010 & OS is windows 7.
This file will be on share point. This file may not be opened everyday.

Please reply with the procedure as I am not a programming/ IT person... I may not understand all terms.. please try to simplify the response.
Thanks in advance for all the help.
 

Answer:Auto mail from Excel to Outlook based on date in cell

Hi there, welcome to the board!

You'd want a location to mark when an email was sent. I'm assuming you want a worksheet change event for this, which will basically always run when a cell on this specific worksheet is changed. There are other events you could use to fire it off, like the calculate event. You could, if you wanted to, assign this functionality to a button, but then it wouldn't be automatic.

The below code does what you ask. It goes in the worksheet module of the worksheet your data is on. To get to it, right click the sheet tab name and select 'View Code', then paste this there.

EDIT: The locations to mark when an email was sent (btw) were columns K and L, as you'll see them set as constants at the top of the code. You can change those letters to any column you want to house it in. It just puts the current system date in those cells, and that will be checked when the values in column J are checked. If nothing is there it assumes an email hasn't been generated yet and will do so. But if it has a value - any value, it will ignore that row.

Also, I assumed a 'yellow' highlighted value was your first reminder, and a 'red' highlighted value was your second reminder. It uses this as text in the subject and body of the email.
Code:
Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

Const ReminderOne As String = "K" 'column letter
Const ReminderTwo As S... Read more

1 more replies
Relevance 101.27%

While using XP, I used Pegasus mail as my e-mail client. Pegasus's mail filtering options included the ability to set a duration on a mail folder such that any message in that folder, older than the specified duration, was automatically moved to the deleted mail folder.

Is there any way to achieve the same thing using Windows Mail under Vista?

Thanks

Tony

More replies
Relevance 99.63%

Hi Everyone!! This is my first post here. I need your help in developing a method of sending automated emails on Gmail when the due date of Insurance payment is 7 days before the current date and an email when the due date has expired.

So as per the attached excel file an email should go to (Col H) when due date (Col F) is 7 days before current date, with the message "Payment of Rs. (Col E) is due for Policy Number (Col D), (Policy name (Col C)) for (Owner name (Col B))"

I have searched through various forums for similar problems but could not really find a solution, as I am not proficient with VBA to tweak the code as per my needs.

Any help would be really appreciated!

Thanks
 

More replies
Relevance 99.63%

Hi All,

My name is Diego.

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

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

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

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

Answer:Automatic Email from Excel based on Date in Cell

16 more replies
Relevance 99.63%

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

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

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

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

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

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

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

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

Set Wks = Worksheets("Work Site Info")

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

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

Answer:Solved: Automatic email from excel based on date

16 more replies
Relevance 99.63%

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

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

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

2 more replies
Relevance 99.22%

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

Hi,

I am in dire need of a solution wherein I want outlook to shoot an automatic email based on date from calendar or excel. Basically I have some users assigned some privileges which are assigned for a specific period. I need the mail to go out to them may be a day or two prior to the target date.

I came across this thread:
http://forums.techguy.org/business-applications/1129238-automatic-outlook-mail-due-date.html

I copied the code the in outlook VBA editor (i already have one script there and since being new to this i do not know if two scripts would be ok to have in there.... ...ScreenShot attached). However just to try when i ran the rule it gave me an error (screenshot attached).

I can't reply to the same thread since that is closed.

can you please help in this regards...

-regards,
gsg
 

Answer:Solved: automatic mail delivery based on date/time

9 more replies
Relevance 96.76%

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

Dear Friends,

I'm in a serious need of updating the respective teams with reminders on due dates of statutory compliance requirements. I've developed an excel workbook having three sheets namely Permissions, Returns and Records. All the three sheets are having due dates. (Workbook is attached for your solution please)

I need your expert solution in sending an e- mail message as a reminder to the person concerned before 15 days of due date with an optional text of my choice.

Its not possible for me to open neither the excel sheet nor the ms outlook application on a time basis coz my profile mostly deals with Industrial Relations aspects. Hence I've to be in the field 12/7 during the shift period and on call 24/7.

Awaiting early reverts.

Regards,

SNU.
 

More replies
Relevance 90.2%

Hi, I am really new to excel so I am hoping to get some help here. I have searched through the forum and tried several codes, but I was not able to run it successfully.

Basically in my excel file, i have a long list of documents with their respective expiry dates. I want excel to send me an email when it is 6 months before the expiry date.

I have uploaded a sample file on what my worksheet will look like.
I am using Microsoft Excel 2010.

Thanks!
 

More replies
Relevance 89.38%

Good day,

I was looking for someone to help me in this:

Please see the attached excel file, which automates Groupwise mails for due date reminder. However, it generates individual mails for each due items, whereas, I want one single mail with all due dates. How do I achieve it?
 

More replies
Relevance 89.38%

Hi ! This refers to the subject of "Automatic email from excel based on date", and relevant thread http://forums.techguy.org/business-applications/927675-solved-automatic-email-excel-based.html

This was fantastic. Only one issue remaining.
This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.
Awaiting kind help.
 

Answer:Need Help reg "Automatic email from excel based on date "

7 more replies
Relevance 84.46%

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

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

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

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

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

Hi all,

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

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

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

Please see the attached: CSCS.xlsx

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

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

Thanks, charli
 

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

10 more replies
Relevance 80.36%

Hi All.

Hi i have a excel file which has Serial No , Task and date of completion as 3 ccolumns.
I keep on missing the tasks. I heared from somwwhere that we can create automatic reminder in outlook based date picked from excel. I want the same. Example on 1, april, 2010 - if i have to go to my lawer, the in outlook on 1st-Apr-2010 a reminder comes , visit to lawer Mr. XXXXXX.

If any one can help that would be of great help.

Regards,
sam
 

More replies
Relevance 79.54%

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

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

More replies
Relevance 79.13%

I had made one excel to send automatic due date reminder mails via Groupwise (made with the help of your forums only).
The problem I am facing is as below:
[Also note, problem is not whether Groupwise or Outlook, problem is its generating multiple emails for each due item]

This is generating multiple emails and even the items not due are generating blank mails.
I would like to generate only one mail with different items different expiration dates.
After that group the identical addressees and compose one message with all the relevant data.

Right now its sending 3 mails as:

Mail 1: Please take notice of the following expiration date(s):
-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.
-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.
Sent at 17-Sep-13 11:11:04 AM

Mail 3: Please take notice of the following expiration date(s):
-Equipment C Job cccccc expiration date : 19-May-13 -121 days.
-Equipment C Job cccccc OVERDUE : 19-May-13 -121 days.
Sent at 17-Sep-13 11:11:04 AM

And the ones not due, going blank, i.e: the mail body (Mail 2) text reads:
"Please take notice of the following expiration date(s):
Sent at 17-Sep-13 11:11:04 AM"

What I wanted was a single mail with following in the mail body (Example):

" Please take notice of the following expiration date(s):
-Equipment A Job aaaaa expiration date : 19-Aug-12 -394 days.
-Equipment A Job aaaaa OVERDUE : 19-Aug-12 -394 days.
-Equipment C Job cccccc expiration date : 19-May-13 -121 days.... Read more

Answer:Request Help: Further study on Auto-mail for due date reminder

10 more replies
Relevance 78.31%

Hi folks,
I need a little help how to have reminder date from Excel xls into Outlook calendar.
It might be simple but our office IT guys couldn&#8217;t figure out so I need some help... I created a sample xls file with proper columns &#8211; attached. I am not a programmer so I am trying to figure out how to have automatic reminders 3 days before the &#8220;Start Date&#8221; which will be different for each item and there will be thousands of items on this list.

I appreciate your help.
Thanks

PS I forgot to attach my xls and do not see a way to edit and attached so I may have to attach it in a reply...
or you can download from here http://www.allreversephonelookup.com/excel/info.xls

 

More replies
Relevance 76.67%

Hello Friends,I am practical student. I in process to complete my mini project during internship. I need to make a auto reminder in outlook by using excel when due date arrived. It is one of challenging task because I am student in Major business and minor in IT.There are a lot of coding I'm try.But still not success.I hope can learn more. I also love to learn new thing.I hope somebody can help me to complete this task before I finish my practical training. Thanks and regards,Zulaika

More replies
Relevance 76.67%

Hello Friends,I am practical student. I in process to complete my mini project during internship. I need to make a auto reminder in outlook by using excel when due date arrived. It is one of challenging task because I am student in Major business and minor in IT.There are a lot of coding I'm try.But still not success.I hope can learn more. I also love to learn new thing.I hope somebody can help me to complete this task before I finish my practical training. Thanks and regards,Zulaika

Answer:How to send auto reminder in outlook if due date arrived?

Can you clarify something pleaseAre you looking to have a number of dates in Excel, which when reached/passed Excel is to create an email via Outllook and send it to someone?Can you provide an example of how your workbook is laid out

2 more replies
Relevance 76.26%

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

I am trying to create a code that will highlight an entire row the day before the date entered into a cell on that row.
 

Answer:Excel/Highlight Row Based on Date

use conditional format
add a formula

=cell with the date = today()+1
that will be true if the date

just to make sure we understand

today() is 7th August
the date in the cell is 8th august
so you want it highlighted

so cell = 8th
today + 1 = 8th
it highlights

now to highlight the row
use a $ on the cell that has the date and apply to the whole row

so if the date is in column C and say row 5

then
$C5 = today()+1

in the conditional format formula and apply to
$A$5:$Z$5
or whatever column you need

a sample spreadsheet would be useful , you can attach here
 

1 more replies
Relevance 75.03%

Excel 2010 IF stmt based on DATE value: I have a simple employee expense report that calculates mileage in cell D12 based on the date in cell B12. My formulas is as follows: =IF($B12>=DATE(2011,1,7),$D12*0.555,$D12*0.51). All mileage incurred equal to or greater than 07/01/11 should be calculated at $0.555 cents while all else should be calculated at $0.51 cents. I believe it's as simple as Excel not recognizing my DATE(2011,1,7), as the date 07/01/11... Help?

Answer:Excel 2010 IF stmt based on DATE value

You are right, Excel will not recognize DATE(2011,1,7) as 07/01/2011 sinceDATE(2011,1,7) means January 1, not July 7.The syntax is: DATE(year,month,day)=DATE(2011,1,7)=DATEVALUE("1/7/2011") will return TRUE.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 75.03%

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

Answer:Excel Macro - Date Based Protection

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

2 more replies
Relevance 75.03%

I need help please. I need to create a basic calender which shows the month on the top and when you click an arrow the month will change and a set of cells underneath will change. I intend to write into the cells details and when i click on the arrow to change the month the data will disappear. when I click on the arrow to go back a month, I will need this data to reappear. I would appreciate any help. I have created the arrows that change the month.

Answer:Need to change a set of cells based on the date (on excel)

Why not just create a new tab for each month and switch to the tab for the month you are interested in?Visually you would accomplish the same goal and you could go directly to any month you wanted.How have you created arrows to change months?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 75.03%

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

Answer:Excel VBA To Email Row Data Based on Date

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

14 more replies
Relevance 74.21%

I'm working in Excel 2013 and am trying to figure out the best way to calculate a date based on a start date, and a given day of the week. It cannot be based on the # of days from the start date, but on the day of the week the result date will fall on. The spreadsheet needs to be designed to be edited on a week-to-week basis, with dates changing accordingly.Example:Column M has a day of the week (currently General format - i.e. Thursday) - this is the day a product must be used, and it should remain the same week-to-week once it has been originally keyed. Column N has a date (currently in Date format - *3/14/2012) - this is the date a product must be used, and it will change from week-to-week based on manual entry.Column O has a day of the week (currently General format - i.e. Thursday) - this is the day a product must be delivered, and it will remain the same week-to-week once it has been originally keyed.Column P has a date (currently in Date format - *3/14/2012) - this is the date a product must be delivered, and it will change from week-to-week, a formula would be desired.Goal:M1 = "Thursday"N1 = 6/5/2014O1 = "Thursday"P1 = 5/29/2014 (7 days before N1 because it needs to be delivered the Thursday prior - will never deliver on the day of)M2 = "Thursday"N2 = 6/5/2014O2 = "Monday"P2 = 6/2/2014 (3 days before N2 because it needs to deliver the Monday prior)I know the following formula won't work because of the formatting with the day names, but it's the general concept:=IF(M2... Read more

Answer:Excel 2013 - How to calculate date based on day of week

Here is another option, if you want to rid yourself of the long nested IF formula in column P.I tried it on your two examples and it works.This is a small table that you can use with a =VLOOKUP() & =MATCH() formula

A B C D E F G H
1) Monday Tuesday Wednesday Thursday Friday Saturday Sunday
2) Monday 7 6 5 4 3 2 1
3) Tuesday 1 7 6 5 4 3 2
4) Wednesday 2 1 7 6 5 4 3
5) Thursday 3 2 1 7 6 5 4
6) Friday 4 3 2 1 7 6 5
7) Saturday 5 4 3 2 1 7 6
8) Sunday 6 5 4 3 2 1 7
Once you have the worksheet in place, in cell P1 use the formula:=N1-VLOOKUP($M1,$A$2:$H$8,MATCH($O1,$B$1:$H$1,0)+1,FALSE)Now drag down as many rows as needed.Not sure if this is faster or easier, but the formula is shorter.MIKEhttp://www.skeptic.com/

16 more replies
Relevance 74.21%

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

Hi all,

I would like to conditionally format the attached spreadsheet so that each alternating week is shaded on whole set of rows.

Also with our roster the week runs Thurs to Wed.

I've looked quite a bit into conditional formatting now. But this one has me stumped.

Thanks for any advice.
 

Answer:Excel: Format rows based on date and a few other specifics

7 more replies
Relevance 73.8%

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

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

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

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

5 more replies
Relevance 73.39%

Hello experts

I have an excel document with many sheets starting with sheet2

*** column_headers "enquiry#" in B6 and query_expiry_date in E6 (of every sheet)

What I am looking to do is, using sheet1 (which is unused at the moment)
dynamically return 3 pieces of information (in 3 columns, A,B,C for example)
based on expiry dates.

ie: if the expiry_date<today() then return sheet#, enquiry# and the date that expired.
this is for each enquiry and each sheet and if I can sort them in order of expiry date, that will be owsome.
Can that be done using lookup? or maybe better in VBA? a push in right direction or example
of code snippet is well appreciated.
Thank you
 

Answer:Solved: excel(VBA) returns data based on expiry date

12 more replies
Relevance 72.98%

Hi, I have a file in which i have to set the reminder as per selection of End Date. I have to fix 3 reminders (before 2 months, before 1 months & before 15 days). If in between saturday & sunday is coming the reminder will move the next working day. I have attached a sheet for you reference. i want to get a reminder mail without open the existing file or open any file in excel. Waiting for reply.
 

More replies
Relevance 72.57%

I'm trying to get with an automatic single click the current date in col A without having to enter each time - can you help

Answer:automatic current date in Excel 7

In it's simplest form, this code will place the date in any cell in Column A as soon as you select the cell. If you need to limit this action to a specific range, you'll have to let us know.Right click the sheet tab for the sheet you want to do this in and choose View Code. Paste the code below into the pane that opens, then select a cell in Column A.Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then Target = Date
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 72.57%

Our employees can sell such things as vacation time, for example, 1 day of vacation pay but their request must be submitted by a certain time if they are to be paid. We can tell them what day they will be paid based on the date they submit their request. This can be confusing for a supervisor to explain and I wanted to automate it on an Excel sheet.
Example:
1. Employees receive their regular check every Friday as well as a check for any time sold.
2. As long as they get it into us within 7 days prior to Friday they will receive their check the next Friday.
3. If itís greater than 7 days then it would be the Friday after next before they received the sold time check.
4. For example If an employee requested on May, 12th 13th, 14th, 15th, 16th, or 17th to sell vacation time that check would be received by the next Friday i.e. May 25th. However, if they turned it in on May 18th. 19th. 20th, 21st, 22nd., 23nd, or 24th. they would receive it on June 1st.
5. This pattern continues throughout the year. Note that weekends are included.
6. I think the attached will better explain what I am trying to do.
 

Answer:Formula in Excel for a Date to Remain Constant Based on a Range of Dates

I think there is something wrong in the way you explain it but, could be my interpretation though
I adden a column using the Days360() function which shows the nr of days between the request date and the 'friday' date, maybe you can use that resulty to compute the new value.
 

2 more replies
Relevance 71.75%

I have a column with dates in format yyyy/mm/ddI copy dates from other files that has the date format yyyy-mmI would like the dates with the format yyyy-mm to change to yyyy/mm/dd when I paste them in my column. I have already set the format in that colum to be yyyy/mm/dd, the way I want it but still the dates I copy does not changes their format.Please if anyone have some ab code that could help me with this do tell me and were I chould save it. I have already tried many ways but does not get it to work, and I can't download any converter to do the job for me. So Thank you for helping.

Answer:Change date automatic in an excel column

I copy dates from other files that has the date format yyyy-mmIs the other file an Excel file?After you have copied it, does it left justify in the cell?If you apply a Custom Format of General does it change into a number?MIKEhttp://www.skeptic.com/

18 more replies
Relevance 71.75%

Hi everyone

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

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

Dear Student

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

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

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

Answer:Solved: Excel Automatic Email on due date

16 more replies
Relevance 71.75%

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

Thanks in advance
 

Answer:Automatic Email using the date on the excel sheet

Hi,

See if this site helps.

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

1 more replies
Relevance 71.75%

Hello,

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

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

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

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

Any help would be greatly appreciated.

Thanks,
Brandon
 

Answer:Automatic Email From Excel When Due Date Is Approaching

Hi,

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

3 more replies
Relevance 71.75%

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

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

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

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

Hiyo.
To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?

Cheers.
 

Answer:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.
 

1 more replies
Relevance 71.34%

All

I have some files named for each day of the week (Monbackup.csv, Tuesbackup.csv, etc).

I want to copy Mondays file in the early hours on Tuesday morning to another server using a script - then the same for each day of the week.

Anyone know the best way to go about this? Am happy to use a batch file or PowerShell..

Thanks in advance.
 

Answer:Copy file based on date

Can you clarify; is the "date" of the file based on the name of it in its file name (i.e., your "Monbackup.csv"), or is it based on the save-date in its properties?

If its by the save-date in its properties, you can use the /mir option with Robocopy (I think if you're using XCOPY, you'd use /d (d for date) and then specify the date to use for that case by the entire option command "/d:MM-DD-YYY"). This will mirror a directory specified, copy the file to the new directory if it doesn't exist, and only overwrite the file if the source is newer than the copy.

You can do this in a batch file. You'd probably want something like:

ROBOCOPY sourcedirectory targetdirectory /option1 /option2 /option3

If you want to copy all folders and subfolders regardless of whether they're empty or not, you'd use the /e option. And to mirror and copy newest based on file property date, you'd use the /mir command. You can specify a log file output with the appropriate option. Exchange XCOPY with ROBOCOPY and /mir with /d:MM-DD-YYY as necessary.
 

5 more replies
Relevance 70.93%

I have a spreadsheet that shows all of the upcoming events at my work (I've attached a very basic example of the way the spreadsheet is set out).

When an event passes, I'd like the spreadsheet to automatically change the formatting of the rows that contain events that have already passed.

For example, today being 14.12.09, an event for yesterday (13.12.09) would be highlighted in red to show that the day has passed.

If anyone can provide any detail on how to achieve this, I would greatly appreciate it.
 

Answer:Solved: Conditional Formatting Based On Date Range In Microsoft Office Excel 2007

Select your data, then Format > Conditional Formatting.

Condition 1; Formula is:

=$A5<$D$2

Click Format > Patterns > red colour > OK.

Click OK.
 

2 more replies
Relevance 69.7%

Hi. I need help creating a .bat file that compares 2 same file on 2 different computers (server and client) on a LAN network..
It compares the same file on a server cpu, and there are 4 possible conditions i think:
- Same date on server > then do no action
- Older date on server> no action
- Newer date on server> action, sync using goodsync command line (i'll work on this)
- Connection with the server down > no action
So it's like this :
abc.txt on client 11/01/12
abc.txt on server 12/01/12

then sync

My question is, how exactly do i compare file on a LAN network?
thanks
 

Answer:Need help creating a batch file based on last modified date..

Welcome to TSG denywinarto. Hope you find some help here and take the opportunity to help others!

I quit doing Batch files a while back an went to vbs because it seems more robust. That said there is a vbs script in this thread (post #3) that you point at a directory and it makes a text file of file information including modified date and the full path to the file.

If you run this against your two folders (producing the two text file) then write a process that compares the two files and moves data according to your desires. You can do the file move and compare in vbs and not have to worry about the goodysnc piece.
 

1 more replies
Relevance 68.88%

I have the responsibility for keeping a record of the names of the volunteers who have volunteered to man the Visitor centre on a particular date.

The table I have created is

ID
Date
Special info
Morning
Afternoon

Basically this is just a diary.

A selection of this table will be printed off at regular intervals using a Query and then a Report The volunteers will add their names to the printed sheet for their chosen dates, morning or afternoon and the database updated on a weekly basis.

My question is this - can I automatically create the date that appears in the second field [Date] from the [ID] field or must I enter each date for each day manually.

Any other advice will be gratefully received
 

Answer:Automatic date creation Outlook 2010

welcome to PCR

please, stick with one thread on the same topic

https://www.pcreview.co.uk/forums/thread-4023580.php


I can't help, don't use the software.




 

3 more replies
Relevance 67.65%

I'm trying to open in Excel 2010 a file with .exf extension that is always a pipe delimited text file. I have set, using Windows file associations, to open this type of file with Excel. But, I would like for it to recognize that it is pipe delimited, so that I don't have to click on Delimited, Other, "|" to import the file. Any ideas? I also thought about using a macro to save some steps as well. Thanks for your help!
 

Answer:Excel import pipe delimited file based on file extension

Hi, welcome tothe forum
Macro is the solution, just start the macro recorder, give it a name and do what you do, stop the recorder and you have the macro.
Simple as pie
 

3 more replies
Relevance 67.24%

Hello Techguy!

I noticed a thread from earlier on, although I am still a little in the dark

I am making an interactive checklist with a deadline timer, and when this timer goes too low, I'd like excel to send an e-mail to me. Much like the thread in http://forums.techguy.org/business-applications/710581-automatic-email-alerts-using-excel.html.

I know it's in Danish, but this is my workbook.

Now the words don't really matter The text I would like to get e-mailed is the "I" culoumn.
Also please do not change the 2nd sheet (Ark2).

OS is XP, Excel is 2010 and I have Outlook 2010 as well.

Your help would be much appreciated!
 

Answer:Automatic e-mail from excel

16 more replies
Relevance 67.24%

hi everyone, this is my first post on techguy. I really need help with a Microsoft Excel spreadsheet. The workbook consists of gauge numbers and their calibration due dates.

Can someone please help me so that Microsoft Excel automatically sends a mail to a particular email address when the due dates are about to pass in a day/have already been passed?

The mail should state that the following gauges are due for calibration.
Any help will be appreciated. thanks
 

Answer:Excel automatic mail.

16 more replies
Relevance 67.24%

Hi,

Iam new user to this site and also New user to Excel application.I want your guidance in the below -

I want to know how to send automatic mails from excel(a range of cells to be copied and must be pasted in body of the mail and send mails to defined mail ids).
Is that possible?
Need - Every month i want to share some reports/values with some group of ids.So what iam doing is collecting the data from different sources and merging in one single excel.Upto here is ok with me..coz its diffiult to automatize collecting information from different sheets.
Then i will copy some range of values and sends to paste it in body of outlook mail and sends to the group of ids.For this i want solution.Is there any option in excel that i can click or run.so that it automatically sends that range of values to defined mail ids in body of mail.
It will be greatly helpful if i got solution to this question.
Iam using windows7 licensed version.MS Office 2013.I cant load any third party/non licensed version softwares in my laptop.

 

More replies
Relevance 67.24%

I have no idea as to where I should post this.

Web-based Outlook Mail seems to be down.

I just want any users of Outlook Mail to try it out.
Thanks.

Wyo
 

More replies
Relevance 66.42%

hi guys;
i want to make an automatic e-mail sending function into my excel worksheet,but i dunno ho to do it.
The basic thing is as soon as i put the social security number into one cell then excel should send an email this worksheet to me.
I would like to hear your ideas, thanks.
 

Answer:Automatic e-mail sending in Excel

Though I'm not quite sure what you're trying to do.
This articles by Ron Bruin an Excel MVP should be useful to you. Click on the link. http://msdn.microsoft.com/en-us/library/aa203718(office.11).aspx
and
http://msdn.microsoft.com/en-us/library/bb268022.aspx#Excel2007DifferentWaysEmail_SendingtheActiveWorkbookbyEMail
Please read the article and tell me what you think.
 

3 more replies
Relevance 66.42%

Hello all,
I am new to Tech Support Guy and to macros/VB code. I hope my question make sense! I have looked at other threads
but I don't even have the understanding of which bits of code are adaptable to my needs.
My colleagues and I run Office 2003 (with Excel and Outlook) and share a spreadsheet of client data to allow us
to co-ordinate our business with them.
At present our work is overly dependant on individuals remembering to action a task, and on paper lists in
different places. I want to try to bring us up to at least the 20th Century!
Our principal concern is when paperwork is due to expire and needs sending off by post to another team
to re-validate the paperwork (column M). I would like the spreadsheet to keep track of when paperwork is expired and to send
an e-mail alert to myself and my colleagues to make sure that we can get it sorted.
The e-mail would say something like:
subject: 'Charts for signing'
Main text: The charts that require new signitures are:
...and then a the rows of the spreadsheet listing the clients that have expired paperwork.
I enclose the spreadsheet with a couple of fake examples to try to explain what I mean. In this example I would want the
information in the bottom row (or at least the first three columns from this row) to be detailed in the email. I would not
have the ability to install software that could help with the process.
Each time we had re-validated paperwork sent back to us the spreadsheet could be updated... Read more

Answer:Automatic e-mail sending from Excel

Hi, welcome to the forum.

I'll have to think it over but meanwhile I've downloaded the file and will see if I can offer any ideas. Don't hold your breath
 

3 more replies
Relevance 66.42%

I have to many separate mail accounts used for my business. I forget to check them all. Can I convert my web based accounts, over to my outlook, but have mail sent from my different business accounts. Let me know if this is not clear what I'm trying to do. I need to keep my existing addresses. There printed on all my business cards.
Win98se, outlook200
 

Answer:Can I convert web based e-mail to outlook

6 more replies
Relevance 66.01%

Is there a way to have Excel 2007 to automatically send a document by e-mail (not an XLS file)?
 

Answer:Solved: Excel 2007 Automatic E-mail

The below is a cut-down of this code.

Note that (i) client is Outlook (ii) early binding requires setting a reference to Outlook in Excel's VBE before use.

HTH

Sub SendWithAtt()

Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim CurrFile As String

Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)

With olMail
.To = "[email protected]"
.Subject = "This is the subject"
.Attachments.Add "C:\Documents and Settings\Andy\My Documents\test.doc"
.Display
.Send
End With

Set olMail = Nothing
Set olApp = Nothing

End Sub
 

3 more replies
Relevance 66.01%

When using Ron de Bruin CDO_Mail_Workbook to email workbook from Excel, all works great when opening the file in Excel. However we have the need to post the file on the intranet and in some cases it will open embedded in IE. At this point we get the following error:

1004 Method 'SaveCopyAs' of object '_Workbook' failed.

It appears that since it is embedded the VBA does not know the ActiveWorkbook information.

Thanks
Josh
 

More replies
Relevance 65.6%

Hi,

I've noticed some similar queries on here and wondered if you could help me with a task i'm trying to achieve.

The attached spreadsheet is based on one I found elsewhere on the internet, and when a cell in the B column has a value above 200 it generates an e-mail based on the data. I've shown it in working form at the top of the sheet, and underneath is a test set of data for what i'm trying (and failing!).

What i'd like to do is change it so that rather than MyLimit = 200 (As it seems to be listed in the Macro/sheet view), it's triggered by any cells in Column C with a date on or before the date the spreadsheet is opened. When this happens i'd like it to say 'Sent' or 'Not Sent' as it does at the top of the page, but in Column D instead (I couldn't work out how to transfer it.

Lastly, when the e-mail is triggered it currently says:

"Hi Tom
The following client has now entered their expiration as of the stated date : 220
Regards,
Jake"

Whearas i'd like the expiry date from Column C placed in there, as well as the Client name just after "The following client, "

I've tried to edit it but so far had no luck, apologies for the lengthy message but hopefully these problems are quite easy to fix, any help greatly appreciated!

Thanks,

Jake

p.s. The next step is to work out how to get this spreadsheet to open automatically every day but I think that's a task for a rainy day... Read more

Answer:Excel - E-mail automatically sent depending on date?

6 more replies
Relevance 65.19%

Hi

I use windows 10, Excel 2016-32 bit (part of the MS office 365 kit).

I have an employee database made in excel, it has the date of birth of an employee,
based on the date i would like Excel to pic a random pic from a collections of pic stored in a second sheet of the same workbook, and email it as a HAPPY BIRTHDAY message to the email address of the employee and mark a copy to the organisation.

I use OUTLOOK 2016 ( part of the MS office 365 kit)

I am not a software developer and know not anything about coding.
appreciate all the help from this forum.. and thanks in advance for every feedback received.

Regards
sajumd
 

More replies
Relevance 65.19%

I have a new Windows 8 laptop, and I would love to setup my Hilton email account, but I can't figure this out for the life of me. I talked with someone at Level 2 of Help-Help, and he said that it should be possible, but of course, they aren't able to help because it's not a Windows 7 computer. Does anyone out there know how to help?

Answer:How do you setup Hilton's Outlook based mail on Windows 8?

Wat type of account is it?
POP? IMAP? Exchange?

2 more replies
Relevance 64.37%

Hello, I have been having trouble parsing out the code for an automatic notification system that will send out an email when a certification is about to expire. I keep getting error messages on one or two lines of code. I have attached the code that I have so far and a dummy spreadsheet of what I am trying to accomplish. The goal is to explore the automatic email notification option for the LEOSA Expiration date (column D), the Concealed Carry Permit Expiration (column G). For column ?D? and ?G ?, when an expiration is within 90 days the box turns yellow and sends a notification email. When the expiration is within 30 days it turns RED and an email notification is distributed. At each of these milestones (90 and 30 Day) the request is to determine if an ?auto send? type process can be utilized.

Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 7 Enterprise, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5-2500 CPU @ 3.30GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 3984 Mb
Graphics Card: Intel(R) HD Graphics, 1800 Mb
Hard Drives: C: 465 GB (400 GB Free);
Motherboard: Hewlett-Packard, 1495
Antivirus: Symantec Endpoint Protection, Enabled and Updated
 

More replies
Relevance 64.37%

I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th for each month of the year; 15-Jan, 30-Jan, 15-Feb, 28-Feb, ... 30-Dec.Cell C1 needs to return the number from A1:A24 based upon today's date compared to the date in B1:B24.For example today is 08/21/15, what number should be returned in Cell C1. It should be 15 as 08/21 is less than 30-Aug.message edited by jmichels

Answer:Return a number based on today's date compared another date.

Try this formula, see how it work for you:=INDEX(A1:B24,MATCH(TODAY(),B1:B24,1),1)This will work for most dates, but errors out if the Date is 01/14/15 or less.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 64.37%

Hi all,I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).Date Day Activity Income 02/01/2012 Monday Work (8) £48.00 02/01/2012 HMOT £5.00 02/01/2012 Peter Taylor 134024855 HMOT £5.00 02/01/2012 Susan Taylor 134023422 HMOT £5.00 02/01/2012 Steve Davy 13402737404/01/2012 Wednesday Work (8) £48.00 04/01/2012 HMOT £5.00 04/01/2012 Tom Thompson 134027410 HMOT £5.00 04/01/2012 John Ackroyd 134025131 HMOT £5.00 04/01/2012 Aftab Ilahi 134022546Above is an example of the sheet.In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.Please feel free if that doesn't make sense to ask questions.Thanks in advance.

Answer:acro to input date and print based on date range

Below is the code I have for a macro which I can't seem to get to work right.Thanks.
Public Sub PrintMonth()
On Error GoTo Proc_Error

Dim wksCurr As Worksheet
Dim rngTarget As Range

Dim strInput As String
Dim datInput As Date
Dim datStart As Date
Dim datEnd As Date

strInput = InputBox("input start date for month", "Enter date")
If strInput > "" Then
datInput = CDate(strInput)
If datInput > 0 Then
Set wksCurr = ActiveSheet
Set rngTarget = wksCurr.Columns(4)
datStart = WorksheetFunction.EoMonth(datInput, -1) + 1
datEnd = WorksheetFunction.EoMonth(datInput, 0) + 1
With wksCurr
If .AutoFilterMode Then
.AutoFilterMode = False
End If
.UsedRange.AutoFilter Field:=rngTarget.Column, Criteria1:=">=" & datStart, _
Operator:=xlAnd, Criteria2:="<" & datEnd
.PrintOut
.AutoFilterMode = False
End With

Set rngTarget = Nothing
Set rngDate = Nothing
Set wksCurr = Nothing
End If
End If

Proc_Exit:

Exit Sub

Proc_Error:

Select Case Err
Case Else
MsgBox "Error " & CStr(Err) & ": " & Err.Description
Resume Proc_Exit
End Select

Exit Sub

End Sub

3 more replies
Relevance 63.96%

just noticed that my location-based reminders FINALLY have a snooze button that allows me to dismiss the reminder for a period of time instead of the next time i'm at the same location. anyone else notice that yet?

Answer:Cortana Location-based Reminder

oops. i sent that thread w/o logging in. :)

2 more replies
Relevance 63.96%

Hello there,

I am pretty new to excel overall and facing a problem currently by setting up an automated process sending emails via Excel to Outlook.

*What*: I need to send out multiple cell values (which are calculated by formulas) on a weekly basis to 25 people.

Is there any (easy) automated process I could use? I've read online about using macros, but I am quite unfamiliar with that process.

I appreciate your help with this!

Thank you and best,

Regina
 

More replies
Relevance 63.55%

Is there a way to set Outlook to automatically receive new emails - and to send an audio alert that an email has arrived?
Constantly clicking on send/receive to check for new emails is time wasting.
Thanks.
 

Answer:Outlook e-mail - automatic receiving

In Outlook Express, you click on Tools > Options > General tab and you can select an interval for checking automaticly as well as a sound to alert you of new mail. I'm not sure the same options are available in Outlook.
 

3 more replies
Relevance 63.55%

Is there a way to set up Outlook 2000 to automatically reply to incoming e-mails? I'm going to be out of town for a while and I'd like Outlook to automatically send a reply to any incoming message stating that I won't be in the office.

Thanks!
 

Answer:automatic e-mail reply in Outlook

10 more replies
Relevance 63.55%

Hi everyone,

I want an email to trigger automatically when a due date is reached. Xcubed provided a great macro on a previous thread (see below). It works great, there is just one problem... I want the columns to update automatically as data is entered into other columns. This means that my "email address column" (Dim toList As String) contains a VLOOKUP function that go and find the email addresses if certain conditions are met.

If VLOOKUP found the email address it will send the email happily, but I get a runtime error 13 (mismatch error) afterwards, which I assume is because the rest of the cells contain the VLOOKUP function but no email address.

I am running more than one macro so this error prevents the others from running

Any ideas on how to fix this?

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(1).Select
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
toDate = Replace(Cells(i, 3), ".", "/")
If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Cells(i, 4) 'gets the recipient from col D
eSubject = "Ethics review EC" & Cells(i, 2) & " is due on " & Cells(i, 3)
eBody = "... Read more

More replies
Relevance 63.55%

WinME with XP Office. Outlook E-mail Handler.I am currently evaluating an anti-spam program which requires me to disable "Automatic Mail Checking". I have looked in Tools/Options and Customise but as yet I am unable to find it. Its probably there somewhere under a different name and wondered if someone could direct me to the bit I want. Thanks in advance.I have tried the Thread Search but no luck.

Answer:Automatic Mail Checking in Outlook

Tools/Options, Mail setup tab, Send/Receive button. Untick "Schedule an automatic send/receive every"

2 more replies
Relevance 63.55%

I use Internet Explorer 8 and Outlook 2007 SP2 but whereas I have set Outlook to check for mail every minute it doesn't do it (maybe every hour or two, I never see it!)

This is an inconvenience so can anyone please help me solve the problem?
 

Answer:Automatic e-mail checking in Outlook

You need to select
Tools
Options
Preferences
E-mail Options
and
Check Display a notification message when new mail arrives
Click Advance E-mail Options
and
Set your E-mail notification preference

You will now automatically be notified
 

1 more replies
Relevance 63.14%

Hello All,

Looking for some help setting up a spreadsheet to help notify my colleagues (through an outlook email) when our lab sample deadlines are overdue.

My excel capabilities are average at best, but I'm pretty good at taking instructions and applying them. I've spent some time looking online for a coincidence and have found several decent threads, however I need help specifically applying to my application.

I've attached a sample spreadsheet that I've just begun working on. I've used a datedif() >7 or >10 to highlight the samples which are 7 or 10 days overdue. I'm looking to send a notification to the emails provided when the datedif() becomes true (when the samples are overdue).

I'm also willing to totally start over if there is a better way to set the spreadsheet up in the first place.

Let me know what information you need from my end. Any help is much appreciated.

Emanuel.
 

Answer:Automatic outlook emails from excel spreadsheet

Have you already taken a look at the many similar post with answers and solutions?
I suggest you start there
 

1 more replies
Relevance 62.73%

Every time I receive an e-mail message in my POP3 account, Outlook sends a reply message to the sender stating that I'm on vacation.  Some time ago, I was experimenting to see if I could set up such a message and apparently I was succseeful.  The problem is I'm not sure how I did it and I would like to make it stop.  I have gone through all of my rules and alerts and can't find a rule which would do this.  I have run a search on my entire hard drive to find a file containing the words in the reply message that gets sent.  I have searched for .oft files and rwz files and can't find any.Does anyone have any suggestions?

Answer:Outlook - automatic reply to e-mail messages

I'm not sure what version of Outlook you have.  I am running Outlook 2003 and the way to turn it off in this version is to click tools, Out of Office Assistant, and make sure the I am currently in the office radio button is selected.  Hope this helps.

6 more replies
Relevance 62.73%

How do I stop Outlook from checking for new mail as soon as the program loads? I could do it with OE and Windows Mail. I only want Outlook to check for new mail when I click the Send/Receive button.

Answer:Outlook 2007 - Automatic Mail retrieval

This may help
How to Make Outlook Send and Receive Periodically and at Startup - About Email

9 more replies
Relevance 62.73%

I can manually "export" my Outlook 2010 mail to a specific destination using Outlook's features.
But I want to schedule an "automatic" backup instead, weekly or monthly, etc.
My OS is Windows 10.
I tried Windows 10 Task Scheduler but cannot seem to have this do it for me.

Anyone know how to backup Outlook 2010 mail on a regular automatic basis?
Anyway to do this within Windows 10 or must one buy a software program too do this?

Thank you,
Tegiro

Answer:Automatic Backup OF Outlook 2010 Mail

Just include .pst in your regularly scheduled Windows backups.

2 more replies
Relevance 62.73%

Dear All,

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 heads-up your project status".

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.

Really appreciate any help,

Thanks
 

Answer:send a mail using outlook when the due date is reaching

members, please help
 

2 more replies
Relevance 62.73%

Cheers everyone, i look some many topics in your forum about the automatic alert from an Excel file and try so many files for testing for me and none of this file send an email automatically when a date is approach.But the macro work when i play the macro.Is there a problem with my system ?

Thanks in advance
 

Answer:Automatic Alert from an Excel file

7 more replies
Relevance 62.73%

Hi guy, I got some problem with my excel format function is only working on certain cells and I cannot see any difference in the way the cells that won't change to the desired format.
I am selecting 4th march 2010 but it refuses to change certain cells they remain 04/03/10 and some changed to MM/DD/YY which is give me the wrong detail. Do you have any solution for this ?Could you help me to slove it plz. Thank you very much.
 

Answer:Cant changed the date in excel file.

16 more replies