Computer Support Forum

Auto Email reminder from Excel Sheet

Question: Auto Email reminder from Excel Sheet

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

Relevance 100%
Preferred Solution: Auto Email reminder from Excel Sheet

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

Relevance 99.22%

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

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

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

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

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

Im wondering if it is possible to do this before i start trying...

I recieve an email containing an excel sheet containing several peices of info such as:
Name
Surname
ID
Etc Etc... Now when i open this.. i need the information posted into specified columns in a new excel document where it will have
NAME | SURNAME | ID |
-------------------------------------------
STEVE NORTH 01874
Any help given appreciated.
 

Answer:Excel - Auto export data into specified excel sheet

6 more replies
Relevance 78.72%

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

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

More replies
Relevance 77.9%

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

Hi,i have a worksheet with lots of tasks records, some completed, in progress, overdue, etc. can vb auto copy the entire row over to a corresponding status sheet if the status column answer to criteria?sheet1 -Maincolumn a =taskscolumn b =statusstatus drop-down list is in-progress, completed, pending, overduesheet2 -in_progresssheet3 -completedsheet4 -pendingsheet5 -overdueanyone can help?

Answer:excel-auto copy a row to another sheet

You should be able to do it using VBTo get Help with VBOpen ExelClick the Microsoft Office Button , and then click Program Name Options, where Program Name is the name of the program you are working in, for example, Word Options.Click Popular, and then select the Show Developer tab in the Ribbon check box.If you need more help I suggest you repost in the Office Software section.

5 more replies
Relevance 77.08%

I am looking for a code to auto sort in ascending order some division numbers in column H of my excel sheet. The information that needs to be sorted is located from B9 to H36. I do not want it to sort column A at all.

Answer:Auto Sort Excel Sheet

We need a little more information before we can offer a possible solution.1 - In your first sentence you say "auto sort in ascending order some division numbers in column H." In your second sentence you say "The information that needs to be sorted is located from B9 to H36."So which is it? Column H or B9:H36?2 - What will be the trigger for this "auto sort"?3 - What is in the sort range? You used the words "division numbers" which to me implies formulas. If that is the case, then I believe that the formulas will need to be replaced with the values before the range can be sorted.Perhaps a small example of your data would help. If you are going to post any example data, please click on the following line and read the instructions on how to post data in this forum.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 77.08%

I have a main database on one worksheet with the different types of sectors i.e. health, finance and whether they are active or not.I wish for the information to be copied to another sheet dependant on the sector i.e all health to health tab and all finance to finance tab regardless of whether they are active or not and then for all active to go the active tab and all non active to go to non active tab, regardless of sector.Any clues.

Answer:Excel - Auto copy a row to another sheet

You didn't label the columns in your example, so I am assuming that they are Columns A & B.Right click the sheet tab for your Main sheet, choose View Code and paste this code into the window that opens.Then go back to your Main sheet and change some Drop Downs. That row of data should be copied as you requested.Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if Change was made to Column A or Column B
If Target.Column = 1 Or Target.Column = 2 Then
'If True, then determine the next available Row in Column A of Target sheet
nxtRw = Sheets(Target.Value).Range("A" & Rows.Count).End(xlUp).Row + 1
'Copy Row from Main sheet to Target sheet
Range(Target.Address).EntireRow.Copy _
Destination:=Sheets(Target.Value).Range("A" & nxtRw)
End If
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 77.08%

I have a worksheet contains Sheet1 and Sheet2:Sheet1: contains Data about foreign workers, my reference to each worker is the Passport Number, some passports will expire soon or later,So, the main question is (How can i copy full row to Sheet2) when the passport is less than 1 year or less than 365 days FYIPassport expiry date identified as "pp_expiry" & start from cell No. (L7)Passport number identified as "pp_no" & start from cell No. (K7)thank you very much

Answer:Excel - Auto Copy A Row To Another Sheet

