Computer Support Forum

Automatic Outlook mail reminder based on Excel file

Question: Automatic Outlook mail reminder based on Excel file

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 100%
Preferred Solution: Automatic Outlook mail 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.)

Relevance 111.36%

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

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a payment is 10 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

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

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

I'd really appreciate any help,
 

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

15 more replies
Relevance 111.36%

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

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

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

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

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%

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%

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

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

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

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

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

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

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

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

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

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

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

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%

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%

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%

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%

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%

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

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

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

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%

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%

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%

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%

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%

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%

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%

Is there any type of program that can manage web based email, but pull all old email from an outlook 2003 PST file?

if would be great if it would also write to that same PST file thus perserving old mail, and writting new mail in a format that outlook would accept.

I have many, many different email boxes all inside outlook, and it would save me so much time if I could access them from the web instead of having to remote desktop into my server. The problem is, most computers I work at don't have remote desktop enabled, or simply dont support it.

So being able to access all my email from the web would be so much better. Does anyone know of any program that will do this. (I'd prefer something free, but if it will do what I want I don't mind paying for it.)
 

Answer:way to make an outlook file web based?

Easy, just connect to an IMAP server (you may have one already) with Outlook, create folders on the IMAP server, and move all your existing email into those.
 

5 more replies
Relevance 62.32%

Hi,
I want to copy the body of an email and paste it into excel - The email body is ~700 lines long & when I paste it to excel it puts the whole email body into 1 cell, rather than pasting it line for line ..... as there is a limit in excel for the number of lines in a cell, it misses half the data ....

This is the section of my code ...

i = 1

For Each olMail In Fldr.Items
If olMail.Subject Like "*11/07/2012*" Then
MailRows = olMail.Body
Range(Cells(i, 1), Cells(1, i)) = MailRows
i = i + 1
End If
Next olMail
Any help would be most appreciated ...

PS, go easy ... I'm a novice!
 

Answer:Excel vba to copy outlook mail body to excel'03

Have you tried saving the email message locally and trying to open it directly with Excel?

Rollin
 

2 more replies
Relevance 62.32%

Hi!

Having problem with moving mails automatic from in folder to specified folders by me in Microsoft Outlook 2013.

Have made rules or filters (using a Swedish version) but it wont move them automatic. I have to move them manually every time.

What have a missed?

ToddeSwe

Answer:Moving incoming mail automatic in Microsft Outlook?

BUMP.. maybe someone will come along to help you.

4 more replies
Relevance 61.5%

Existing reminder that I want to edit for a later date or time. I could previously do this and save it, however, the save "box" is missing now.

More replies
Relevance 61.09%

This is a problem I have put off for a while because I couldn't find a solution anywhere on the net! Had to get by with the Auto Updates option turned off.

It's the popup we are all too familiar with:
"Updating your computer is almost complete. You must restart your computer for the updates to take effect."

