Importing events from Excel, Please help

  • Thread starter Thread starter mashadi
  • Start date Start date
M

mashadi

I have an Excel file with names of ships, dates and ports of arrival

How can I import these into Outlook, so that on each date outlook will show
the "Port" and the name of the Ship.

I converted the file to CSV, but the import function does not recognize the
dates.

Any help will be greatly appreciated.

Isaac
 
I'd map the Port field to Location and the Ship name to Subject, but you
might reverse that.

There is no need for the extra step of exporting to .csv. You do, however,
need to set a named range in the Excel worksheet to cover all the data you
want to import.
 
Sue said:
I'd map the Port field to Location and the Ship name to Subject, but you
might reverse that.

There is no need for the extra step of exporting to .csv. You do, however,
need to set a named range in the Excel worksheet to cover all the data you
want to import.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
Click to expand...
 
Thank you so much for your help.

When I try to map it, the date field shows as F1 , instead of the
first date in the field. And after importing, nothing shows in the
calendar.

any suggestion?

Thanks in advance,

Isaac
 
Did you include the header row from your spreadsheet in the named range?
That makes the mapping process much easier.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Yes Sue,

I have tried it both ways.

For some reason, Dates are not recognized as dates.

I have tried formatting the date field in a lot of different formats.

Thanks anyway.

Isaac
 
Which date field are you trying to import into?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



mashadi said:
Yes Sue,

I have tried it both ways.

For some reason, Dates are not recognized as dates.

I have tried formatting the date field in a lot of different formats.

Thanks anyway.

Isaac

Sue Mosher said:
Did you include the header row from your spreadsheet in the named range?
That makes the mapping process much easier.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



mashadi said:
Thank you so much for your help.

When I try to map it, the date field shows as F1 , instead of the
first date in the field. And after importing, nothing shows in the
calendar.

any suggestion?

Thanks in advance,

Isaac

Sue Mosher [MVP-Outlook] wrote:
I'd map the Port field to Location and the Ship name to Subject, but
you
might reverse that.

There is no need for the extra step of exporting to .csv. You do,
however,
need to set a named range in the Excel worksheet to cover all the
data you
want to import.

I have an Excel file with names of ships, dates and ports of arrival

How can I import these into Outlook, so that on each date outlook
will
show the "Port" and the name of the Ship.

I converted the file to CSV, but the import function does not
recognize
the dates.
Click to expand...
Click to expand...
Click to expand...
 
When mapping, there is only one field called date.

Isaac

Sue Mosher said:
Which date field are you trying to import into?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



mashadi said:
Yes Sue,

I have tried it both ways.

For some reason, Dates are not recognized as dates.

I have tried formatting the date field in a lot of different formats.

Thanks anyway.

Isaac

Sue Mosher said:
Did you include the header row from your spreadsheet in the named range?
That makes the mapping process much easier.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



Thank you so much for your help.

When I try to map it, the date field shows as F1 , instead of the
first date in the field. And after importing, nothing shows in the
calendar.

any suggestion?

Thanks in advance,

Isaac

Sue Mosher [MVP-Outlook] wrote:
I'd map the Port field to Location and the Ship name to Subject, but
you
might reverse that.

There is no need for the extra step of exporting to .csv. You do,
however,
need to set a named range in the Excel worksheet to cover all the
data you
want to import.

I have an Excel file with names of ships, dates and ports of arrival

How can I import these into Outlook, so that on each date outlook
will
show the "Port" and the name of the Ship.

I converted the file to CSV, but the import function does not
recognize
the dates.
Click to expand...
Click to expand...
Click to expand...
 
On the Outlook side, you should see a choice of Start Date, End Date, and
Reminder Date. Which are you using as the target?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers



mashadi said:
When mapping, there is only one field called date.

Isaac

Sue Mosher said:
Which date field are you trying to import into?

mashadi said:
Yes Sue,

I have tried it both ways.

For some reason, Dates are not recognized as dates.

I have tried formatting the date field in a lot of different formats.

Thanks anyway.

Isaac

Did you include the header row from your spreadsheet in the named
range? That makes the mapping process much easier.

Thank you so much for your help.

When I try to map it, the date field shows as F1 , instead of the
first date in the field. And after importing, nothing shows in the
calendar.

any suggestion?

Thanks in advance,

Isaac

Sue Mosher [MVP-Outlook] wrote:
I'd map the Port field to Location and the Ship name to Subject, but
you
might reverse that.

There is no need for the extra step of exporting to .csv. You do,
however,
need to set a named range in the Excel worksheet to cover all the
data you
want to import.

I have an Excel file with names of ships, dates and ports of arrival

How can I import these into Outlook, so that on each date outlook
will
show the "Port" and the name of the Ship.

I converted the file to CSV, but the import function does not
recognize
the dates.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top