A macro could be written to copy the rows but something would need to trigger it. That would be based on when you want the copy to occur. The code could be run manually or it could be triggered by an "event" such any change to the worksheet, the opening of the worksheet, the saving of the worksheet, etc.In addition, since this a copy, and not a "move" (cut/paste) we would need a way to prevent the code from copying the same rows multiple times. This could be easily accomplished by putting a "flag" in unused column of Sheet1 once the row is copied.Any additional information you could provide related to how you use the worksheet might be helpful.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

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

Hi all

Is there a way (using functions/formulas) to have Excel automatically duplicate the contents of a row on one sheet onto another sheet within the same workbook if text in one column of the first sheet contains a certain word? And if so, how could this be achieved?

I have attached an example workbook to help explain what I'm trying to achieve.

What I want to end up with is when I type text in any row of the Master sheet, I would like the entire contents of each row to automatically be repeated on the worksheet of the same name (as per column O). For example row 5's contents from the Master sheet would duplicate into the sheet named Accommodation. In addition, should the details ever change in the Master, this would need to be reflected in the individual sheets also. My only concern is that I'd like the individual sheets to fill from the top rather than match the exact row number position from the Master, ie row 5's contents to be placed into row 2 of the Accommodation sheet seeing as it's the first occurrence, and row 6's would go into row 3 etc.

I hope that all makes sense, please let me know if not.

I'd be hugely grateful for any suggestions & help. Thanks heaps.

Sue
 

Answer:Solved: Excel: Auto duplicate row contents from 1 sheet to another if col contains a

11 more replies
Relevance 75.44%

Hi,I want to protect my speed sheet but still use the auto filter, I use ecxel 2000 at work and when I protect the sheet the auto filter will not function

Answer:protect excel 2000 sheet and still use auto filter

I don't think there's any way around that.

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

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%

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%

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%

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
 

Answer:Set email reminder base on Excel

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

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

How can I send just one sheet from a workbook of several sheets by email ? I am sure it can be done (as I have received a view of just specific cells before). This is for invoicing, where I have linked sheets showing similar date (for proforma and final invoice so they need to work together but not be sent together) I don't want to send the whole workbook/(These templates in turn will link to other workbooks)please

Answer:sending excel sheet by email

Save the specific sheet you want to send as another, different, workbook.

10 more replies
Relevance 72.57%

how to separate email ids in excel sheet...from name,designation,email id in one line..i want to know is there any simple method to separate emails.Without copying one by one

Answer:how to separate email ids in Excel sheet

open the list " name,designation,email " as .cvs.Excell will ask what character "seperates" the values. In your case Comma??Excell will display the values in separate columns, one row per listed line

2 more replies
Relevance 72.57%

hi everyone,
how can make a rule in outlook that if i get an email from [email protected] then look into the email check for the words example id when you got it highlight the whole row and copy it to an excel spreadsheet?
 

More replies
Relevance 72.57%

I want separate email ids in excel sheet like thisI have email ids like this "[email protected]" and I want to remove last two words "au" and want like this [email protected] one I want to separate email ids by name ( Not domains example * gmail.com) for [email protected]@[email protected]@[email protected]@yahoo.comI want only " ME" email ids only [email protected]@yahoo.com

Answer:I want separate email ids in excel sheet

For your first requirement, there are a numerous solutions, depending on what the rest of your data looks like.Based strictly on your example, where there are 3 characters that you want to eliminate (.au) this will work. It simply returns three less characters than the original string, starting from the left:=LEFT(A1,LEN(A1)-3)If the part you want to strip off might contain something other than 3 characters, then we need to find the 2nd dot in the string and remove it and everything after it. This formula should work regardless of how many characters follow the 2nd dot.=LEFT(A1,FIND(".",A1,FIND(".",A1)+1)-1)For your second question, your text doesn't match your screen capture, so I don't really know what you are looking for. Your text says "I want only "ME" email ids only" but your screen capture shows [email protected] in the same column as the "me" emails.What exactly are you looking for?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

5 more replies
Relevance 72.57%

I want to add a list of email addresses to an excel document. The email addresses are separated by commas only so when i paste them in they all end up in one cell. Help!!?!!

Answer:add email addresses to excel sheet

What your looking for is Text to ColumnsJust use Delimited, and select CommasMIKEhttp://www.skeptic.com/

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

