Solved

Remove birthday entries from Outlook 2007 Calendar

Posted on 2014-04-07
15
278 Views
Last Modified: 2014-10-27
I have a client who imports data from a CRM system into his Outlook.  Part of the data that is imported is the contacts birthday.  When this import happens, the birthdays are placed on the calendar.  My client wants to retain the birthday info with the contact but not have them populate the calendar.  Can this be done?
0
Comment
Question by:Yort
  • 7
  • 5
  • 2
15 Comments
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 39984313
There must be an application your client is using to import that data. The application should be reviewed to see of that Birthdate Import can be commented out of the code.

You didn't mention what application is being used for the data import. Whoever wrote that application has the ability to make that change.
0
 
LVL 1

Author Comment

by:Yort
ID: 39984334
@TG-TIS - My client receives a monthly CSV file with his client data from the CRM company that he then imports into Outlook.
0
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 39984392
Ok, then the company that maintains the app that creates the CRV needs to make the modification. They control the data,
0
 
LVL 1

Author Comment

by:Yort
ID: 39984400
@TG-TIS - My client doesn't want the birthday data omitted from the CSV.  Rather, they want the birthday info to stay with the contact information, just not have it auto-populate the calendar.
0
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 39984421
Actually, whatever app you use to import the data into the calendar is what has to be modified. I suggest contacting the person or company that wrote that import application to make the modifications. it could be a VB script, a c# app or any other type of app that was written.  This is a programming change. if you are not a programmer, you don't have any programming experience, you probably should consult with the proper person to make sure it works as the client expects.
0
 
LVL 1

Author Comment

by:Yort
ID: 39984433
@TG-TIS - The program being used to import the CSV is Outlook itself.  There is no other import application being used.  The setting, from my understanding, is somewhere in Outlook but I haven't yet been able to find it.  I am a bit familiar with programming.
0
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 39984454
Here is how you create a calendar import
•Open Microsoft Outlook
•Select FILE >>> IMPORT AND EXPORT...
•Select "Import from another program or file" and click Next.
•Select "Comma Separated Values (Windows)" and click Next.
•Find the .csv file you just downloaded and select "Do not import duplicate items" then click Next.
•Select Calendar and click Next.
•The next window will have a title that says 'The following actions will be performed:' above an option to 'Import the "(filename).csv" into folder: Calendar.'
•Check that box and and click on 'Import "(filename).csv" into folder: Calendar'
•From there, click and drag needed fields from the left window into the right window. It is fairly self-explanatory, but the basic corresponding fields are below:

SUBJECT to Subject
 START_DATE to Start Date
 START_TIME to Start Time
 END_TIME to End Time
 DESCRIPTION to Description
 LOCATION to Location

•And if you'd like Outlook to place a reminder: REMINDER_ON_OFF to Reminder On/Off
•Click OK
•Then Click Finish
http://www.ohiostatebuckeyes.com/ot/schedule-downloads-prevoutlook.html

Export and Import Outlook Calendars

Export a Calendar File from Outlook

Outlook 2010 and 2013 (Windows)

1.Open Outlook. Select the File tab and click Open (in Outlook 2013, click Open & Export).


2.Click Import (in Outlook 2013, click Import/Export).


3.Select "Export to a file." Click Next.


4.Select "Comma Separated Values (Windows)." Click Next.
 Note: To export recurring appointments or tasks, select "Outlook Data File (.pst)" and follow the prompts. These instructions assume you have selected "Comma Separated Values."


5.In the folder list, select the Calendar folder to export. Click Next.


6.Click Browse, enter a file name and click OK. Click Next.


7.Optional: Click Map Custom Fields to specify what fields are exported.


8.Click Finish. (In Outlook 2010, you will be prompted to create an optional password. Click OK, and do not click Cancel.)


9.Enter a date range. Click OK.


Outlook 2011 (Mac)

1.Open Outlook. Click Calendar and select the calendar you wish to export.


2.Click File and Export. Select "Outlook for Mac Data File (.olm)."


3.Click "Items of the following types," and ensure that only the Calendar box is checked. Click the advance arrow.


4.Click "No, do not delete items" when prompted.


5.Save the .olm file to your computer.


Import a Calendar File to Outlook

Outlook 2010 and 2013 (Windows)

Internet Calendar (.ics) files can be imported to Outlook by double-clicking the file. For other file types:

1.Open Outlook. Select the File tab and click Open (in Outlook 2013, click Open and Export).


2.Click Import. In Outlook 2013, click Import/Export, click "Import from another program or file" and click Next.


3.Select "Comma Separated Values (Windows)" as the import file format. Click Next.


4.Click Browse and select the file to import. Click OK.


5.Select options for handling duplicate events. Click Next.


6.Select the Calendar as the destination folder. Click Next.


7.Optional: Click Map Custom fields to specify what fields are imported or change the destination folder.


8.Click Finish.


Outlook 2011 (Mac)

Outlook for Mac (.olm) and Internet Calendar (.ics) files can be imported to Outlook by double-clicking the file.

https://techarticles.uark.edu/calendar/export_and_import_outlook_calendars/
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 1

Author Comment

by:Yort
ID: 39984459
@TG-TIS - I appreciate your responses but I think you missed my main point.  We are not doing a calendar import; we are doing a contacts import that contains birthdays which Outlook auto-populates to the Outlook calendar.
0
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 39984468
I'm sorry, I don't have that expertise.
0
 
LVL 1

Author Comment

by:Yort
ID: 39984479
@TG-TIS - No worries.  I truly appreciate your efforts.
0
 
LVL 1

Author Comment

by:Yort
ID: 40001777
Anyone else have any ideas?
0
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 40406112
Hi, Yort.

What you're client is looking for is a setting that tells Outlook not to put the birthdays on the calendar.  I'm not aware of any such setting.  The only solution I know of that will allow the client to keep the birthdays without putting them on the calendar is to take the birthday out of the Birthday field and put it in, for example, the Notes field.
0
 
LVL 1

Author Closing Comment

by:Yort
ID: 40407140
@BlueDevilFan,

That is what I am finding also. Having a second opinion is what I needed.

Thanks!
0
 
LVL 76

Expert Comment

by:David Lee
ID: 40407169
You're welcome!
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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 …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 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

16 Experts available now in Live!

Get 1:1 Help Now