Link to home
Start Free TrialLog in
Avatar of Troy Hector
Troy HectorFlag for United States of America

asked on

Remove birthday entries from Outlook 2007 Calendar

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?
Avatar of Tony Giangreco
Tony Giangreco
Flag of United States of America image

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.
Avatar of Troy Hector

ASKER

@TG-TIS - My client receives a monthly CSV file with his client data from the CRM company that he then imports into Outlook.
Ok, then the company that maintains the app that creates the CRV needs to make the modification. They control the data,
@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.
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.
@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.
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/
@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.
I'm sorry, I don't have that expertise.
@TG-TIS - No worries.  I truly appreciate your efforts.
Anyone else have any ideas?
ASKER CERTIFIED SOLUTION
Avatar of David Lee
David Lee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@BlueDevilFan,

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

Thanks!
You're welcome!