Computer Support Forum

Excel To Outlook Calender Reminders Macro

Question: Excel To Outlook Calender Reminders Macro

Hi all,

I'm looking to create an Excel document and I need to put cells with dates in that are linked to outlook calendar reminders.

I.e I need a macro that when I click the link it sets the reminder on outlook for the date allocated in the cell.

could anyone please help me with this as i have never created a macro and would greatly appreciate any help you could give me.

Thanks

More replies
Relevance 100%
Preferred Solution: Excel To Outlook Calender Reminders Macro

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

Hi everybody - long long time since I posted on here but I know that I can depend on your knowledge. So. Is it just me, or has outlook calender stopped sending e-mail reminders and device alerts.

More replies
Relevance 92.25%

I am using Office 2000 and have notinced that not all reminders are popping up. Some do some don't. All the appointments are set to use reminders by default.

Any ideas?
 

More replies
Relevance 76.26%

I have a spread sheet that contains review dates in some colums. Is it possible to link excel to outlook so I automatically receive reminders via outlook a week prior to each date. I have been told it can be done but I am not sure how. Any help will be appreciated.

Answer:Excel/Outlook reminders

You would need to run a macro in Excel. click here may get you started.

2 more replies
Relevance 75.44%

Hi

Can anyone please assit me on how to make an Excel workbook give me a reminder via Outlook.
I want a reminder that will tell me when a specific task has not yet been completed.
we send requests to a custodian when we a looking for a document. on the excel sheet we enter the date we sent the request, but I want a reminder when the received date column has not been updated if I have not received the documents within 3 days time in order to follow up with the person.

can you pease assist me

regards
 

More replies
Relevance 75.03%

Hello,

I am a placement student and am looking at ways to make things easier at my company. I am wondering if there is a way to sync excel with outlook calender by entering info into an excel spreadsheet and it automaticly enter into outlook?

Tasks are all stored in an excel file, there is a different tab for every month, the jobs are listed in column A and the dates are listed across the top of the spreadsheet. The name of the person who will be doing the job is in the appropriate cell linking the job with the date so installers know where they are supposed to be. All installers have recently been provided with iPhones we are hoping to link these phones to a shared outlook calender but currently awaiting an upgrade to the latest exchange server as the current one won't allow for multiple calenders (so the shared one does not currently show). I hope this will work when we are updated!

Anyway..I am wondering if there is a way to link our spreadsheets with this shared calender when it is set up as it would be extremely helpful for the installers to have access to this info when on the go without us having to manually enter into the shared calender.

We are currently running Office 2010 and Exchange 2003 soon to update to the latest (2011 I think)

If anyone could help me it would be much appreciated! and sorry to say that I don't understand codes etc. so if someone could talk me through it if that's the case it would be much appreciated!

Thanks for read... Read more

Answer:Sync Excel with Outlook Calender

Why not just send appointments directly to the installers calendar?
 

1 more replies
Relevance 74.62%

Hello.
I have been tasked to keep track of follow ups for Implementation dead lines.

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date is 14 days away from being implemented/addressed. 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. J), with subject "Audit Follow Up_Audited Function (Col. A) is due on Due date(Col. I)", and body "Dear Name(Col. K), Reminder - Audit Follow up on Implementation Date"
Also, the script should put a check mark on Reminder sent column (Col. L) 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. I've attached my sample spreadsheet.

Thanks
 

Answer:Automated Reminders excel 2007 thru Outlook

10 more replies
Relevance 74.62%

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

Hi all,

I am looking for help on VB script to send automated emails based on the dated column in excel sheet..
I need to send reminders to the email addresses in Column J & K to remind them that the vehicle registration in Column B is due an MOT on the date in Column M, also to send a reminder that the Tax is due on the date in Column P. these emails need to be sent 14 days before the due dates.
I also require Column N & Q to generate at date and time when the reminder was sent.
I would much appreciate any help with this as I am completely new to VB script, I have attached the file to aid in any help
 

Answer:Sending Email reminders from excel to outlook using VBA

11 more replies
Relevance 73.8%

Hey All,

I have had a Yahoo Mail account for the past ten years. For the past year or more, I have had intermittent problems with Yahoo Calender not sending Birthday reminders or appointments. Sometimes it works, sometimes it doesn't. The issue seems to happen about three to four times a year, gets resolved, and than happens again in cycles.

I have gone through all the basic trouble shooting steps of clearing cookies and cache a long time ago. It doesn't help as the problem is on Yahoo's end. The Yahoo Help Community has many topics on this and similar calender issues. I send Yahoo Feedback, but the problem does not stay resolved and I keep missing appointment reminders.

Has anyone else had this problem? If there are Yahoo techs on the forums, I would really like to see this issue escalated to tier 3 or higher support within the company. In sharp contrast, Yahoo Mail sending and receiving of messages has never been better! It's Yahoo Calender that is the issue.

Jack
 

Answer:Anyone Else Not Getting Yahoo Calender Birthday or Appointment Reminders?

You might want to try out a gmail account. It seems this issue is with the yahoo server, as yahoo offers the free email account they are not really letting people know when the system is over whelmed with requests. I have seen this issue with another person I provided help to, it is definitely a yahoo thing.
 

1 more replies
Relevance 73.8%

Hi All,

I am new to VBA and although there are many links in the forum regarding the topics of using Excel to send Email reminders to Outlook, my requirement requires an additional option which i do not know how to program to make it work. I hope I can be assisted.

I am currently using Outlook & Excel 2010, Windows 7.

Using the attached test example, I have created a spreadsheet which is used daily. It requires a reminder email to be automatically sent out ONLY if the following is triggered.

Row H (Send Reminder) must show YES, then it will only send on the date shown on Row G (Due Date). However, if Row H shows NO, it will not send even though Row G has Due Dates.

The body of the reminder message would say:

Subject: Reminder

The project assigned to you under reference number, "cell D3" in the name of "from cell E3" for the confirmation date of "from cell N3" is now G3 - C3 days old.

If this has been completed, please ignore.
 

More replies
Relevance 73.39%

Hi Folks,
I found the following thread:
http://forums.techguy.org/business-applications/541487-merge-excel-dates-into-outlook.html

At best I am capable of copy pasting code - and I guess I'm slightly failing at that even.
I simply wish to be able to update an excel with dates of future tasks, in a particular column, and have these automatically appear as tasks on a particular date in calendar. Ideally column a (name of task) and column F (date in format 1.1.1.) would both be incorporated into the task, which would be allocated to date X in calendar.
I am using Outlook version 14.0.4734.1000

I have associated with Outlook 14.0 object library already. This is what i have so far (the first line is incorrect, presumably amongst others):
Code:

Sub ExportAppointmentsToOutlook(14.0)
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "F").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = ... Read more

More replies
Relevance 73.39%

