|
|
| Next: Embedded Draft Image Cannot Be Removed |
| Author |
Message |
akm External

Since: Apr 02, 2005 Posts: 34
|
Posted: Fri Sep 18, 2009 11:47 am Post subject: Why getting dup contact field data when import Excel to Outlook ? Archived from groups: microsoft>public>outlook>contacts (more info?) |
|
|
Trying to import Excel contact list into Outlook.
When get to OUtlook 'map custom fields' from Excel file range, the zip code
field shows up as a cell reference (F6) in the 1st contact, and for the
'next' contact (and all after that) it shows up as the state name.
So, both the state and the zip code fields show up with the state name
(except for the first contact, which shows up as a cell ref 'F6'), ie...
name
address
city
state
state (in 1st record shows up as cell ref 'f6', which is not in the 1st
contact row in Excel)
phone
When 'finish' all imports just fine, except all the state and zip code
fields both have the state name in them (except the 1st contact has the 'F6').
Ideas?
--
Thanks again for your help.
akm(XPpro,SP-2,IE-7,Office2003) |
|
| Back to top |
|
 |
akm External

Since: Apr 02, 2005 Posts: 34
|
Posted: Sat Sep 19, 2009 1:12 pm Post subject: RE: Why getting dup contact field data when import Excel to Outlook ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
Ps: Forgot to ask... please let know if there may be a better place to ask
this question ?
--
Thanks again for your help.
akm(XPpro,SP-2,IE-7,Office2003)
"akm" wrote:
> Trying to import Excel contact list into Outlook.
>
> When get to OUtlook 'map custom fields' from Excel file range, the zip code
> field shows up as a cell reference (F6) in the 1st contact, and for the
> 'next' contact (and all after that) it shows up as the state name.
>
> So, both the state and the zip code fields show up with the state name
> (except for the first contact, which shows up as a cell ref 'F6'), ie...
>
> name
> address
> city
> state
> state (in 1st record shows up as cell ref 'f6', which is not in the 1st
> contact row in Excel)
> phone
>
> When 'finish' all imports just fine, except all the state and zip code
> fields both have the state name in them (except the 1st contact has the 'F6').
>
> Ideas?
>
> --
> Thanks again for your help.
> akm(XPpro,SP-2,IE-7,Office2003)
> |
|
| Back to top |
|
 |
Diane Poremsky [MVP] External

Since: Jul 28, 2005 Posts: 6715
|
Posted: Sat Sep 19, 2009 4:20 pm Post subject: Re: Why getting dup contact field data when import Excel to Outlook ? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
It sounds like the spreadsheet isn’t properly formatted - if its properly
set and up and filled out, the state and zips will be in their own column.
You need to fix the spreadsheet so the fields are corrrect.
--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205
"akm" <akm DeleteThis @discussions.microsoft.com> wrote in message
news:BBEF510B-CE62-4A73-8AFA-AD6FBF7A99A2@microsoft.com...
> Trying to import Excel contact list into Outlook.
>
> When get to OUtlook 'map custom fields' from Excel file range, the zip
> code
> field shows up as a cell reference (F6) in the 1st contact, and for the
> 'next' contact (and all after that) it shows up as the state name.
>
> So, both the state and the zip code fields show up with the state name
> (except for the first contact, which shows up as a cell ref 'F6'), ie...
>
> name
> address
> city
> state
> state (in 1st record shows up as cell ref 'f6', which is not in the 1st
> contact row in Excel)
> phone
>
> When 'finish' all imports just fine, except all the state and zip code
> fields both have the state name in them (except the 1st contact has the
> 'F6').
>
> Ideas?
>
> --
> Thanks again for your help.
> akm(XPpro,SP-2,IE-7,Office2003)
> |
|
| Back to top |
|
 |
akm External