The problem I'm having is that a simple restart doesn't work! I've rebooted over 5 times to no avail.
I suspect this was caused by my removing of a security update several months ago (though I can't recall why I needed to remove it or which specific update this was).

My O.S is Microsoft Windows XP Professional 5.1.2600 and I'm using Service Pack 2.
Any other information required, I should be able to retrieve.

Help will be much appreciated!
 

Answer:Automatic Updates reminder! Help needed!

10 more replies
Relevance 60.27%

Hi everyone,
This is my first query on this forum.
I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts.
The details of the input sheet are as shown below:
Col. A 'Sl. no.',
Col. B 'Vendor name',
Col. C 'Effective Date', (mm/dd/yyyy)
Col. D 'expiration Date', (mm/dd/yyyy)
Col. E 'e-mail',
Col. F 'Reminder'

As shown above, a reminder mail should be sent 14 days before the expiry date "Col. D" with the
E-mail message "Your Contract with <Vendor Name> expires on <Expiry date>. Please initiate formalities for renewal of this contract".
This mail would have to be sent to be sent to 15-20 E-mail IDs in Col. E. With the above-mentioned message. Also, once the reminder mail is sent the, the timestamp of that action should appear in Col. F 'Reminder'.
Sample input sheet has been attached.

I'm a beginner at macros and VB, any help would be highly appreciated.

Thank you,
Adman
 

More replies
Relevance 60.27%

This friend's computer has this icon in the lower right hand corner, a sort of shield, which keeps prompting her to update programs and so on. It's a nuisance, and I would like to disable it, if I can. is there a way to do that?

Thanks

Answer:can the automatic update reminder function be turned off?

Quote:





Originally Posted by haskellbob


This friend's computer has this icon in the lower right hand corner, a sort of shield, which keeps prompting her to update programs and so on. It's a nuisance, and I would like to disable it, if I can. is there a way to do that?

Thanks




Yeah. Just click the shield and when the box comes up check "don't show this again".

4 more replies
Relevance 60.27%

Hi everyone,
This is my first query on this forum.
I was looking for a VBA Script to run a macro for Excel 2010 which could be used to send out reminders mails to multiple mail IDs in Outlook 2010, 14 days before the expiry of certain contracts.
The details of the input sheet are as shown below:
Col. A 'Sl. no.',
Col. B 'Vendor name',
Col. C 'Effective Date', (mm/dd/yyyy)
Col. D 'expiration Date', (mm/dd/yyyy)
Col. E 'e-mail',
Col. F 'Reminder'

As shown above, a reminder mail should be sent 14 days before the expiry date "Col. D" with the
E-mail message "Your Contract with <Vendor Name> expires on <Expiry date>. Please initiate formalities for renewal of this contract".
This mail would have to be sent to be sent to 15-20 E-mail IDs in Col. E. With the above-mentioned message. Also, once the reminder mail is sent the, the timestamp of that action should appear in Col. F 'Reminder'.
Sample input sheet has been attached.

I'm a beginner at macros and VB, any help would be highly appreciated.

Thank you,
Adman
 

More replies
Relevance 59.86%

I am new to the world of Visual Basic & Macro's so please excuse my ignorance.


I am looking to create a macro to populate

Excel Template
Word Template
from an exsisting (master) Excel file

once these documents populated I want to create a zip file containing the newly populated templates.

and then add this zip file and the details from the (master) excel file to an microsoft outlook meeting request

is it possible to do this using macros or will I have to generate some sort of code/ script

I understand there are a lot of factors i am trying to combine into one simple command and may be trying to run before i can walk, but any input, guidance or suggestions would be greatly appreciated,
 

More replies
Relevance 57.81%

At work, I have been asked to create a system whereby we have an Excel spreadsheet with two columns, the first containing the name of a client and the corresponding column containing their email address. (This part is, obviously, fine) From this spreadsheet my boss then wants it to be possible to send emails en masse, by inputting their full name in the "To" field, and Outlook sending emails to their email address, as contained in the spreadsheet. Further to this, client confidentiality is important so it would have to be BCC'ed. I have a feeling we would need to involve Microsoft Word here as a kind of 'middle-man' and use the Word Mail Merge feature, but I am still unsure as to how to go about this whole operation. Can someone start me off?p.s. I thought maybe I could import clients from the Excel spreadsheet I made but some things occurred to me:1. When clients changed their email address, would we need to re-import every time?2. There would be a lot of clients, is there a maximum to the number of contacts you can have?3. There are already people in the Outlook address book to whom we would not want to send our client-intended en masse emails. Is it possible to create a kind of sub-contact list?

Answer:Outlook/Excel Mail Merge

VBScript can send emails as a standalone module and can read Excel workbooks eliminating any need to import the names and addresses to keep them in sync. You could also write a VBA macro in either Outlook or Excel.  If you get Word involved the easiest way would be to record the macro and make changes as needed. Recording macros usually does not produce the most streamlined code.Good luck.  8-)

4 more replies
Relevance 57.81%

Hello Everyone,

Can anyone help me with VB Code... As we using few shared excel files in my concern and there is lot of changes has been done of some person but we unable to track them. So can you please advise an VB code which need to hit our mail inbox (Outlook) when any changes has been occured in excel file by any other person..

Note: Also i need to receive mail with what changes has been done and in which cell..

Hope above clears if not let me know ! !

Many Thanks In Advance,

Vivek.G
 

Answer:Solved: Excel to Outlook Mail !!

8 more replies
Relevance 57.4%

Yesterday, my Outlook (2010) stopped retrieving e-mail from the Comcast server.  When I tried to fix it today, it still wouldn't work.  All the settings were correct, but it wouldn't retrieve my e-mail.  I deleted the account and recreated it.  Now, Outlook points to a new .pst file instead of my old Outlook.pst file, named [email protected]  To make matters worse, it doesn't delete the mail off the server.  Before, when I would open Outlook, it would download new message to my Inbox and delete them off the server.  The new messages would stay permanently in my Outlook inbox.  No more.  Now if I manually delete one through my Internet browser, it also deletes it out of my Outlook Inbox.  It’s as though the new account is just a window to the Comcast e-mail server.  I tried changing the Root Folder Path on the Advanced tab of the e-mail account settings to point to the location of my Outlook.pst folder, but that made no difference.  I also tried deleting a recent Microsoft update (KB3054976), but this did not help, either. This is a complete disaster for me, as I can't even send e-mail now, except through the server.  Any help will be greatly appreciated. 

