| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Spreadsheet to Outlook
I have a list of birthdays in Excel that I would like to transfer to
someone's Outlook calendar. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
Yes, this is possible. Use the import function in Outlook.
Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
I think I'm missing a step. I defined the names in the spreadsheet (name and
birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
These are the steps:
-Import from another file or program -Select the format of the file as Tab Separated (Windows) -Browse to your excel file (that you have converted to tab separated). -select destination folder as contacts -click finish. If you use header names in your excel file that match closely to outlook names then you should not need to map any fields. Does this help? -- Stacy MCDST "jravens" wrote: I think I'm missing a step. I defined the names in the spreadsheet (name and birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
I just reread your post. I thought it was contacts instead of calendar. Let
me look into this. -- Stacy MCDST "jravens" wrote: I think I'm missing a step. I defined the names in the spreadsheet (name and birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
yes, it does work. the year is tricky though. you may have to play with
that a little bit. -- Stacy MCDST "jravens" wrote: I think I'm missing a step. I defined the names in the spreadsheet (name and birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
How do I map the custom fields? I dragged the value over to Start Date, but
the OK on the bottom of the screen stays greyed out. "srd" wrote: yes, it does work. the year is tricky though. you may have to play with that a little bit. -- Stacy MCDST "jravens" wrote: I think I'm missing a step. I defined the names in the spreadsheet (name and birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
It must not like your date format or something. What does your date look
like in your file? Is it a complete date like 4/21/2009? It may not take it unless you include a year. If you include the year, the next problem might be to make it recurring. -- Stacy MCDST "jravens" wrote: How do I map the custom fields? I dragged the value over to Start Date, but the OK on the bottom of the screen stays greyed out. "srd" wrote: yes, it does work. the year is tricky though. you may have to play with that a little bit. -- Stacy MCDST "jravens" wrote: I think I'm missing a step. I defined the names in the spreadsheet (name and birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Spreadsheet to Outlook
In order to set up your Import properly, I suggest that you enter one of
the birthdays manually into Outlook Calendar, THEN Export the week that contains it to a CSV file. Open that file and use it as an example to configure your Birthday file from. Then Import the properly configured file. jravens wrote: How do I map the custom fields? I dragged the value over to Start Date, but the OK on the bottom of the screen stays greyed out. "srd" wrote: yes, it does work. the year is tricky though. you may have to play with that a little bit. -- Stacy MCDST "jravens" wrote: I think I'm missing a step. I defined the names in the spreadsheet (name and birthday). When I get to the step to import, I'm not sure what to do. Would I drag Birthday to Start Date and Name to Subject? Thanks for pointing me in the right direction. "srd" wrote: Yes, this is possible. Use the import function in Outlook. Try to import as an excel document first. If that doesn't work, save the document as tab separated (delimited) and retry. It worked for me. -- Stacy MCDST "jravens" wrote: I have a list of birthdays in Excel that I would like to transfer to someone's Outlook calendar. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an Outlook msg into an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| Automatic email from Outlook of excel spreadsheet | Excel Discussion (Misc queries) | |||
| can you link outlook to an excel spreadsheet?? How!! | Excel Discussion (Misc queries) | |||
| Outlook Calender to Excel Spreadsheet | Excel Worksheet Functions | |||
| HOW DO I TRANSFER DATA FROM EXCEL SPREADSHEET TO OUTLOOK | Excel Discussion (Misc queries) | |||
Hybrid Mode