Since: Apr 02, 2005 Posts: 34
|
Posted: Sat Sep 19, 2009 4:20 pm Post subject: Re: Why getting dup contact field data when import Excel to Outlook [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
Thanks for the reply.
Checked formating, all cells are same and Zip Codes are in one column just
like all other fields.
--
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003)
"Diane Poremsky [MVP]" wrote:
> It sounds like the spreadsheet isn’t properly formatted - if its properly
> set and up and filled out, the state and zips will be in their own column.
> You need to fix the spreadsheet so the fields are corrrect.
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> Outlook Tips by email:
> mailto:dailytips-subscribe-request@lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
> Do you keep Outlook open 24/7? Vote in our poll:
> http://forums.slipstick.com/showthread.php?t=22205
>
> "akm" <akm.RemoveThis@discussions.microsoft.com> wrote in message
> news:BBEF510B-CE62-4A73-8AFA-AD6FBF7A99A2@microsoft.com...
> > Trying to import Excel contact list into Outlook.
> >
> > When get to OUtlook 'map custom fields' from Excel file range, the zip
> > code
> > field shows up as a cell reference (F6) in the 1st contact, and for the
> > 'next' contact (and all after that) it shows up as the state name.
> >
> > So, both the state and the zip code fields show up with the state name
> > (except for the first contact, which shows up as a cell ref 'F6'), ie...
> >
> > name
> > address
> > city
> > state
> > state (in 1st record shows up as cell ref 'f6', which is not in the 1st
> > contact row in Excel)
> > phone
> >
> > When 'finish' all imports just fine, except all the state and zip code
> > fields both have the state name in them (except the 1st contact has the
> > 'F6').
> >
> > Ideas?
> >
> > --
> > Thanks again for your help.
> > akm(XPpro,SP-2,IE-7,Office2003)
> >
> |
|
| Back to top |
|
 |
Diane Poremsky [MVP] External

