noobdeli.blogg.se

1. Import csv contacts into outlook 2003 software#
2. Import csv contacts into outlook 2003 Pc#
3. Import csv contacts into outlook 2003 mac#
4. Import csv contacts into outlook 2003 windows#

Note, however, that any special characters that require UTF-8 encoding will not show correctly (or at all). Save the file with "Encoding: ANSI".ĭouble-click it to open in Outlook and you should see it open without any trouble. Notice the file is in UTF-8 (or perhaps Unicode)? Outlook chokes on this. Be certain your Word Wrap is turned-off under the Format menu.

Import csv contacts into outlook 2003 windows#

ics file with Notepad on Windows (any version of Windows).

There's a great deal of Red Herring -chasing going on here and so I felt compelled to share: You may be able to delete some more of the lines and it shouldn't take too much effort to work out what the lines do and the format RRULE:FREQ=WEEKLY UNTIL=20100531T000000Z INTERVAL=1 BYDAY=FR WKST=MO (these previous 3 lines are all one line) PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN I found it necessary to save it in DOS format, not Unix.Īs a mimiumum I've found the following lines necessary: Open the file using your favourite text editor and gradually work through the file deleting lines, saving the file and then double clicking on it until you get the minimum content that will work. Set up an appointment in outlook similar to those that you are trying to import. I've been having trouble getting this to work as well and in the end I decided to let Outtlook do the hard work for me. So, my point is, like Joe said, look at the end-of-line characters, and make sure that your file isn't having those changed by whatever process you're using - in my case, the encoding method for the email attachment. the encoding technique in the email attachment made the difference. But I suspect it's Outlook doing it when the email is received.Īnyway, when I changed the text encoding in MIME::Lite from quoted-printable to base64, Outlook liked the attachments - no more error. Actually, I can't be sure Outlook is doing that in the received email - it might be an artifact of me saving the attachment to a file, uploading it to my webserver, downloading to my Mac, and running the "od" utility to examine the file. (CR = carriage return, LF = line feed these are two different ASCII characters.) The iCal spec calls for CR-LF, and the Perl module appears to be doing that correctly but Outlook is adding an extra CR. ics files, it looks like Outlook is changing the line terminators from CR-LF to CR-CR-LF.

Import csv contacts into outlook 2003 software#

(The software sends an email with an iCal attachment.) I tried everything in the comments above, but kept getting the Lunar/Gregorian error message from Outlook when I double-clicked the calendar attachments in the emails that were sent to me from Perl. I'm doing this to add a feature to the web-based software I'm working on.

Here's how I fixed the problem.įirst, I'm generating these ics files in Perl using the Data::ICal perl module, and emailing them using MIME::Lite, similar to the guy at. I think Joe in the previous comment was on the right track, at least for me. Thanks for this blog, Scott, I come here frequently to check the Swamp Drain gauge. Select all and drag them to your Public Folders calendar (hold down Option to Copy instead of Move). Switch to Calendar view and create a new Custom View with Item Type "Calendar events," Location "This Calendar" and the name of the personal calendar you created during the Outlook import process, and Criteria "Category is None" which will match all of the imported events. First create your Public Folder calendar (if it doesn't exist already) and Add it to your Favorites. I actually wanted the calendar to be a Public calendar in Exchange but you can't import directly to a Public Folder, and it didn't appear that you could move a personal calendar to the Public Folder space, AND I don't know an easy way to select all of the items in a calendar and copy them to another calender in Outlook, so. Timezone information came through correctly but my user thought it had gotten some of the start days for multi-day, all day events wrong, YMMV. If all you want to do is get the data into Outlook, you're done. Launch Outlook and import the CSV file into a new personal Calendar folder (or into your existing calendar if you want to merge the data). Export from Sunbird into "Outlook CSV" format (I tried Sunbird export to. ics file into Mozilla's Sunbird (I used the latest 0.7 release).

Import csv contacts into outlook 2003 Pc#

ics file and move it to a Windows PC (or, like I did, launch XP in Parallels).

Import csv contacts into outlook 2003 mac#

Here's one workaround that just worked for me for a one-time export of a Mac iCal calendar and import into Outlook 2003 (and ultimately to a shared Public Calendar in Exchange Server 2003 that could be accessed via Entourage).