Answer:Outlook 2010 e-mail account won't sync to Outlook.pst file

I figured this out.  When I reconfigured my e-mail account in Outlook, I used IMAP settings instead of POP3.  This was not how I did it before.  IMAP works great if one wants to keep all e-mail out on the server and access it from various devices.  That isn't what I do.  I changed the profile to POP3 and the poblem was solved.  Still don't know why it initially failed two nights ago, though. 

1 more replies
Relevance 56.99%

Hi everyone,

I read a post on Tech Support Guy that was similar to my question however seeing as the thread was quite old, I thought I would ask again to see if there were any new ways of doing this.

I have a spreadsheet with Name, Surname, ID number, Verification Code, Employee Number, Activation Requested. I then have a mailbox in Outlook where people can send a mail confirming their ID numbers.

I would like to set up a macro that will automatically populate the Activation Requested column once a mail comes in that matches the Name, Surname, ID number fields (so the cell will either be blank or have "No" and once a mail comes in matching the above fields, it will change to "Yes").

I am quite comfortable in Excel but have only recently started to dabble with modules in VBA so by no means do I understand extensive coding or the jargon that goes along with it.

So, my questions are:

1. Is there code available that I can use to set up the above (in a step-by-step manner as I would like to understand what I am doing and not just blindly copy/paste)?

2. Would the macro run automatically once my workbook has been opened in order to update mails that may have come in when Excel wasn't running?

Thank you in advance for any advice
 

More replies
Relevance 56.99%

Good day,
Maybe somebody can help me to solve following problem.
In Excel the routine separates the tasks depending of the Windows username (sheet-parameters). So it transfer only necessary tasks for current user. After that, task is marked.
But, sometimes it is necessary to send task for all users (and me). I think it could be realized with sending e-mails with task. E-mail will be send only, when is choose "All". But I don't know how realize it.
Maybe someone know useful links with similar code or something else? Because VBA is new for me.
 

More replies
Relevance 56.99%

hi,

i know how to do a mail merge between word and an excel database, but i dont know if it's possible to merge info between outlook (or OE) and an excel database.

please help.

thank you.
 

Answer:[solved] is it possible to mail merge between outlook and excel

13 more replies
Relevance 56.99%

Whenever I recieve an Excel e-mail attachement, I have to save it and then go and get it to open it. It will not open simply by double clicking any more. It says it cannot find the right software to open the file. I do not know why it suddenly stopped working, but more importantly, how do I fix it?!
 

Answer:Outlook e-mail Excel Attachments won't open!

7 more replies
Relevance 56.99%

Hi guys,

I have read tons of pages from this forum hoping to create a killer excel workbook so my daily tasks can be completed way faster and more efficient, however I have hit a brick wall. That brick wall is called "How in (insert whichever holy character you want)'s name do I get Outlook to obey Excel".

My request is rather simple, yet I don't have the brains for it. Once a week, probably on Monday, based on the attached excel, I want to send specific e-mails to colleagues informing them which documents should they start writing based on the "Deadline to be filled" column and to also inform them what is going to happen based on the Column "When will it happen". Here's how I think the code should be displayed in my humble and unadvised opinion:

If "Col G" = yes, then do nothing
if "col C" is between today() and today()+7, then e-mail must be displayed
Subject = Work schedule
To: ?Col E?
Cc: ?Col F?

Body:
?1ST PART - I am trying my best to understand excel/vba language, so I'm adding hypens like y'all pros when I do a comment

Dear colleagues,

The following actions must be completed this week:
- ?Col A? for ?Col B? ? deadline to be filled ?Col C?
- ?Col A? for ?Col B? ? deadline to be filled ?Col C?
- Preliminary hearing for Yellow SRL ? 09.05.2016 (example)

?2ND PART

Also, if "col D" is between today() and today()+7, then the following tex... Read more

More replies
Relevance 56.58%

Tried doing this but I get scattered pieces imported.

Got as far as dragging address from an excel file to email field in Outlook, but get an error and bits and pieces.

Don't want to import one by one.

i shortened the excel file to just one column with e-mail addresses.

Got to be a way.
 

Answer:Solved: Import e-mail addresses to Outlook from Excel

Hi holymoly

In the Address Book in Outlook Express, enter at least one contact.

Then Export the Address Book as a Text File (Comma Separated Values) (.cvs) file to the Desktop.
This will give you a template to work with.

Open the .cvs file and paste the e-mail addresses into the correct field.
Save and close the .cvs file, then Import it into the Address Book.
File > Import > Other Address Book > Text File (Comma Separated Values) > Import
Browse to the .cvs file on the Desktop.
Let us know if that works for you or not.
 