Hi All

I am trying to email a worksheet (or tab) from excel 2007 (SP2) (OS W7). Using Outlook at the emailing faciliy.

Example 1 workbook with 7 work sheets, each worksheet needs to be emailed to a different person with a different message. Pretty sure it can be done with a marco but would rather just for the moment do it manually

Thanks
Martin
 

Answer:Email an excel 2007 work sheet

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

Hi is there a way to send an automatic email of a workbook on a certain date?

For example workbook 1 needs to be sent at the end of every month automatically when opened.

thanks
 

Answer:sending excel sheet via email autmatically

"the end of every month"

Is that the last day or the last working day? If the latter, define "working".

The Analysis Toolpak add-in (you'd have to check if you have it installed) has some useful additional functions, such as EOMONTH.

Today (20th March), the formula:

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))

returns 8. That probably means that there are 8 working days left this month, including today. Of course, this month is a bad example because of Easter; NETWORKDAYS' 3rd argument "Holidays" is something you'd have to plug in.

Some very basic "workbook open" code could check the value of such as formula and act accordingly (i.e. if formula result = 1, do x-y-z). You might also need to set a flag to handle the workbook being opened > once on the "last" day.

Beyond that (or maybe even instead of), Ron de Bruin has lots of snazzy SendMail stuff.

HTH
 

2 more replies
Relevance 71.75%

Hi all,

Newbie here just trying to see if any of you excel wizards have some help for me...

So, I have this excel spreadsheet (2007) that I'm trying to make as efficient as possible. (I have a smaller, revised version, but it's still too big to attach?) You can see the little amateurish things I added, such as linking to other sheets in the workbook and drawing data from the main data pages, etc. (everything I know about excel, I learned by googling the question and looking at forums like this...)

Anyway, the final thing I'd like to do is to be able click a button or link that will open an email that's automatically addressed to the right company and also includes the info from that company's sheet in the body of the email. An added bonus would be if the subject could change with the current month. Is this even possible? I know this is really hard to do without seeing the spreadsheet, so if anyone knows how to make the spreadsheet smaller so I can attach it, please let me know...it's still 1.01 MB and I already cut about 80% of the material out of it! Or I can email the spreadsheet separately for anyone to look at as well...

Also, I am very, very inexperienced with codes and macros, so if that is the solution (which I assume it is), please pretend you're talking to a dummy when explaining that part.

Thanks everyone, I appreciate any suggestions you have!
 

Answer:Trying to streamline my excel sheet with an email feature

6 more replies
Relevance 71.34%

Hi:
Using excel 2010
I have a master list of items,product code, and price.
I would like to be able to use a separate worksheet and be able to use a drop down menu/list to select and add individually to my worksheet.
Example, there mmight be 1000 items in my master list and I might like to select/import as such 11 items into my worksheet.
Any suggestions?
 

Answer:Solved: Importing selected rows from Excel sheet one to Excel sheet two

6 more replies
Relevance 71.34%

this is how I have all my data. there are more than 200 contact info. Everything is in column A and I'm trying to retrieve only the email addresses and paste them in another column. How can I separate the email address???? COMPANY NAME ADDRESS Phone: Fax: Email: [email protected] Web: www.test.comI have excell 2010

Answer:How to extract/retrieve email addresses from an excel sheet?

Enter this in B1 and drag it down as far as you need:=IF(LEFT(A1,5)="Email", RIGHT(A1,LEN(A1)-7),"")Select Column B and do a Copy...PasteSpecial...Values to eliminate the formulas and leave the text.Sort Descending to bring all of the email addresses to the top of Column B.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 71.34%

Hello Everyone,

Let me tell you about myself, I am Rajesh, working in a private organisation. I am doing my MCA post graduation. I have to do a repeated task everyday in my office, that sending an excel sheet to all my team members in TO field and two members in CC field. I use Outlook 2007 and Excel 2007. I searched the forum for similar threads they exist I think, but I couldn't get what I need. Let me explain you all what I am going to do everyday

