Solved

Outlook and importing from excel - set the reminder

Posted on 2014-10-24
6
679 Views
Last Modified: 2014-10-26
Experts,

I am importing calendar entries into Outlook from excel.  I am having a tough time setting any reminder.  It continually defaults to 15 minutes.  

I have read a post and the mapping is something to pay attention to and I have checked my mapping and it is correct.  I also understand that the reminder needs to first be turned on.  I have also turned it on by using TRUE as shown below.

What else am I missing?  

Reminder      Reminder on/off
1 week               TRUE
2 days               TRUE
0
Comment
Question by:pdvsa
  • 4
  • 2
6 Comments
 
LVL 5

Expert Comment

by:Flora
Comment Utility
someone had similar issue and the case was resolved in EE  .  see this thread http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28535879.html
0
 

Author Comment

by:pdvsa
Comment Utility
Hi, thanks for the response.  The question was actually asked by me :)

I have it mapped out correctly.  I am using the same names as the mapped fields in OL.

Any other ideas?
0
 

Author Comment

by:pdvsa
Comment Utility
I dont know if you could try a simple import into OL and let me know how to set the reminder correctly.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 5

Accepted Solution

by:
Flora earned 500 total points
Comment Utility
once you import the calendar you can change it in bulk   look at this video tutorial

http://www.youtube.com/watch?v=h6qF2HFg_Mg
0
 

Author Closing Comment

by:pdvsa
Comment Utility
Perfect.  Thank you very much.
0
 

Author Comment

by:pdvsa
Comment Utility
one note is that you have to make sure the alarm is turned on or else even after you change the notify beforehand, it will not work.  When switching to list view in OL, per the video, you can see they do not  make this point and it would have been more clear if the author of the video included "alarm" as one of the fields to drag in to see if it was turned on.  

I dont believe OL has a field "remind beforehand" and even though my mapping is correct with Reminder ON/OFF, Reminder Date, and REminder Time and formatted as time or date it still does not import a reminder any other time than 15 minutes.  Odd.  I think "remind beforehand" should be a field to map to but it is not.  

thank you.  I can make the changes in bulk as you prescribed.  it works.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Get an idea of what you should include in an email disclaimer with these Top 5 email disclaimer tips.
Set OWA language and time zone in Exchange for individuals, all users or per database.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now