2 more replies
Relevance 56.58%

Hi guys

I have an Excel spreadsheet that tracks document reviews. One form of evidence that a document has been reviewed is an e-mail from the reviewer (eg, "I've reviewed it and told John to make corrections as per the attached").

Aside from printing the mail to a pdf and saving it somewhere (which could involve printing each mail and attachment separately, then linking them together somehow), is there any way the mail itself can be saved in such a manner as clicking the link will open up the mail and all its attachments?

Cheers,
Gaz

Answer:Can I save an Outlook e-mail trail and hyperlink to it from Excel?

You can save Outlook emails as various file formats (.msg, .htm, .mht, etc.) with File > Save As, but I don't think these include the attachment, so this will have to be saved separately.

However, once you have both the email(s) and attachment(s) saved, you can bundle them up into a folder or zip file as use that, I suppose?

EDIT: as FliGi7 says below, .msg does include the attachment (thanks for that!)

2 more replies
Relevance 56.17%

Hello.

I have been trying to work out how i can select a file from mY c drive to add as aan attachment

I know how to build the E-mail up i am looking for how to select and install an attachment.
 

Answer:Add PDF file to e-mail, excel, Macro, attachment

Are you looking for a macro to include the .pdf file in a excel macro ? Could you please give more information about your need ?
 

2 more replies
Relevance 55.76%

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

Hey Guys,

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

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

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

Will be gratefull! for your help.
Thanks.
 

More replies
Relevance 55.76%

Hy there,

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

Thanks.
 

More replies
Relevance 55.76%

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

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

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

More replies
Relevance 55.35%

Microsoft is "upgrading" people's  @outlook.com, @hotmail.com, @live.com, and @msn.com accounts, to a new Outlook.com (built upon the latest Office 365 infrastructure), which is INcompatible with Live Mail 2012 (and presumably older versions as well):  Effective late June 2016, Windows Live Mail 2012 will no longer synchronize emails, contacts, and calendar events from these email accounts.
People who use Windows Live Mail 2012 to connect to other email services, including Gmail, Yahoo Mail, or other services that use POP3 or IMAP protocols, do not need to take action. 
Is this another veiled attempt to force users to "upgrade" from Windows 7?
Users can still access their e-mail via their web browser(s).   Or they can use the new Outlook.com and/or a Mail app on Windows 8.1/10 
https://blogs.office.com/2016/05/05/using-windows-live-mail-2012-with-outlook-com-time-to-update-your-email-application/
https://support.office.com/en-us/article/Windows-Live-Mail-2012-will-not-connect-to-Outlook-com-45453b92-373b-4bbb-88ca-f8ec74f8e8fd

More replies
Relevance 55.35%

I have Office 2003 with a Vista operating system. Everytime I try to do a mail merge to create label with a Excel csv file it forces me to close the application.

I can complete the mail merge using the same file on any other computer. The only why I can get the mail merge to work is to save a csv file as a regular excel file. It doesn't matter what csv file I try on, it just crashes word.

Tried unistall and re-install of Office and the problem is still occuring.

I don't know why word won't allow me to use th csv file type.

Please hlep
 

More replies
Relevance 55.35%

I wrote a Macro in Excel that will open an e-mail and send it using the following code.

ActiveWorkbook.EnvelopeVisible = True

With ActiveSheet.MailEnvelope
.Introduction = Range("T22")
.Item.To = Range("T15")
.Item.CC = Range("T16")
.Item.Subject = "CST CARRIERS"
.Item.Send
End With

I want to attach a file to this e-mail before sending but don't know the syntax to do this. I know exactly where the file will be stored as well as the file name. Does anyone know the syntax for performing the attachment of the file?


I know you can attach files to these e-mails because if you insert a "Stop" statement just Prior to the ".Item.Send" statement and run the macro you can see and manually send the e-mail. There is an attachment button on the e-mail that I have successfully used to manually attach the file prior to sending the e-mail. I tried recording a macro to get at the code but it didn't copy anything while I performed the manual steps.
 

More replies
Relevance 55.35%

my flat host interent for the whole flat. the wifi is unsecured and you must login with the account from your
browser. the problem is that the wifi resets every half and hour i must relogin . i cannot leave the download overnight. can someone please give me a cURL code or wget code or a program that helps me relogin automatically every half hour.i m a noob at computer so please make it simple for me
This is the charles request that relogins my wifi but charles runs out of memory too often and the auto save tool does not work.

plz help. thx a lot in advance

Answer:Help: Automatic web based wifi login

plz help

1 more replies
Relevance 55.35%

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

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