There is a network drive in which I need to take list of sub folders available in four different folders and create four text files and I need import it in a single Excel sheet, after completing this the excel sheet must be saved as "<DD MMM YY> Archive" (Current date, month and year) and emailed to 9 team members(TO field) and 2 members(CC field). It is not necessary to create a new excel file everyday, just overwrite it with previous one.

I have found how to get data automated to excel from a network drive, that is I use batch file that runs commands to get the text files using a VBS(windows scheduler).And then get the data by using Import Data from Text option in excel, But I don't know how to make automated emailing as easy as possible with current date, month, year in excel sheet name.
I hope I am clear in my question, please ask me If I need to provide more information. Any help would be appreciated.

And I found this forum by googling for the above task, I read many posts and seen here member... Read more

More replies
Relevance 71.34%

separation into offical and personalHi,I am using Excel to main my database which contains email ids combination of official (*@company.com) and personals (*@gmail.com).i want to spate these data into as official and personal

Answer:i want separate official & personal email ids in excel sheet

Is gmail.com the only personal domain you need to be concerned with or are there yahoo, hotmail, etc. addresses also?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 71.34%

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

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

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

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

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

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

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

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

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

More replies
Relevance 71.34%

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

Code:
Public Sub email()

Dim SubJ, Recip As String

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


ThisWorkbook.SendMail Recip, SubJ

msgbox "Email Sent"

End Sub

 

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

6 more replies
Relevance 71.34%

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

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

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

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

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

Thanks in advance!
irishki
 

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

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

3 more replies
Relevance 70.52%

Hi,

I am new to VBA in Excel. I am trying to accomplish the following:

Have the following operation triggered by having the user click a "submit" button, then
Copy the active sheet to a new workbook
Save the new workbook to the user's desktop
Email the saved file to a standard email address, but with an editable subject line
(If it is possible to skip step 3, and still do step 4, that would be acceptable.)
I would appreciate any help that can be offered. Again, I am quite new to VBA, so simpler is better.

Thanks!

MW
 

More replies
Relevance 70.52%

Hi Everyone!

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

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

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

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

I'd really appreciate any help,

Thanks
 

Answer:Send email reminders thro Thunderbird from Excel sheet

16 more replies
Relevance 66.42%

I need to copy n number of rows from a sheet in my local machine to a sheet in fileserver.
My requirement is - if I select last 2 rows in the sheet in my local machine I need the rows to be copied after the first blank cell in the sheet in fileserver.
Also it would be helpful if the macro code is only in the local sheet and not in the fileserver sheet.

I am a newbie to macros pls help....
 

More replies
Relevance 66.42%

Hi,

I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.

Thanks,
mihaufo
 

Answer:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet

8 more replies
Relevance 66.01%

Hi,

I need to paste data from one worksheet that is unfiltered (not hidden) onto a worksheet that is filtered. I need to paste onto visable cells only, ignoring the hidden rows. Currently, my data is being pasted onto both visible and hidden rows.

I know its possible to paste only visable data, ignoring hidden cells, but I need to do the reverse of this. Pasting non hidden data onto only visible cells. And I hope I am explaining this well.

Please do not suggest a vlookup because this would take entirely too long due to the nature of my data and this project. Also, I am not skilled enough to do code, so keep it simple...

Suggestions please?
 

Answer:Solved: Pasting in excel from unfiltered sheet to filtered sheet

6 more replies
Relevance 65.6%

Hi,
I have written the below code to check the column in sheet "A" and if it matches any of the conditions, I copy it to sheet "B". But I also want to delete the whole row (not just clear its contents) from sheet "A" after copying it to sheet "B". I tried a lot of codes for that, but none worked!
Please help..

Sub a()

Sheets("A").Range("A1:J3").Copy Sheets("B").Range("A1")


Dim i As Long, iMatches1 As Long, iMatches2 As Long
iMatches1 = 3
For Each cell In Sheets("A").Range("F:F")
If (cell.Value = "x") Or (cell.Value = "y") Or (cell.Value = "z") Or (cell.Value = "u") Or (cell.Value = "v") Or (cell.Value = "w") Then
iMatches1 = (iMatches1 + 1)
Sheets("A").Rows(cell.Row).Copy Sheets("B").Rows(iMatches1)