Since: Jul 28, 2005 Posts: 6715
|
Posted: Sat Sep 19, 2009 5:41 pm Post subject: Re: Why getting dup contact field data when import Excel to Outlook [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
So its all laid out like this? http://slipstick.me/importlist
Saving it as CSV or tab delimited text file from Excel and viewing the file
in notepad might give you some clues. Actually - save it as CSV, look at the
data and verify the fields/columns look like they should be ok and try
importing the CSV.
If that doesn't work, would you mind sending the spreadsheet to diane at
slipstick dot com? Any content in the sheet will be NDA or you can use
Excel's Fill command to replace the data but if the problem is with corrupt
data, filling it will probably fix it.
--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205
"akm" <akm.RemoveThis@discussions.microsoft.com> wrote in message
news:D1A65FA7-54BD-4FF7-9488-7090933581FA@microsoft.com...
> Thanks for the reply.
> Checked formating, all cells are same and Zip Codes are in one column just
> like all other fields.
> --
> Thanks again for your help.
> akm (XPpro,SP-2,IE-7,Office2003)
>
>
>
> "Diane Poremsky [MVP]" wrote:
>
>> It sounds like the spreadsheet isn’t properly formatted - if its properly
>> set and up and filled out, the state and zips will be in their own
>> column.
>> You need to fix the spreadsheet so the fields are corrrect.
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> Outlook Tips by email:
>> mailto:dailytips-subscribe-request@lists.outlooktips.net
>>
>> EMO - a weekly newsletter about Outlook and Exchange:
>> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>>
>> Do you keep Outlook open 24/7? Vote in our poll:
>> http://forums.slipstick.com/showthread.php?t=22205
>>
>> "akm" <akm.RemoveThis@discussions.microsoft.com> wrote in message
>> news:BBEF510B-CE62-4A73-8AFA-AD6FBF7A99A2@microsoft.com...
>> > Trying to import Excel contact list into Outlook.
>> >
>> > When get to OUtlook 'map custom fields' from Excel file range, the zip
>> > code
>> > field shows up as a cell reference (F6) in the 1st contact, and for the
>> > 'next' contact (and all after that) it shows up as the state name.
>> >
>> > So, both the state and the zip code fields show up with the state name
>> > (except for the first contact, which shows up as a cell ref 'F6'),
>> > ie...
>> >
>> > name
>> > address
>> > city
>> > state
>> > state (in 1st record shows up as cell ref 'f6', which is not in the 1st
>> > contact row in Excel)
>> > phone
>> >
>> > When 'finish' all imports just fine, except all the state and zip code
>> > fields both have the state name in them (except the 1st contact has the
>> > 'F6').
>> >
>> > Ideas?
>> >
>> > --
>> > Thanks again for your help.
>> > akm(XPpro,SP-2,IE-7,Office2003)
>> >
>> |
|
| Back to top |
|
 |
akm External

Since: Apr 02, 2005 Posts: 34
|
Posted: Mon Sep 21, 2009 8:19 am Post subject: Re: Why getting dup contact field data when import Excel to Outloo [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
Diane
Thank you for the followup !
1. Actually the 'slipstick' layout is a bit different... our layout has the
following columns.
first - last - address - city - state - zip - phone
Maybe we should try combining the name columns to 'first,last' and the
address columns to 'address,city,state,zip' (including comma delimiting) b4
we go through the CSV thing ?
2. 'NDA' ?
3. 'Fill' command ?
--
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003)
"Diane Poremsky [MVP]" wrote:
> So its all laid out like this? http://slipstick.me/importlist
>
> Saving it as CSV or tab delimited text file from Excel and viewing the file
> in notepad might give you some clues. Actually - save it as CSV, look at the
> data and verify the fields/columns look like they should be ok and try
> importing the CSV.
>
> If that doesn't work, would you mind sending the spreadsheet to diane at
> slipstick dot com? Any content in the sheet will be NDA or you can use
> Excel's Fill command to replace the data but if the problem is with corrupt
> data, filling it will probably fix it.
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> Outlook Tips by email:
> mailto:dailytips-subscribe-request@lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
> Do you keep Outlook open 24/7? Vote in our poll:
> http://forums.slipstick.com/showthread.php?t=22205
>
> "akm" <akm DeleteThis @discussions.microsoft.com> wrote in message
> news:D1A65FA7-54BD-4FF7-9488-7090933581FA@microsoft.com...
> > Thanks for the reply.
> > Checked formating, all cells are same and Zip Codes are in one column just
> > like all other fields.
> > --
> > Thanks again for your help.
> > akm (XPpro,SP-2,IE-7,Office2003)
> >
> >
> >
> > "Diane Poremsky [MVP]" wrote:
> >
> >> It sounds like the spreadsheet isn’t properly formatted - if its properly
> >> set and up and filled out, the state and zips will be in their own
> >> column.
> >> You need to fix the spreadsheet so the fields are corrrect.
> >>
> >> --
> >> Diane Poremsky [MVP - Outlook]
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >>
> >> Outlook Tips by email:
> >> mailto:dailytips-subscribe-request@lists.outlooktips.net
> >>
> >> EMO - a weekly newsletter about Outlook and Exchange:
> >> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
> >>
> >> Do you keep Outlook open 24/7? Vote in our poll:
> >> http://forums.slipstick.com/showthread.php?t=22205
> >>
> >> "akm" <akm DeleteThis @discussions.microsoft.com> wrote in message
> >> news:BBEF510B-CE62-4A73-8AFA-AD6FBF7A99A2@microsoft.com...
> >> > Trying to import Excel contact list into Outlook.
> >> >
> >> > When get to OUtlook 'map custom fields' from Excel file range, the zip
> >> > code
> >> > field shows up as a cell reference (F6) in the 1st contact, and for the
> >> > 'next' contact (and all after that) it shows up as the state name.
> >> >
> >> > So, both the state and the zip code fields show up with the state name
> >> > (except for the first contact, which shows up as a cell ref 'F6'),
> >> > ie...
> >> >
> >> > name
> >> > address
> >> > city
> >> > state
> >> > state (in 1st record shows up as cell ref 'f6', which is not in the 1st
> >> > contact row in Excel)
> >> > phone
> >> >
> >> > When 'finish' all imports just fine, except all the state and zip code
> >> > fields both have the state name in them (except the 1st contact has the
> >> > 'F6').
> >> >
> >> > Ideas?
> >> >
> >> > --
> >> > Thanks again for your help.
> >> > akm(XPpro,SP-2,IE-7,Office2003)
> >> >
> >>
> |
|
| Back to top |
|
 |
Diane Poremsky [MVP] External

Since: Jul 28, 2005 Posts: 6715
|
Posted: Tue Sep 22, 2009 12:45 am Post subject: Re: Why getting dup contact field data when import Excel to Outloo [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
everything needs to be in separate fields.
NDA = non-disclosure. If you want me to look at the file, your data will
remain private and I won't keep or use the data.
excel allows you to fill columns with data.
--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205
"akm" <akm.TakeThisOut@discussions.microsoft.com> wrote in message
news:E245A831-6B26-480B-92C4-CBEDF980795D@microsoft.com...
> Diane
>
> Thank you for the followup !
>
> 1. Actually the 'slipstick' layout is a bit different... our layout has
> the
> following columns.
>
> first - last - address - city - state - zip - phone
>
> Maybe we should try combining the name columns to 'first,last' and the
> address columns to 'address,city,state,zip' (including comma delimiting)
> b4
> we go through the CSV thing ?
>
> 2. 'NDA' ?
>
> 3. 'Fill' command ?
> --
> Thanks again for your help.
> akm (XPpro,SP-2,IE-7,Office2003)
>
>
>
> "Diane Poremsky [MVP]" wrote:
>
>> So its all laid out like this? http://slipstick.me/importlist
>>
>> Saving it as CSV or tab delimited text file from Excel and viewing the
>> file
>> in notepad might give you some clues. Actually - save it as CSV, look at
>> the
>> data and verify the fields/columns look like they should be ok and try
>> importing the CSV.
>>
>> If that doesn't work, would you mind sending the spreadsheet to diane at
>> slipstick dot com? Any content in the sheet will be NDA or you can use
>> Excel's Fill command to replace the data but if the problem is with
>> corrupt
>> data, filling it will probably fix it.
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>>
>> Outlook Tips by email:
>> mailto:dailytips-subscribe-request@lists.outlooktips.net
>>
>> EMO - a weekly newsletter about Outlook and Exchange:
>> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>>
>> Do you keep Outlook open 24/7? Vote in our poll:
>> http://forums.slipstick.com/showthread.php?t=22205
>>
>> "akm" <akm.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:D1A65FA7-54BD-4FF7-9488-7090933581FA@microsoft.com...
>> > Thanks for the reply.
>> > Checked formating, all cells are same and Zip Codes are in one column
>> > just
>> > like all other fields.
>> > --
>> > Thanks again for your help.
>> > akm (XPpro,SP-2,IE-7,Office2003)
>> >
>> >
>> >
>> > "Diane Poremsky [MVP]" wrote:
>> >
>> >> It sounds like the spreadsheet isn’t properly formatted - if its
>> >> properly
>> >> set and up and filled out, the state and zips will be in their own
>> >> column.
>> >> You need to fix the spreadsheet so the fields are corrrect.
>> >>
>> >> --
>> >> Diane Poremsky [MVP - Outlook]
>> >> Outlook Tips: http://www.outlook-tips.net/
>> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> >>
>> >> Outlook Tips by email:
>> >> mailto:dailytips-subscribe-request@lists.outlooktips.net
>> >>
>> >> EMO - a weekly newsletter about Outlook and Exchange:
>> >> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>> >>
>> >> Do you keep Outlook open 24/7? Vote in our poll:
>> >> http://forums.slipstick.com/showthread.php?t=22205
>> >>
>> >> "akm" <akm.TakeThisOut@discussions.microsoft.com> wrote in message
>> >> news:BBEF510B-CE62-4A73-8AFA-AD6FBF7A99A2@microsoft.com...
>> >> > Trying to import Excel contact list into Outlook.
>> >> >
>> >> > When get to OUtlook 'map custom fields' from Excel file range, the
>> >> > zip
>> >> > code
>> >> > field shows up as a cell reference (F6) in the 1st contact, and for
>> >> > the
>> >> > 'next' contact (and all after that) it shows up as the state name.
>> >> >
>> >> > So, both the state and the zip code fields show up with the state
>> >> > name
>> >> > (except for the first contact, which shows up as a cell ref 'F6'),
>> >> > ie...
>> >> >
>> >> > name
>> >> > address
>> >> > city
>> >> > state
>> >> > state (in 1st record shows up as cell ref 'f6', which is not in the
>> >> > 1st
>> >> > contact row in Excel)
>> >> > phone
>> >> >
>> >> > When 'finish' all imports just fine, except all the state and zip
>> >> > code
>> >> > fields both have the state name in them (except the 1st contact has
>> >> > the
>> >> > 'F6').
>> >> >
>> >> > Ideas?
>> >> >
>> >> > --
>> >> > Thanks again for your help.
>> >> > akm(XPpro,SP-2,IE-7,Office2003)
>> >> >
>> >>
>> |
|
| Back to top |
|
 |
akm External

Since: Apr 02, 2005 Posts: 34
|
Posted: Tue Sep 22, 2009 12:45 am Post subject: Re: Why getting dup contact field data when import Excel to Outloo [Login to view extended thread Info.] Archived from groups: per prev. post (more info?) |
|
|
Its on the way !
--
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003)
"Diane Poremsky [MVP]" wrote:
> everything needs to be in separate fields.
>
> NDA = non-disclosure. If you want me to look at the file, your data will
> remain private and I won't keep or use the data.
>
> excel allows you to fill columns with data.
>
> --
> Diane Poremsky [MVP - Outlook]
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
>
> Outlook Tips by email:
> mailto:dailytips-subscribe-request@lists.outlooktips.net
>
> EMO - a weekly newsletter about Outlook and Exchange:
> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
>
> Do you keep Outlook open 24/7? Vote in our poll:
> http://forums.slipstick.com/showthread.php?t=22205
>
> "akm" <akm RemoveThis @discussions.microsoft.com> wrote in message
> news:E245A831-6B26-480B-92C4-CBEDF980795D@microsoft.com...
> > Diane
> >
> > Thank you for the followup !
> >
> > 1. Actually the 'slipstick' layout is a bit different... our layout has
> > the
> > following columns.
> >
> > first - last - address - city - state - zip - phone
> >
> > Maybe we should try combining the name columns to 'first,last' and the
> > address columns to 'address,city,state,zip' (including comma delimiting)
> > b4
> > we go through the CSV thing ?
> >
> > 2. 'NDA' ?
> >
> > 3. 'Fill' command ?
> > --
> > Thanks again for your help.
> > akm (XPpro,SP-2,IE-7,Office2003)
> >
> >
> >
> > "Diane Poremsky [MVP]" wrote:
> >
> >> So its all laid out like this? http://slipstick.me/importlist
> >>
> >> Saving it as CSV or tab delimited text file from Excel and viewing the
> >> file
> >> in notepad might give you some clues. Actually - save it as CSV, look at
> >> the
> >> data and verify the fields/columns look like they should be ok and try
> >> importing the CSV.
> >>
> >> If that doesn't work, would you mind sending the spreadsheet to diane at
> >> slipstick dot com? Any content in the sheet will be NDA or you can use
> >> Excel's Fill command to replace the data but if the problem is with
> >> corrupt
> >> data, filling it will probably fix it.
> >>
> >> --
> >> Diane Poremsky [MVP - Outlook]
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >>
> >> Outlook Tips by email:
> >> mailto:dailytips-subscribe-request@lists.outlooktips.net
> >>
> >> EMO - a weekly newsletter about Outlook and Exchange:
> >> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
> >>
> >> Do you keep Outlook open 24/7? Vote in our poll:
> >> http://forums.slipstick.com/showthread.php?t=22205
> >>
> >> "akm" <akm RemoveThis @discussions.microsoft.com> wrote in message
> >> news:D1A65FA7-54BD-4FF7-9488-7090933581FA@microsoft.com...
> >> > Thanks for the reply.
> >> > Checked formating, all cells are same and Zip Codes are in one column
> >> > just
> >> > like all other fields.
> >> > --
> >> > Thanks again for your help.
> >> > akm (XPpro,SP-2,IE-7,Office2003)
> >> >
> >> >
> >> >
> >> > "Diane Poremsky [MVP]" wrote:
> >> >
> >> >> It sounds like the spreadsheet isn’t properly formatted - if its
> >> >> properly
> >> >> set and up and filled out, the state and zips will be in their own
> >> >> column.
> >> >> You need to fix the spreadsheet so the fields are corrrect.
> >> >>
> >> >> --
> >> >> Diane Poremsky [MVP - Outlook]
> >> >> Outlook Tips: http://www.outlook-tips.net/
> >> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >> >>
> >> >> Outlook Tips by email:
> >> >> mailto:dailytips-subscribe-request@lists.outlooktips.net
> >> >>
> >> >> EMO - a weekly newsletter about Outlook and Exchange:
> >> >> mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM
> >> >>
> >> >> Do you keep Outlook open 24/7? Vote in our poll:
> >> >> http://forums.slipstick.com/showthread.php?t=22205
> >> >>
> >> >> "akm" <akm RemoveThis @discussions.microsoft.com> wrote in message
> >> >> news:BBEF510B-CE62-4A73-8AFA-AD6FBF7A99A2@microsoft.com...
> >> >> > Trying to import Excel contact list into Outlook.
> >> >> >
> >> >> > When get to OUtlook 'map custom fields' from Excel file range, the
> >> >> > zip
> >> >> > code
> >> >> > field shows up as a cell reference (F6) in the 1st contact, and for
> >> >> > the
> >> >> > 'next' contact (and all after that) it shows up as the state name.
> >> >> >
> >> >> > So, both the state and the zip code fields show up with the state
> >> >> > name
> >> >> > (except for the first contact, which shows up as a cell ref 'F6'),
> >> >> > ie...
> >> >> >
> >> >> > name
> >> >> > address
> >> >> > city
> >> >> > state
> >> >> > state (in 1st record shows up as cell ref 'f6', which is not in the
> >> >> > 1st
> >> >> > contact row in Excel)
> >> >> > phone
> >> >> >
> >> >> > When 'finish' all imports just fine, except all the state and zip
> >> >> > code
> >> >> > fields both have the state name in them (except the 1st contact has
> >> >> > the
> >> >> > 'F6').
> >> >> >
> >> >> > Ideas?
> >> >> >
> >> >> > --
> >> >> > Thanks again for your help.
> >> >> > akm(XPpro,SP-2,IE-7,Office2003)
> >> >> >
> >> >>
> >>
> |
|
| Back to top |
|
 |
|
|
|
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
| |
|
|