For the past few weeks, I have not been receiving email notification reminders for my WLM Calendar events. Everything else is working OK but I do rely on my calendar reminders.

I don't know if anyone else has had this problem and knows how to cure it, or is this a good time to move on to Mozilla Thunderbird.

Any view on this please ?

Whilst writing, I would like to mention that although I have checked the box to receive instant email notifications, I do not appear to be receiving any. On my previous posting, although there were several replies, I did not receive ANY email notification. Can someone explain what is happening here please and could these problems be related in any way ?
 

Answer:Windows Live Mail Calender not sending reminders

I'm rather surprised (and disappointed too) that I haven't had any replies to this posting. Over 170 people have viewed it without sharing their knowledge or giving help in some way. Maybe everyone has gone on holiday but in the meantime, the situation is still the same 0 I am not receiving calendar reminders for WLM events.
 

1 more replies
Relevance 72.98%

I'm in HR and I have a spreadsheet that incorporates staff information commencing, with each month in a new sheet. Unfortunately, department managers are forgetting to do staff reviews at 3mth, 5mth or the 6mth probation. I've entered formula to calculate these dates from the staff commencement date.
Now I need to find out if I can have some sort of Macro or VBA coding to email me a reminder to contact the managers a week prior to the the review/probation dates.

Please help! I have no idea with coding/programming etc.
 

Answer:Excel 2016 to send Outlook email reminders on various dates

Try the attached, one thing to note that you had the probation dates in the wrong place

6mth, 3mth and 5mth

so I changed it to 3\5\6

when you open the workbook the macro will run and generate an email IF any dates is below or equal to 7 and above or equal to zero. Meaning that there is a week until the review is required. This code will fail if the review date is in the past, this can be changed to tell you that a review date has been exceeded.
 

1 more replies
Relevance 72.98%

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

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

Hi I would like to get VBA/macro codes to send an automated email to the email IDS mentioned in the file when the invoice due date is less than 2 days of current date. please help me
 

Answer:Excel 2016 to send Outlook email reminders on various dates

Here's a similar thread on the forum. If you can follow the code, then you can adapt it to suit your needs.
 

1 more replies
Relevance 72.57%

Dear forum,

I need to come up with a way to import calender data from excel. My office is trying to coordinate calender data from other companies which they then can have the option to integrate into their own calenders. I have been googling around and the process seems, at first sight, to be way to laborious. Is there a way to (through initial programming or other ways) to create an excel sheet with data where a people can, with a click of a button, import the calender data in the targeted coloumn into their own outlook calender - without downloading any additional software? Non-clouding solutions are prefered.

Thank you in advance

Answer:How to import excel calender data into outlook - with a click of a button

Outlook can only import .ics & .vcs files for calendars, which excel cannot export.
Third party software is looking like your last resort.

1 more replies
Relevance 66.42%

Hey guys, I had some great assistance from computerman29642 earlier on this macro. It works perfectly on my own calendar; however, I need to target a specific shared calendar. Hopefully it could be user imput by a msg box. I am struggling to find information on how to do this.

The first thread was this
http://forums.techguy.org/business-applications/835748-solved-excel-macro-outlook-calendar.html

So, as for now the example works. But before it writes to the calendar I want a msg box pops up asking for the desired calendar(Sometimes more than one word), and then target that calendar and write the data. A simple little box that confirms or denies progress (I am pretty sure I can figure that one out) Any suggestions or directions where I can learn more fire away please. Ill attach a copy of my test again.
 

Answer:Excel to Outlook Macro

16 more replies
Relevance 65.6%

Plz guys suggest me some good calender app that can be good in looks on my home screen and also sync with all accounts i.e., outlook, gmail, fb etc.

More replies
Relevance 65.6%

Hi,

I am an extremely basic user who has managed to get a basic macro together through multiple web searches and am now stuck...

I have dates entered into the following columns in excel: 14,15,16,26,27,28

I have managed to make the macro create appointments for 14,15,16 but not the rest. Also, every time i run the macro it creates a new appointment regardless if one already exists. I saw on this forum about adding a word to another column which the macro searches for and if found doesnt create a new appointment - or something to that extent. Here is what i have:

Sub POATEST()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")

' Start at row 7
r = 7

Do Until Trim(Cells(r, 1).Value) = ""
For Each cell In Range(Cells(r, 14), Cells(r, 16))
If cell.Value <> "" Or 0 Then

' Create the AppointmentItem
Set myApt = myOutlook.createitem(1)

' Set the appointment properties
myApt.Subject = Cells(r, 1).Value & " " & "Update Due"
myApt.Start = cell.Value
myApt.categories = "Yellow Category"
myApt.ReminderSet = True
myApt.Body = "blah blah blah"
myApt.Save
End If
Next cell
r = r + 1
Loop
End Sub

Please can someone assist by:
1. making it apply for all the columns originally mentioned
2. making it search if an appointment for that item (ie that row) exists - if not, create appt, if so, do not create appt and insert "Yes" in column 29

Thank... Read more

Answer:Excel Macro - Add Appointment To Outlook

HI,

Check this code you may be able to modify it.
Have not used it in a long time but....

Code:

Sub AddAppointmentsToCalendar()
Dim OLF As Outlook.MAPIFolder, objItem As Outlook.AppointmentItem
Dim i As Long, lngItemCount As Long, r As Long
On Error Resume Next
Set OLF = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderCalendar)
On Error GoTo 0
If OLF Is Nothing Then Exit Sub

Application.StatusBar = "Adding appointments to Outlook..."
With wsSheet1
.Activate
r = Range("NewAppointments").Row + 1
Do While Len(Range("A" & r).Formula) > 0
On Error Resume Next
Set objItem = OLF.Items.Add(olAppointmentItem)
On Error GoTo 0
If Not objItem Is Nothing Then
With objItem
.Start = Range("A" & r).Value
.End = Range("B" & r).Value
.Subject = Range("C" & r).Value
.Body = Range("D" & r).Value
.Categories = Range("E" & r).Value
.ReminderSet = False
.Save
End With
Set objItem = Nothing
End If
r = r + 1
Loop
End With
Application.StatusBar = False
Sheets("Appointments").Select
Range(&... Read more

1 more replies
Relevance 64.78%

I need a macro that will 1) create a new outlook folder, then 2) create new Outlook distribution lists from data in an Excel sheet.

The Excel sheet has columns:
A - ID
B - DEPARTMENT_DESC
C - STUDENT_LEVEL_DESC
D - MAJOR_DESC
E - PROGRAM_DESC
F - EMAIL_ADDRESS
G - LAST_NAME
H - FIRST_NAME

The first entry begins in row 2 with row 1 being the column title.

I need a new distribution list to be created for each department (column B) and each student level (column C). (Column B will only ever be one of 6 values, column C will only ever be one of 2 values. Therefore, the macro should create 8 distribution lists.)

I have looked at threads similar to this question but I can't seem to get anything working.
 