End If
Next
 

Answer:Hw to delete a row from an excel sheet after copying its contents to another sheet

hi
after
Sheets("A").Rows(cell.Row).Copy Sheets("B").Rows(iMatches1)
you type
Sheets("A").Rows(cell.Row).Delete

i hope that i've answered you
 

3 more replies
Relevance 65.6%

hi guys...i posted regarding this file a few times...and is still coming back to haunt me!

i need some help here....especially now that the ppl at the office need the information to be drawn out differently.

ok. here's the scenario:

i have an excel file with 8 sheets

"Questionnaire" sheet is to be filled out by a rep and has some drop down lists to populate the "POtemp_NY" sheet.

ampaper, edmar, sterling, stoneglo, strauss and uneeda are all venders with lists of their products...with their prices.

"POtemp_NY" is the master sheet where all the information must show on

The problem is, i need to have the "POtemp_NY" sheet populate the description, units, and price when someone enters a value in the "Units" column on a vendors sheet. Also, i would need the "POtemp_NY" sheet to continue to list the products on the next lines if there are multiple products with values in their "Units" cell.

Any help would be GREAT!!!!

Thanks in advance!

the file is attached for reference! thanks!!!

- mark
 

Answer:Solved: excel: populate sheet from list (fr another sheet)

16 more replies
Relevance 65.19%

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

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

Firstly i would like to say hi to everyone and thanks in advance for any advice / help.

Here is my problem...

I have a spreadsheet and it contains a list of our employees and when any of their work related certificates expire. What i would like to do is create a script??? or something that will run and send an email to a selected list of people informing them that a certificate is about to expire.

The spreadsheet is excel format and the email software my work uses is Groupwise.

Also something to note would be that there may be multiple people who have expiring certificates at the same time, would it be possible to send just one email or would individual emails be the only way to go.

I have attached a very simple spreadsheet so you can get a better idea of what i mean.

Once again, thanks guy for any help you can provide.
 

Answer:Auto Email from Excel

why oh why do spamers exist
 

2 more replies
Relevance 65.19%

Hello,I have an excel sheet whith 2 sheets with coloums A-BK. I need to combine these two sheets together into a 3rd sheet. However I only need coloumn A-K in sheet 3. Also, everytime when we change something or insert a new row in sheet 1 or 2 it needs to be updated automatically in sheet 3.It would be really great if you could help me out or you could write a macro code for me. Your answer is very much apprepriated. Thank you.

More replies
Relevance 64.37%

HI All,

Can any one help me on this.

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

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

Help on this .

shishir kumar
 

Answer:Excel to auto send email

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

1 more replies
Relevance 64.37%

Hello all;

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

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

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

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

2 more replies
Relevance 64.37%

Hi I am trying to set up a Client data base and I would like to be able to email everyone in the company when a change has been made to columns B,D,E, and F. I plan on having different tabs for each company and when I update the companies folder and change one of those four columns, Iím looking for it to send out an email alert saying "CompanyX Contact Manager Client Folder Has Been Updated".

I have been trying my best to figure it out with info I found on here but I am not very good with Code and any help will be much appreciated
 

Answer:Excel Auto Email Code ?

16 more replies
Relevance 64.37%

I have a little calculator of sorts that hides rows and information based on entries in cells A1 and B1 on sheet 2. Problem is things get messed up when another user returns to this sheet and cannot see data previously entered in these 2 cells due to conditional formatting which hides needed rows. If those 2 cells would always revert to zero when saving or going to another sheet all will be great. I'm not an expert so please go easy on the lingo.What I'm doing with the spread sheet is to figure our serial numbering and labeling requirements will is based on the factory location and product qty required. Sheet one is where the serial numbers are entered by the used based on sheet 2 selections (which factory and how many widgets required.)This one still has us stumped so I'll clarify my issue. I have a 2 sheet excel file; sheet 1 users may make perm changes on but sheet two only temp changes may be made. Ideally when a user leaves sheet 2 anytime their changes (like a check box that was checked or the qty of a product desired) return to their original values (unchecked or 0.)Hopeful.  J

More replies
Relevance 64.37%

Hi,

I want to copy the original sheet into another sheet.

I have sheet1 tab.

if I use this code:
ActiveWorkbook.Sheets("Sheet1").Copy after:=ActiveWorkbook.Sheets("Sheet1")

it created sheet1(2). but I want to specify my tab name.

if I chnage it and run:
ActiveWorkbook.Sheets("Sheet1").Copy after:=ActiveWorkbook.Sheets("helloworld")

It fails.. error comes up.

How do I make it work?

Thank you
 

Answer:Solved: EXCEL: copy sheet to another sheet

Hi sk0101,

rename it after copying:-

ActiveWorkbook.Sheets("sheet1 (2)").Name = "helloworld"

lol
 

2 more replies
Relevance 64.37%

at work i'm looking to create a weekly stats sheet with each sheet tab representing a week. i'm looking to have 52 sheets.each week will have a carry over figure that i want to automatically populate into the next week.e.g. cell a1 from sheet 2 is copied from cell b1 in sheet 1, cell a1 from sheet 3 is copied from cell b1 in sheet 2.i can of course repeat the reference to the previous sheet manually but i was wondering if there was a quick way of setting up the sheets so that the reference to the previous sheet and specific cell is done automatically?is there also a quick way to set up all 52 sheets rather than copy 51 times?tia.

Answer:excel figure carry over from sheet to sheet

Yes it is possible using a macro. Is it just those cells that need to be copied. What are the sheet names? Do you need to copy the FORMULA or the VALUE in A2?In other words perfectly doable but more info needed.

1 more replies
Relevance 64.37%

Hi,

I have an application called BT Billing Analyst. This application has an option to open a report in Excel.

When I used Excel 2007 the report data opened in sheet 1 of an Excel workbook and some information on the report was put on sheet 2.

I recently upgraded to Excel 2013 and now when I open the report in Excel the report data is populated on sheet one but after that the first 25 lines get overwritten by the information that should go to sheet 2.

Is there any way I can fix this?

Thanks
Paul
 

Answer:Excel - Sheet 2 data getting written to sheet 1

You may have to go to the BT Billing vendor to resolve this. Perhaps an updated version is available. 2007 is xml based like 2013 so I am surprised there is a conflict. But I don't think there is anything in Excel you can do to resolve.
 

2 more replies
Relevance 63.55%

Hi,

New here. I dug up a thread that Zack Barresse solved many years ago. I am looking to do the exact same thing. The link to the thread is below. My file is infinitely more complicated than what that user was asking for so I need a bit more help tuning the VBA. Link: http://forums.techguy.org/business-applications/710581-automatic-email-alerts-using-excel.html

Some specifics:

- I am using Outlook not Express
- Excel 2007
- All the functionality is complete for monitoring several live streams of securities data with several trade indicators.
- It is consolidated onto one sheet for manual monitoring (Picture below). Basically takes copious amounts of data and reduces it to just IF and AND functionality for the triggers for easy use from all the other sheets.
- The workbook will be open and running/refreshing on its own 24/7 as it is now.

I am a busy guy, I just need the VBA to automatically email me remotely when any of the 7 currency pairs causes a trigger when I am on the go. I can log trades from an app on my phone.

One other hurdle would be that if say (Using percentages to keep it simple) that a trigger would be if something reached as high as 80% to send the notification email. But where the system refreshes every 60 seconds it shouldn't send another notification each time it remains at or above 80%. Just the once. It may remain there for hours and that is a lot of emails.


Thoughts? and many many thanks in advance.
 

Answer:Excel - Auto Email based on cell value

10 more replies
Relevance 63.55%

Firstly Hi,
I'm Hodge and this is my first post on this forum, please (HELP)

I have been looking around the various forum's trying to figure this out myself but with little success. There are many variants of this problem throughout these forums with many solutions, but none of which i've been able to adapt or use.