Answer:Macro from Excel to New Outlook Distribution List

I saw something you might could work with here: http://www.helenfeddema.com/CodeSamples.htm
scroll down for sample 61. I haven't used it but marked it one day. I'm assuming your wanting to make local distb list? Not in AD.
 

1 more replies
Relevance 64.78%

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

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

Hey guys, I am quite new to creating macros. I do have some primitive experience with code. My goal is to take 3 or 4 colums of information and put them into Outlook Calendar.

A- Discription B- Start -C Finish

So, in the Calendar in outlook it would show a discription and connect the dates in B and C to the days in the Calendar. I don't know if it can be done. At my current state I can't figure out how to get even one to move over. Any suggestions on where to start??

I am running Outlook and Excel 2003 all updated. On Windows XP Pro Service Pack 2.
 

Answer:Solved: Excel Macro to Outlook Calendar

16 more replies
Relevance 64.78%

Moved from Software Development
Hi, We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in to emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed so they could be updated by all. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I have updated an excel spreadsheet containing all the information and I would like to create a macro for all the team to periodicaly import this data in to Outlook Contacts and possibly create distribution lists from these. I trust this makes sense I am using Outlook 2003.
Thanks
 

More replies
Relevance 63.96%

Hello Everyone
I'm a pro atlete (quite iliterate in Biz Apps) that based on previous post (from Zack Baresse and computerman29642) has unsuccessfully tried to set up a code to merge my next year training calendar (xls format) into outlook. I herewith included the code I'm using and the test xls file I'd love to merge. Any help would be really appreciated
Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = Startdate
' Row 2 = Finishdate
' Row 3 = Subject
' Row 4 = Location
' Row 5 = Body
For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)
With olApt

.StartDate = arrAppt(i, 1) + arrAppt(i, 2)
.Finishdate = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = arrAppt(i, 6)
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.AllDayEvent = True
.Save
End With
Next i

Set olApt = Nothing
Set olApp = Nothing
End Sub... Read more

More replies
Relevance 63.96%

Hi there,

I have to prepare several daily emails which are prepared using a range of data (for example B3122) from Excel 2003 and then have to be sent using Outlook 2003. Unfortunately, due to various management requirements I am unable to merely attach the Excel file as an attachment or paste the Excel data into the email as a straight paste - I have to paste as Unformatted text and then manually change various lines of the email to Bold and Underlined text.
I am trying to write a macro that will do this automatically but am unable to get the Excel data pasted into Outlook (as unformatted text or otherwise). I am assuming that for the font changes to bold I will have to use a Find function in the macro.

The code that I have got so far is as follows:

Range("B3122").Select
selection.Copy

Dim olApp As Object, olMail As Object
Set olApp = CreateObject("Outlook.Application")

Set olMail = olApp.CreateItem(0)
olMail.To = "[email protected]"
olMail.Subject = Range("B3")
olMail.Display

I am new to VBA and so I may be missing a really obvious solution but after trawling the net I have been unable to find an answer.

Many thanks to anyone that can help and make my work a lot less tedious!
 

More replies
Relevance 63.96%

Good Morning,

I have very limited knowledge when it comes to Macros and VBA.

What I need is one of two possible scenarios.

1. Information from a Training Assignment PivotTable exported to a shared calendar on Outlook.
2. Information from a Training Calendar bulit as a Macro in Excel exported to a shared calendar on Outlook and the ability to update either calendar if new information becomes available.

Don't know which is best using code via VBA or using the Export/Import functions.

Any help is greatly appreciated
 

More replies
Relevance 63.96%

Hi, I have a macro in excel that automatically updates my outlook calender - I use it to keep track of actions/deadlines/etc...

The macro runs beautifully except... whenever I run it it creates duplicates of appointments it has previously made in my outlook calendar. Is there any thing that I can add to the macro below to ensure it doesn't duplicate?

Really appreciate any help on this one. Cheers.
Sub outlookexport()

Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0

'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = Location

For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)

With olApt
.Start = arrAppt(i, 1) + arrAppt(i, 2)
.End = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = "Created by excel tool"
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.Save
End With
Next i
Set olApt = Nothing
Set olApp =... Read more

More replies
Relevance 63.96%

Hi there!

So I've found the code below here: http://www.google.com/support/forum/p/Calendar/thread?tid=5e4909ca64cffe90&hl=en - Full credit goes to user 'tpuiatti'

Code:
Sub Generate_ICS()
Dim rng1 As Range, X, i As Long, v As Long
Dim objFSO, objFile
Dim FilePath As String
FilePath = "G:\Service.ics"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile(FilePath)
Set rng1 = Range([a5], Cells(Rows.Count, "H").End(xlUp))
X = rng1

objFile.write "BEGIN:VCALENDAR" & vbCrLf
For i = 1 To UBound(X, 1)
objFile.write "BEGIN:VEVENT" & vbCrLf & "DTSTART:" & Format(X(i, 2), "yyyymmdd") & vbCrLf & "DTEND:" & Format(X(i, 2), "yyyymmdd") & vbCrLf & "RRULE:FREQ=YEARLY" & _
vbCrLf & "SUMMARY:" & X(i, 1) & vbCrLf & "END:VEVENT" & vbCrLf
Next i
objFile.write "END:VCALENDAR"
End Sub

This code takes the info from 2 columns in Excel: A which is the event title and B which is the event date. Then it export these informations to an .ics file which will add the event dates to the Oulook Calendar.

The macro and the .ics work perfectly, however i wan't to make a few changes/additions to fit my needs. Additionally I wan't this macro to:

- Pick up dates from column &... Read more

Answer:Additional code to Excel macro - export to Outlook

7 more replies
Relevance 63.96%

Hi, I am looking for a macro to import contacts from excel. We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I would like to create the macro for all the team so that they can periodicaly update their contacts. I trust this makes sense
Thanks
Moved to Business Applications.
 

More replies
Relevance 63.55%

Hey everyone,

I was wondering if anybody on these forums could help me with the below task?

I run a backup program that generates email reports to a subfolder in my Outlook 2010 every 6-8 hours to tell me the status of every backup job that I have set up and have running. The email details the job name, the job start time, and the job status (running, completed successfully, failed, missed, cancelled etc).

At the moment, I sift through each and every one of these emails (I have over 100 backup jobs per day) and enter the relevant data manually into my excel spreadsheet. The spreadsheet looks like the following:

Job name Monday 1st Oct Tuesday 2nd Oct Wednesday 3rd Oct Thursday 4th Oct
Job_xxx SUCCESS SUCCESS FAILED FAILED
Job_yyy SUCCESS SUCCESS SUCCESS RUNNING
Job_zzz MISSED MISSED CANCELLED SUCCESS

What I&#8217;d like is to automate this process, so that each day, perhaps every 4 hours, a script would run that would search for certain values within each email I receive and update the excel sheet accordingly.