I basically run a diving team with 27+ divers and have various spread sheets to manage the team, from equipment servicing to personnel run out dates. I have been trying to find/create a Macro that will automatically send me an email, with Cc's option, when cells in column M & O turn yellow or red. Then copy all the data within that row and email the address in column P as an attachment. I have looked at Ron de Bruin's code, and tried to adapt it without success. Once I have the correct code, I believe i will be able to adapt it to most, if not all of my spreadsheets.

Hopefully someone has used this type of code before for the same reasons, Sorry must mention that I'm working on MS Office For Mac 2011, but don't think the process is much different. I don't really know much about VBA, so any help will be welcomed.

I've attached one of my spreadsheets just incase.

Thanks in advance for any help you may be able to offer.

Hodgey
 

Answer:Solved: Auto Generated Email in Excel

16 more replies
Relevance 63.55%

Hi, I have download a template from http://www.rondebruin.nl/sendmail.htm and make some modification to create a tracking program for own use. Now, I would like to add in some features to my tracking program which hope it will serve better. I have few questions here which would like to seek for the expert support.

Refer to the attachment:
1. How could I make the email to send out the OPEN and OVERDUE items only(excluded the closed items)?
2. I have set the conditional format, it work in the Excel but not work in the email. How could I solve this (It's just shown differently)?

Hope to hear from you soon.
Thanks in advance.

Regards
Ykit
P/S : I am using Excel 2007 and Outlook 2007.
 

Answer:Solved: Excel - Auto Email Problem

16 more replies
Relevance 63.55%

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

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

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

2 more replies
Relevance 63.55%

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

Answer:Excel or Access to auto send email

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

5 more replies
Relevance 63.14%

Hi Guys,

We create basic spreadsheets to keep track of tasks and reviews. Often spreadsheets have different formats with one thing in common. Each will have a due date.

I would like be able to create Macro / VBA to send email and/or task for due dates in multiple excel sheets.
Using MS EXCEL2007 and OUTLOOK 2007
Reminder to be sent at trigger event dates 14 days,7 days, 2 days before due and every day overdue
Due dates could get color coded as they approached deadline. For e.g Over 14 days (nil), 14 days (green), 7 Days (orange), 2 days/ overdue (Red).
Due dates could be always put in column A for example for simplicity and consistency if necessary or perhaps it could work of Column heading (DATE DUE).
Also for simplicity emails would only need to go to 2 people. From there we can forward to relevant people after being aware of task ourselves.
When multiple trigger events occur within same Spreadsheet, Have the one email rather than 20 if twenty occur on same day. Different spreadsheets emails are fine.
A check that if email has been sent it will not send another email till next date trigger event.
A 'Send Email' button for all trigger events and another Send selected email' button for one or more selected rows only.
Text in subject line email could be Excel file name
Text in body of email would include Excel file name and Title row and trigger event row.
Unfortunately i have limited experience with Macro's / VBA. Have checked forum... Read more

Answer:General auto-email deadlines: excel - Outlook

There are quiet a lot of posts with similar quetions, maybe you should take a look at these.
When you open your thread you can see the list of 'similar threads' below.
 

1 more replies
Relevance 63.14%

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

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

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

Thanks In advance!
 

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

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

1 more replies
Relevance 63.14%

Hello Everyone,

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

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

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

Regards,
Nilesh Jagtap
 

Answer:Excel - Trigger Auto Email Depending on Due Date

Welcome to TSG niljag!

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

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

1 more replies
Relevance 63.14%

Hi guys,

Really need your assistance ..
Attached is example for my problem.

I only know how to set the parameter for the 'status' (using condiitonal formatting), but i dont know how to create the code in VBA to create emails on certain condition .. I'm not used to VBA, and still learn about it (my head was spinning lately).

So, I wish someone here could help me ..

Regards.
 

Answer:Solved: auto email based on certain condition in excel

16 more replies
Relevance 63.14%

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

Thank you so much!
 

Answer:Auto send an email based on date in Excel

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

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

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

2 more replies
Relevance 63.14%

Hello Everyone,

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

For email i am using;

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

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

Answer:Excel - Trigger Auto Email Depending on Date

Hi welcome to the forum.

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

Sub CheckSomething()

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

End Sub

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

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

1 more replies
Relevance 62.32%

Hey everyone,

I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.

I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.

What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.

I send emails from the road on my Android phone.

Any ideas? Thanks!
 

Answer:Solved: Outlook Email to Auto-Fill Excel spreadsheet

8 more replies
Relevance 61.91%

[timestamp=1173309904] :-?I have an excel spreadsheet that has about 30 sheets. I have separate accounts on each sheet but often need to see the running balance of each individual sheet. I would like to take the formula from sheet 2, 3, 4 etc and have it show up in sheet 1. This is what I tried: I want the total amount on sheet 2 in cell E13 to show up on sheet 1 in cell D1. And whenever I make changes to the totals on sheet 2, cell E13, I would like the new total to automatically show up on sheet 1, cell D1. I went to sheet 1, cell D1 and entered =2!E13 and hit enter and another window popped up browsing my files. I'm totally lost as to how to do this.Help???

Answer:Excel help regarding formulas from sheet to sheet

The formula in cell D1 on Sheet1 should be =Sheet2!E13.  One way to enter such formulas is as follows: Click cell D1 on Sheet1 to select it.  Hit the = sign.  Now, click on the Sheet2 tab and then on cell E13 on Sheet2, and then hit Enter.

1 more replies
Relevance 61.5%

Hi all

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

Dim Recip()
With ActiveWorkbook

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

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

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

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

Regards,
Rollin
 

2 more replies
Relevance 58.22%

Hi

Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:

https://support.office.com/en-US/ar...ions-EF163677-3195-40BA-885A-D50FA2BB6B68#bm4

https://askdrexel.drexel.edu/app/an...:-change-password-of-a-workbook-in-excel-2007

We're used to Office 2003, so this is a big jump at work for us

Thanks

eddie
 

Answer:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.
 

1 more replies
Relevance 57.81%

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

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

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

Hi,

I have a problem in merging two worksheets in excel as the two sheets have different no of rows in it. and i need to merge the two sheets in a new worksheet, and in that work sheet i need to remove the duplicate values present in the both work sheets.

anybody can help me to do that.
 

Answer:Need to Merge two excel sheets in one excel sheet.

Hi,

What version of Excel are you using. If it's 2007 then I think you can copy the data to another worksheet and select the range then use the "Remove Duplicate" option that you find it the "Data" tab.
 

1 more replies
Relevance 56.58%

I am looking for a code to do the following:If date value is inputted in Sheet LOI Column C Row 5 then a row should be added to Sheet 1 Row 23 and populates the following info "Pre-Construction Meeting: Sheet LOI C5 Date Value".Is this possible?

Answer:Add Row to Different Sheet & Auto Input Info

re: "then a row should be added to Sheet 1 Row 23"I don't know what you mean by "a row should be added to Row 23". You can't add a Row to Row.Do you mean that you want to add a Row below Row 23?re: "populates the following info "Pre-Construction Meeting: "Populates the info where?Assuming that you mean that you want to add a Row below Row 23 and that you want to populate the new A24 with the info, then try this code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$5" Then
If IsDate(Target) Then
Sheets("Sheet1").Cells(23, 1).Insert
Sheets("Sheet1").Cells(24, 1) = _
"Pre-Construction Meeting: " & Target.Value
End If
End If
End Sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 56.17%

Here is what I am tying to do and appears to be a complicated task to say the least. I am trying to auto populate a score from a table by based of a raw score and age. Might be easier if I use an example:Marty is 33 years old, during a physical fitness test he does 75 pushups. Base on his age and raw score, he receives a final score of 100. All of this information comes from a table with the age groups across the top and the raw score on the left hand side. Using this data you scroll down until you find the appropriate value and that's his real score based off his performance. I realize it may be a bit confusing. However if anyone is familiar with the APFT table in the military then you have at least an idea of what I am looking at. The end state for me is, being able to input a raw score and the system to take in account his age and find his real score. Is this possible or am I asking to much of Excel haha?message edited by donkthompson

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%

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