Example:

- Monday 1st Oct, 10am &#8211; email comes into inbox with subject/body containing &#8220;Job_xxx has started &#8220; >>>> update Excel sheet to record RUNNING under column &#8216;Monday&#8217; in row titled 'job_xxx'
- Monday 1st Oct, 1pm &#8211; email comes into inbox with subject/body containing &#8220;job_xxx completed successfully&#8221; >>>> update Excel sheet to record SUCCESS, ... Read more

More replies
Relevance 63.55%

Ok, just a bit of advice needed on this one for the time being...
I need a macro that will:

- Save all (Excel) attachments from the currently open email message (or a message selected in the Inbox) to a directory on the PC.

- Merge all the saved Excel files into a single file - they're all formated exactly the same - data in about 20 columns, no column headers or anything, just standardised data.

- Save the merged file with a standard name (i.e. every time this is ran, it needs to have the exact same filename).

- Delete all the files in the directory apart from the merged file.

I know there's probably a fair bit of code online for doing the individual parts of this. Can I do both from within Outlook? It doesn't particularly matter if I need to do this in 2 steps - an Outlook macro to save the attachements, and an Excel macro to do the file merge etc.

Cheers.
 

Answer:Solved: MS Outlook / Excel macro - extract attachments and merge

16 more replies
Relevance 62.73%

Good Afternoon,

I'm quite stuck trying to fix my code. I've scoured the internet looking for similar questions, but to no avail. I am trying to have excel create appointments in the outlook calendar and be able to run the macro multiple times without have duplicate appointments.

I could run my macro and create an appointment, which worked fine, but there was no routine to check if the appointment already existed. So I would have multiple appointment alerts for the same appointment if I ran the macro more than once. (If I were to add something and run the macro again to keep everything up to date).

So I tried to add a loop checking first the date of the appointment then the title (subject). However, now, I am getting the "Object doesn't support this property or method" error when I run the following code.

If anyone could help me with what the error refers to specifically in my code or any code I need to add or take out to make my loop work I would really appreciate it. Thank you very much in advance.
Code:

Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

Dim olCalendarFolder As Outlook.MAPIFolder 'use MAPI to loop through folder
Dim olMessage As Object 'items in calendar/inbox are messages
Dim olInboxMessages As Object
Dim olAppSession As Outlook.Namespace
Dim strSubject As String
Dim myDate As Date

Applic... Read more

More replies
Relevance 62.73%

Hi,

We have a spreadsheet that keeps track of when our computer warranties expire. Would like to run a macro using the warranty expired date to create an appointment in Outlook. That part I understand. The problem is that when I go to run the macro again, it creates a duplicate appointment if the appointment already existed. Very frustrating!

This is the code below, any help would be appreciated!!!! Thanks
Sub AddToOutlook()
Dim o As Outlook.Application
Dim ai As Outlook.AppointmentItem
Dim r&, sSubject$, sBody$, dStartTime As Date, dDuration#

For r = 4 To 10

sSubject = Sheet1.Cells(r, 1).Value
sBody = Sheet1.Cells(r, 4).Value
dStartTime = Sheet1.Cells(r, 3).Value
dDuration = 30
Set o = GetObject(, "Outlook.Application")
Set ai = o.CreateItem(olAppointmentItem)
ai.Body = "Service Tag= " & sBody
ai.Subject = "Warranty Expires for Server " & sSubject
ai.Start = dStartTime
ai.Duration = dDuration
ai.Close olSave

Next r
End Sub
 

Answer:Solved: Excel Macro to Update Outlook Calendar Creates Duplicates

6 more replies
Relevance 62.73%

I am currently trying to create appointments in a calender i have created in outlook using information from an excel spreadsheet. I have copied several codes from other forums to help with this Macro but have only been able to add the appointments to my calender.

The code i am currently using is:

Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = Location
For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)
With olApt
.Start = arrAppt(i, 1) + arrAppt(i, 2)
.End = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = "Created by excel tool"
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.Save
End With
Next i

Set olApt = Nothing
Set olApp = Nothing
End Sub
I also have the calender location but have no idea where it would need to fit into... Read more

Answer:Macro/VBE to create appointments in Outlook from an Excel Spreadsheet (Office 2003)

16 more replies
Relevance 62.73%

Hi all,

I need to know if is it possible that a macro in Excel sends an email containing the visible cells using Microsoft Outlook.
btw, I saw some code on the internet, that saves the visible cells in a new excel file and attach it in a new email using Microsoft Outlook, but I don't want to have attachments in the email.

thanks for any possible help.
 

More replies
Relevance 62.32%

Hi,

I need help with a macro. So far the macro is operating as it should , creating MS Outlook 2010 calendar appointments using data from an excel data spreadsheet (data base). The issue I&#8217;m having is that every time the macro is run for a new entry, duplicate calendar appointments are created for the already existing data in the data base. I would like to have the macro do a search to ensure an appointment does not exist before creating one. I have read a few threads with similar problems but have had major issues incorporating the solutions to resolve the issue I&#8217;m having.

I have attached the macro in txt. format for reference.

Thanks for your help.

kkfonty
 

Answer:Solved: Excel macro updating Outlook calendar is creating duplicate appointments.

Hi
You can use this function to check if an appointment exists based on the Start Day/Time

Code:

Public Function CheckAppointment(ByVal argCheckDate As Date) As Boolean

Dim oApp As Outlook.Application
Dim oNameSpace As Outlook.Namespace
Dim oApptItem As Outlook.AppointmentItem
Dim oFolder As Outlook.MAPIFolder
Dim oMeetingoApptItem As Outlook.MeetingItem
Dim oObject As Object

On Error Resume Next
' check if Outlook is running
Set oApp = GetObject("Outlook.Application")
If Err <> 0 Then
'if not running, start it
Set oApp = CreateObject("Outlook.Application")
End If

Set oNameSpace = oApp.GetNamespace("MAPI")
Set oFolder = oNameSpace.GetDefaultFolder(olFolderCalendar)

CheckAppointment = False
For Each oObject In oFolder.Items
If oObject.Class = olAppointment Then
Set oApptItem = oObject
If oApptItem.Start = argCheckDate Then
CheckAppointment = True
End If
End If
Next oObject

Set oApp = Nothing
Set oNameSpace = Nothing
Set oApptItem = Nothing
Set oFolder = Nothing
Set oObject = Nothing

End Function

For this to work you need to have Tools/References/Microsoft Outlook xx Object Library enabled.
Then alter your macro like this

Code:

Private Sub cmdOutApt_Click()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")
' Start at row 2
r = 2
Do Until Trim(Cells(r, 1).Value) = "&q... Read more

2 more replies
Relevance 62.32%

Hi all... I just joined this forum as past threads have been of great assistance... But now I have a immediate issue... I have wrote some code to pull info from a Excel report and create an Outlook appointment base on various commitment dates... This report is sent out daily therefore the macro is used daily... An issue that has risen is that everytime the macro is ran it creates duplicate appoinments which quickly bogg down the server... I saw an example on a closed thread and could not quite figure it out... Can anyone assist??? I am running 2003 versions of both Excel and Outlook and my code is as follow and thanks...

Sub ExceltoOutlookCommitDateSmithRenewalReport()
'
' ExceltoOutlookCommitDate Macro
' Load Excel Commit Dates into Outlook
'
' Keyboard Shortcut: Ctrl+o
'
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")

If MsgBox(prompt:="OK if YES / CANCEL if NO", _
Buttons:=vbOKCancel + vbQuestion, Title:="HAS PAA BEEN FILTERED?") = vbOK Then
MsgBox "MACRO WILL NOW UPDATE OUTLOOK CALENDAR WITH PROCLAIM COMMIT DATES."

Cells.Select
Selection.Copy
Workbooks.Add
Cells.Select
ActiveSheet.Paste

' Start at row 5
r = 5
Do Until Trim(Cells(r, 1).Value) = ""
If (Cells(r, 20).Value) = "" Then
' Create the AppointmentItem
Set myApt = myOutlook.createitem(1)
' Set the appointment properties
myApt.Subject = Cells(r, 2).Value
If (Cells(r, 5).Va... Read more

Answer:2003 Excel to Outlook Calendar appoinment VB macro creates duplicates appointments

Hi jayJay,

I'm not going to look through the whole code but what I think happens is that sinec you run the macro every time it will just add an appoitment, I think an options should be added, something like an extra column namen DONE and when the macro is run the cell in the column DONE should be given a value True() or a 1 to indicate it as done, so that when you run the macro again the column DONE cells where the valkue is not True() or is not 1 (dependign on waht you choose) is carried out.
This way you will avoid duplication.
Just an idea, happy coding.
 

1 more replies
Relevance 59.04%

I am using the MSN Stock Quote addin with MS Excel 2003. Prior knowledge of this should not be necessary, but I just thought I'd provide full context to my issue. I wrote a macro that essentially records daily stock prices. Because I don't want to store old quotes into perpetuity, i need to ensure that the update quotes button has been hit. I use sendkey() to accomplish this, and then the macro copies the quotes and pastes them elsewhere. My main goal is to have the task scheduler open this file daily so i dont ever have to think about this again, and i'm so close. Essentially my problem is that it takes a few seconds after the update button is hit for the add-in to fetch the new prices from the internet, and this process appears to be delayed until the macro is finished. This is a problem because the macro ends up recording un-updated quotes. I have tried the Application.Wait procedure, and I've tried time consuming loops, do while loops, etc. All of these approaches result in the same thing: Can someone please help me with this? I'm too lazy to hand update this spreadsheet every trading day for the rest of my life (or until i quit). Thank you in advance!
 

Answer:Excel Macro - Allow cells to update query before macro completes

Can't you just put the update macro code in a module of it's own and call it from the main macro?

Regards,
Rollin
 

1 more replies
Relevance 59.04%

I used to be happy with Works 2002 calendar reminders. They came on at startup without the program being on. Now I have Outlook 2003 and the reminders only work whem the program is on. Does anyone know how to automatically turn them on at startup without the rest of the program.
 

Answer:Outlook 2003 calendar reminders don't work without Outlook being turned on.

outlook needs to be up and running.

drag it into the startup folder, reboot.
 

3 more replies
Relevance 58.63%

Hi im trying to sort out a system for work that allows me to receive e-mails about 2 weeks before a piece of equipment is due to be calibrated. This runs on a yearly cycle but we have enough equipment to be doing this every week. I have set up an excel sheet with all the information on and currently have to scroll through this all manually which is time consuming. I noticed the thread

http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel-3.html

And this sounds like what I am after but I have no idea what any of the info means or where to start, can anyone help me please.

Or does anyone know of a good free software for asset tracking and data logging???
 

Answer:E-mail reminders from Excel

7 more replies
Relevance 58.63%

Hi guys! I've been looking on this forum for quite some time and I did find some useful information about creating outlook reminders in Excel. However, I didn't find exactly what I am looking for.

I need to create different reminders using information in the same line. I have attached an example of my document. I have 12 tabs, each representing a month. All upcoming groups are separating by their arrival date. Each group has either 1 or 2 deposits required by a certain date, And some groups have a rooming due by another date.

For exemple, in January, I have Montcorr coming. 1st deposit is due on 12/30, 2nd deposit on 01/02. The rooming list of due on 01/09. As for the deposits, I need to receive a reminder the day of. As for the rooming list, I need a reminder 3 days before the due date.

Can somebody please help me out? I know this might be a little complex... But thank you!!!
 

Answer:Set multiple reminders in Excel

14 more replies
Relevance 58.63%

Hi
i would appreciate some help with this.
i have a spreadsheet with delivery dates. i want the cell next to date highlighted when its due for delivery.
Please see the attached spreadsheet.

Thanks in advance.
 

More replies
Relevance 58.63%

Hi All,

I have a File in which i store all the billing records of my transmission circuits, but most of the times, i missed billing of some circuits or vendor didn't send the bill.

Is there any mechanism in Excel 2007 through which i get notified either via Popup or email or ballon notification about the missing bill?

An urgent help would be helpfull.

Azfar
 

More replies
Relevance 58.22%

I send invites to lots of all day events from my Outlook 2003 to users who have Outlook 2010. When I send these through I set them to not have reminders set. However, when they get accepted to Outlook 2010, it sets a reminder which means they are being woken up at 11.45pm by reminders for these events. I assume this is a compatibility thing between the two versions? Does anyone have any ideas on this?

This is becoming a real pain for our managers so any assistance that anyone can offer would be appreciated.

Thanks, Stephie
 

More replies
Relevance 58.22%

Hi friends,

I have not used Excel for ages apart from basic adding formulas etc.

What I am trying to do is make a set point (date) that turns a box red if one year has passed since the original date entered.
(not sure if I have explained it very well?)

ie
I am making a list of alarms on some machinery & want to show that the alarms have been tested within the past 12 months.
If I do not get around to testing, I would like the relevant field to change colour, so that a simple check upon opening the spreadsheet will tell me what is overdue on testing.(eventually there will be a lot of different alarms within the spreadsheet)
I am not sure if it will be easier to make an "issue date" then another field for "review date" or just have the one field that will turn red if today's date passes 365 from the last test date? (is that possible?)

I am sure it is easy - unfortunately, not for me!

keep the faith

Rob
 

Answer:Excel formula for annual reminders

You need to apply conditional formatting to the cell you want to change colour.

Condition is the formula type. Formula is

=today()>=(yourissuedatecell+365)

In the formatting, select fill colour to suit and any special borders / font formatting. Hit apply.

You can change the range affected by the formatting, but you might need to lock the column / row, depending on what you're trying to do.

No need for a due date field
 

3 more replies
Relevance 58.22%

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

Answer:Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

1 more replies
Relevance 58.22%

Hi There

I would like to set up an automatic email reminder for the attached workbook

I would like an email reminder to be sent 1 year prior to the expiry date in (COL F) then 3 months prior and then again when due
I would like to send the reminder to my own and potentially multiple emails.

To set up a macro as such would the programme and said file need to be open. every time the computer starts up?
 

More replies
Relevance 58.22%

I am trying to put together a reminder from a spread sheet to email me in say 3 months from a date in a specific cell. is this possible?
 

Answer:excel 07 setting email reminders?

will some one plaese tell me if this is possible?
 

1 more replies
Relevance 58.22%

Hey Everyone,

First post here. I was fallowing this thread:
http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

And i have a similar problem i could use some help with. Now that i think about it it might be harder than original thought of. I have a workbook with 12 sheets, one for each month. For each month i have a list of Magazines titles all in separate rows in one one column. to the right of those, i have each day of the day of the month. I have attached a sample spreadsheet of what i mean. On any day a sales rep will call me and book a day they want to send a email, or eBlast message to subscribers of the particular magazine they choose. I would love to have the option to have an automatic email send to each sales rep 5 days before ther scheduled booking is to be sent out, only problem is how would i extract the email address from a comment in excel, and have ti send a email to that person?

Another idea i had was to creative a booking sheet for which each sales rep would fill it out with fields such as Clients Name, Date to send email, Type of email, Geo targets, creative elements in email etc etc. is there a way that once i approve this and send back the excel file with an approved icon or logo and some notes, can it automatically, even without being open, send an email or reminder to the user i sent it to?

i greatly appreciate any comments as i know i most likely trying to ask for the world here.

Thanks!

Connor
 

More replies
Relevance 57.4%

Hello,
I have a excel through which I track the delivery schedules of a large number of IP's for a design.
I looking how I can automate in excel to send reminders to the IP Providers.
Based on the Actual delivery date, I need to automate the excel to send out reminders.
Please let me know how I can do this. If you need to look at the excel, I can send it.
Thanks
Nagesh
 

Answer:Sending Email Reminders to Different people from Excel

Hi Nagesh!
Wy did U put the same thread twice!
 

2 more replies
Relevance 57.4%

Hi!
I am using Excel to track many IP deliverables for a project. almost 100 IP's
In the excel I have Initial/current/Acutal/date of IP delivery.
Based on the Aligned(Actual) IP delivery scheduled date, I am looking at how to automatically send Email reminder to the IP Provider on or before the aligned from Excel.
Please do let me know how I can acheive this automation.

Thanks
Nagesh
 

Answer:Sending Email Reminders to Different people from Excel

16 more replies
Relevance 57.4%

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

Answer:Please Help ASAP: Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

1 more replies
Relevance 57.4%

Hi,

My excel sheet has 3 columns.

1st column has email ids
2nd column has has Name of employee
3rd column has their respecive DOB

My requiremnet is;

An auto generated email (saying "today is xyz, abc's birthday") should be sent to everyone in the list whenever there is someone's birthday.

Also, can this be achieved even if the excel sheet is closed? If we use the google spreadsheet and write some script for the auto alert? let me know if this is posible.

Please help

Rgds,
Saqib Khan
 

More replies
Relevance 57.4%

HiI want to ccreate a calender which shows all the months, days and dates.And when one click on a day of the month another box shows which explanes the task of the day.One should be able to combine different data with different dates.The box is on the same sheet as the calender.i.e. : Clicking on Thurday jan. 21. 2010, on the calender, the boxs shows information on tasks etc. done that specific day

Answer:combining calender dates with a Box In Excel

re: Clicking on Thurday jan. 21. 2010, on the calender, the boxs shows information on tasks etc. done that specific dayThis makes sense, although it would be helpful to know the extent of the "tasks" for that day. Are we talking about pages of tasks or a simple task like "Back Up Data"?re: One should be able to combine different data with different dates.What does this mean?

7 more replies
Relevance 56.99%

I am looking for help in writing a macro that will do the following.

With Excel 2003 open and the current workbook open. The macro should be able to save 3 variables from the current spreadsheet (some text, a value and a date ) The macro should open up Outlook 2003 as a task, attach the current workbook. In the Subject field of the task it should add the user's name, then the attached spreadsheet's filename then the text variable, then the value variable and finally the date.

Also it would be great if the Priority of the task could be set to High and the Start and Due dates set to 3 calendar days before the date variable.

Finally the macro would set a list of people the task is assigned to. The macro should NOT save the task as a check would need to be done manually.

I have tried unsuccessfully to write a macro in Outlook as I cannot seem to access the attachment filename or any data from the file. I have tried a macro in Excel which I can create a task and add some text to the Subject of the task but with no real progress on the attachment.

I have tried searching the net for help but a lot of code for Outlook is for the mail side of things rather than tasks and the little code snippets I have found have been of limited use. I have limited skills in programming Visual Basic and C so quite prepared to get my use code which does similar things
 

More replies
Relevance 56.99%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Enterprise, Service Pack 1, 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU E7500 @ 2.93GHz, x64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3037 Mb
Graphics Card: Intel(R) G41 Express Chipset, 1294 Mb
Hard Drives: C: Total - 305242 MB, Free - 67280 MB;
Motherboard: LENOVO, To be filled by O.E.M.
Antivirus: System Center Endpoint Protection, Updated and Enabled

hello

i am new here i might stumble a bit, my apologies in advance. i am a Marine engineer by profession and now i have been helping out in the office since we don't have a Technical Manager, my computer software skills are also limited that is why i need help.

i have 45 crew reporting to me with all sorts of certificates with different expiry dates. i have managed to compile an excel spreadsheet with their names including certificates but since i am in between operations and the office i need excel reminders to my emails and to one nominated person at least 60 days before expiry to avoid catastrophic shipping delays while people are revalidating their certificates.

please find attached spreadsheet with names and relevant certificates (highlighted in green). your assistance will be forever appreciated. i will be glad if i can able to do it by myself so when changes are needed i can just execute them. thank you in advance.
 

Answer:excel spreadsheet with expiry dates auto reminders

I would not be able to code this, but a coder would have needs/questions:

1. A worksheet with Name and Email address. This is so that info does not need to be hard-written into the code.
2. When do you want it emailed? When you open the file? Automatically, even if you don't open the file? With a button click by you?
3. What version of Excel and Outlook are you using?
 

1 more replies
Relevance 56.99%

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

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 56.58%
Question: Outlook reminders

I am using Outlook 2000 on a Windows 2000 operating system. When I get reminders, they pop up behind my open programs, the only way I can tell that I have reminders are if I look at my START bar and see the blue Outlook reminder flashing. How do I get my reminders to pop up on top of my open programs? Please help!
 

Answer:Outlook reminders

Sounds like your other program(s) might be set *on top*.

Have you tried running Detect and Repair under Outlook's Help menu?
 

1 more replies
Relevance 56.58%
Question: Outlook Reminders

HiI am setting up reminders for myself in outlook and marking them as 'private', but when a colleague opens my caelndar to book a meeting he can see that i have loads of notes (but not the contents). How can i set a reminder so i can see it in the calendar, but to anyone else it is invisible.I appreciate this could be done by setting up a 'task' - but then it isnt viewable in the calendar.thanks

Answer:Outlook Reminders

I think that you would need a second (Seperate)log on account to stop your colleague viewing your Calendar.

3 more replies
Relevance 56.58%
Question: outlook reminders

I am using outlook 2003. In my calendar I have a bunch of alarm set to remind me of things I have to do. When a reminder comes up I can pick snooze or dismiss. When I pick snooze I will not be reminded for the designated amount of time but sometimes I would like to see what my reminders are before my designated amount of time elapsed. Is there away of viewing these reminder before the snooze time is up.

thanx
 

Answer:outlook reminders

7 more replies
Relevance 56.58%
Question: outlook reminders

is there anyway to setup outlook to have the reminders from tasks and appointments flash on my screen even if outlook is not currently open???cheers for any help guys.....

Answer:outlook reminders

I haven't come across being able to get Outlook to remind you if it is not open. But if you start Outlook and minimize it to the taskbar any tasks, appointments that have a reminder set will be advised to you at the time you have specified.

2 more replies
Relevance 56.58%
Question: Outlook Reminders

I am just getting used to Outlook, is there a way that when I have reminders set, it notifies me even if I have Outlook closed? I use palm desktop and it will jump up on the desktop when nothing is open. Any ideas?
 

More replies
Relevance 56.58%

Outlook 2007 won't open the reminders. I have searched the web for solutions. Have done the scanpst.exe, outlook /cleanreminders and created a new personal folder and imported everything.No luck so could anybody please help?Many thanks,Tony

Answer:Outlook won't do reminders

I am still battling with this :-(

1 more replies
Relevance 56.58%
Question: Outlook reminders

Hi there.Whenever i open Outlook i get reminders from my calendar, most of which i cannot dismiss (cancel) or even open. This is annoying as they just build up and up.Anyone have any ides as to how i can close these reminders??

Answer:Outlook reminders

Open the calendar right click the occurrence select open, you will then have a choice of either open this occurrence or open this series. Once opened take the tick out of 'Reminder' which is about half way down the open window.

6 more replies
Relevance 56.58%
Question: outlook reminders

Help! When I open Outlook 2007, it reminds me about appointments, including one appointment which no longer exists on the calendar. When I try to dismiss the reminders, it tells me that it can?t dismiss the reminders, that there are errors in the Outlook0.ost file, and to run scanpst.exe to fix the errors. I run scanpst, but it does not fix the errors, which recur whenever I start Outlook.
 

More replies
Relevance 56.58%
Question: outlook reminders

I use outlook 2003 for my email and reminders. Some of my reminders have been snoozed for a couple of weeks. Is there a way I can look at my reminders that I have snoozed with out waiting for them to come due or without having to go track each one down individually.

thanx
 

More replies
Relevance 56.58%
Question: Outlook reminders

In my Outlook calendar, I deleted a calendar event whilst the reminder for that event was open.Now, every so often a reminder for that same event pops up, even though the event has been deleted.If I dismiss the reminder a dialogue box says, ?Cannot find the event, you may be reminded again?.How do I stop this reminder popping up for an event that I?ve already deleted?

Answer:Outlook reminders

Put the event back and delete reminder first?dont know if it will work though.

8 more replies
Relevance 56.58%

In Outlook there are emails that I'd like to popup at certain times. For example if an email says to send them a file at 5 pm today I'd like that email to show up at that time. How would I do that?

Secondly I often have something due at certain times of the day. Most of the time this isnt related to email but I'd still like a reminder in Outlook. So far I've been creating an Appointment in Outlook but that doesnt seem the correct way. Can anyone advise?

Best,
Dan
 

Answer:MS Outlook - how to set reminders

Hello, you can create new tasks which are basically "things to do"; you can set a time/date to start and finish, you can also set priorities and alerts.
Regards
The Cleaver
 

3 more replies
Relevance 56.17%

I have a list of personnell working for us and in one column is their Dates of Birth (DOB) in DD/MM/YY format, what I want to do is filter or show easily who's birthday is coming up in a give period of time. I've tried using the filter function but it only seems to work on the year and I can;t get it to filter on month. I'm using Excel 2007

Any ideas ?

Ian
 

Answer:Solved: Birthday reminders from a list of DOBs Excel 2007

6 more replies
Relevance 56.17%

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

Hi Everyone

I'am new here and have very little knowledge of VBA so hoping some of you experts can help me.

We have a workbook that was used to book desks on the floor we had in our office. The work book has a calendar that was used to book desks in advance to another Useform.

Recently we acquired two other floors and have several more desks available, so we are looking at adding two more userforns to the workbook to book desks on the other two floors.

I have added the extra new Userforms for the other two floors but cannot make the Calender work with these just the original 2nd floor. I'am told that its something to do with this code within the calender

This code here:
Code:
Private Sub CommandButton3_Click()
groundfloor.datebook = TextBox1
Cal1.Hide
End Sub
Can somebody take a look at this for me and if possible alter the code so the calender can be used with which ever floor Userform is selected for use.

The password for Overwrites if needed is Kate.

I have attached a cut down copy of the work book.

Thanks for any help in advance

Wolfie
 

Answer:Linking a userform calender to other userforms within an Excel Workbook.

Goodmorning Wolfie and welcome to the forum,
I'll pick up the file and take a look later this afternoon, I don't think it's that difficult but let me take a look first, all simple things turn out more complicated thatn see at first sight
I see nobody has picked this up since you posted it (July 10), is it still an issue?
 

1 more replies
Relevance 55.76%

The follow up reminders I that I enter on sent mail do not show up on the pop up Reminders window.The Reminders window does however show reminders for Inbox,Calender and Tasks. Can you please help me to get the follow up reminders for sent mail into the Reminder window?
 

Answer:Outlook 2003 Sent Reminders

Reminders only work in the Inbox e-mail folder. They do not work in other folders.
 

1 more replies
Relevance 55.76%

I would like to put reminders in Outlook, somewhat like scratch notes on a particular day. There doesn't seem to be any way to do exactly what I want to do.

Here's an example. One of my staff puts in for a day off in a couple of weeks. I want to log this somehow so that I remember it. I can put it as an appointment in my calendar, but that's kind of dumb, it looks like "Joe on leave" is an appoinment of mine, which it's not. I can also put this in as a task with a due date of the day he's gone, but then I don't see it on my weekly or monthly view calendar, and won't be reminded of it till the day it actually happens. Lastly, I can have him share his schedule with me, but that means having to look at it every day or a week ahead of time, which is a bother (particulary if one has a large staff). Also, the latter solution has the same problem of not appearing in my weekly or monthly calendar view.

Any ideas? I have a sinking feeling this one is just not possible. It's the kind of thing that would be natural to just jot down on an old fashioned paper based calendaring system... "Joe on leave" over in the margins on the exact day that it happens, but there doesn't seem to be any equivalent of "margins" with Outlook.
 

Answer:(Solved) Reminders with Outlook

it is a bit frustrating, but I found a compromise. Put it in as a meeting request, but instead of specifying a time, check the box that syas "All Day Event" This will place the "Bob's Vacation Day" at the top of the Day, and bolded, just the same as National Holidays are. You can still set the reminder for anywhere from 5 minutes to 2 days.

Hope this helps
 

2 more replies
Relevance 55.76%

I'm using Outlook XP and I was curious how to make it remind me about calendar events - even when outlook wasn't running. Is it possible or does outlook have to be open 24/7?

Thanks!
 

Answer:Outlook XP: Using Reminders (why don't they remind!)

anybody?
 

3 more replies
Relevance 55.76%

How can I set-up MS Outlook so that all reminders appear in one "box" (a reminder list) vs. individual pop-up reminders? I know this is an option because my computer at home does it this way (one reminder list) while my computer at work shows them separately...but I haven't been able to discover how to implement this option.
 

Answer:Microsoft Outlook Reminders

7 more replies
Relevance 55.76%

Using Vista and Outlook 2007. I can't get rid of the old reminders. They continue to pop up. I'm up to 82 of them and even though the event has long passed. It still pops up. I can dismiss them, but next time I open Outlook, they are all back.

Please help.
 

Answer:Can't Clear Reminders Outlook 07

http://www.tech-recipes.com/rx/2161/outlook_2007_clean_up_command_line_switches/
 

2 more replies
Relevance 55.76%

Recently my reminders produced by Outlook 2010 have begun to appear in duplicate.Would anyone know how I can stop this ?

Answer:Why are my Outlook reminders duplicating ?

http://answers.microsoft.com/en-us/...

5 more replies
Relevance 55.76%

Using Outlook 2002 at work.
I have used Calendar Reminders for years, but this new PC with Office 2002 has something set wrong somewhere. None of my reminders work on the PC. I know the reminders are set on the Exchange Server correctly, since I can go to my mail via "Outlook on the Web" and the reminders do happen.

But they are not appearing on the PC.
I have checked Tools>Options,Other, [Advanced Options], [Reminder Options]
and made sure the "Display the reminder" is checked.
I even shut it off, rebooted, and then went back and set the option on again (in case the 'bit' was stuck).
That didn't clear it up either.
 

Answer:Outlook reminders not happening

FIXED!
Another forum suggested the Microsoft Knowledge Base article:
KB 286166 "Outlook Calendar and Task reminders do not appear as expected in Outlook 2002 and Outlook 2003"

Which tells you to enter outlook /cleanreminders at a DOS prompt, and that fixed it AFTER I then rebooted.

Cool!
 

1 more replies
Relevance 55.76%

Running Office XP Pro in Win XP SP3.I thought, but may well be wrong, that in the past that I had set up Outlook so that I would get appointment reminders pop up even when Outlook wasn't open. But I can't find a way of doing it since I had a reload.Is my memory playing me up (quite possible) or am I missing some setting?

Answer:Outlook Calendar Reminders

I think your memory's playing up. If Outlook isn't running it won't produce reminders

10 more replies
Relevance 55.76%

At work we have just upgraded from Outllok 97 to Outlook2003. Now in outlook 97 when you had an appontment a pop-up reminder could be made to appear in top of whatever you were doing so you got the message. But in the 2003 version the pop-up just lurks behind whatever you are doing without coming to the fore. So it may be hours before you notice this reminder which is now telling you that you should have been elsewhere two hours ago.

So is there anyway of making the reminder take the focus away from whatever else you are working on so you at least get chance to see it because it's as much use as a chocolate fireplace if it just hides in the background.
 

Answer:Outlook 2003 reminders

Don't use Outlook, but does it not "blick" at you down in the taskbar?
 

22 more replies
Relevance 55.76%

Hi- running windows 7 and outlook 2007. Recently when I get the reminders from outlook they come as duplicates in the same reminder window. If I have one reminder it shows twice, if I have two remiders each one shows up twice. Any ideas,
thanks in advance.
Barry
 

More replies
Relevance 55.76%

You know that reminder window that comes up when an appointment or task is due? I like this feature but one thing I dont like about it is. I dont know how many times I have clicked snooze for 1 hour and in the next five minutes I would love to view that reminder window again. Is there some way I can make it come up again... before the 1 hour snooze is up?

thanx
 

Answer:outlook 2003 reminders

have you tried clicking on : view>reminders window?
 

1 more replies
Relevance 55.76%

I am currently running Win XP and Outlook Express. I would like reminders of Birthdays and important dates. Can it be done with this software? or do I have to download additional software? or will I just have to bite the bullet and update Outlook Express. Suggestions would be appreciated. Mo

Answer:Outlook Express Reminders

You have a programme called Microsoft Outlook this has the diary and everything else you require.It's quite sophisticated but worth persevering with.MICROSOFT OUTLOOKNOTOUTLOOK EXPRESSSTART/ ALL PROGRAMMES/ MICROSOFT OUTLOOKYou may already have a shortcut on the task bar

1 more replies
Relevance 55.76%

In my job, I have to answer someone else's emails, so there are two email accounts on my computer--mine and theirs. Both computers have MS Outlook 2010. I can also see their calendar to add appointments. However, the calendar appointment reminders have merged and need to be separate. Can someone direct me in un-merging them?
 

More replies
Relevance 55.76%

Already tried the clean reminders switch. Used MFCMAPI to get rid of them, but every new appointment created ends up not being deleteable. Anyone have any ideas?
 

More replies
Relevance 55.76%

I have a user here are work and his reminders for calendar appointments are not working. I have tried to repair, reinstall, and download the available updates for Office 2003. None of this has resolved the issue. Any help would be greatly appreciated.
 

Answer:Outlook 2003 Reminders

Had same with one of my users... under start/run type outlook /cleanreminders
worked on our machine.
 

1 more replies
Relevance 55.76%

Hey all,

I have and end user who frequently has an outlook reminder pop up and quite literally pulses (window appears and disappears rapidly). She has already dismissed this reminder but it keeps coming back. In order to get it to stop she has to maximize outlook and then minimize it again. Then she can close the reminder. I have tried going in and removing the reminder but it still comes back. I have also reinstalled office on her machine with no effect. Any Ideas?
 

More replies