If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I am having trouble importing an excel file into contacts in outlo
I cannot get all the information in an Excel file to import into the contacts
in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. |
#2
|
|||
|
|||
Did you use Insert | Name | Create to create a named range in the worksheet
covering all the data you want to import? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Sue Leffin" Sue wrote in message ... I cannot get all the information in an Excel file to import into the contacts in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. |
#3
|
|||
|
|||
Did you try assigning a name to the whole area of cells containing the
informations? Hope i helps |
#4
|
|||
|
|||
By doing this, I am able to import the whole file. However the e-mail field
is not importing as a e-mail hyperlink....I am only getting the first letter of the e-mail address that appears in the column. All other numbers and names are correct. "Ink" wrote: Did you try assigning a name to the whole area of cells containing the informations? Hope i helps |
#5
|
|||
|
|||
I did...however I am thinking that the format of those cells in Excel has
something to do with it only importing the first letter of the email address. All other information is importing correctly "Sue Mosher [MVP-Outlook]" wrote: Did you use Insert | Name | Create to create a named range in the worksheet covering all the data you want to import? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Sue Leffin" Sue wrote in message ... I cannot get all the information in an Excel file to import into the contacts in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. |
#6
|
|||
|
|||
And how are they formatted in Excel?
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Sue Leffin" wrote in message ... I did...however I am thinking that the format of those cells in Excel has something to do with it only importing the first letter of the email address. All other information is importing correctly "Sue Mosher [MVP-Outlook]" wrote: Did you use Insert | Name | Create to create a named range in the worksheet covering all the data you want to import? "Sue Leffin" Sue wrote in message ... I cannot get all the information in an Excel file to import into the contacts in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. |
#7
|
|||
|
|||
Originally as e-mail hyperlinks. Then I changed them to "General"....still
didn't work. "Sue Mosher [MVP-Outlook]" wrote: And how are they formatted in Excel? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Sue Leffin" wrote in message ... I did...however I am thinking that the format of those cells in Excel has something to do with it only importing the first letter of the email address. All other information is importing correctly "Sue Mosher [MVP-Outlook]" wrote: Did you use Insert | Name | Create to create a named range in the worksheet covering all the data you want to import? "Sue Leffin" Sue wrote in message ... I cannot get all the information in an Excel file to import into the contacts in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. |
#8
|
|||
|
|||
I sure can't duplicate the problem here, even with an address set up as a
hyperlink. How did you map the fields? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Sue Leffin" wrote in message ... Originally as e-mail hyperlinks. Then I changed them to "General"....still didn't work. "Sue Mosher [MVP-Outlook]" wrote: And how are they formatted in Excel? "Sue Leffin" wrote in message ... I did...however I am thinking that the format of those cells in Excel has something to do with it only importing the first letter of the email address. All other information is importing correctly "Sue Mosher [MVP-Outlook]" wrote: Did you use Insert | Name | Create to create a named range in the worksheet covering all the data you want to import? "Sue Leffin" Sue wrote in message ... I cannot get all the information in an Excel file to import into the contacts in Outlook, expecially the e-mails which have been created as hyperlinks in the excel file. I am getting only the first row of information to import. |
#9
|
|||
|
|||
Try removing Hyperlinks. Select the column containing e-mails, then from Edit
menu select DeleteFormats. Should work ... Then remember to cover with a name all the cells of what you want to import. Bye "Sue Leffin" wrote: By doing this, I am able to import the whole file. However the e-mail field is not importing as a e-mail hyperlink....I am only getting the first letter of the e-mail address that appears in the column. All other numbers and names are correct. "Ink" wrote: Did you try assigning a name to the whole area of cells containing the informations? Hope i helps |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"File As" Incorrect after importing from excel | dailo | Contacts | 1 | December 2nd, 2004 12:05 AM |
Automatically Updating Excel Data In Word Doc Inside Excel File | Business Design Architect | General Discussion | 0 | August 29th, 2004 10:55 PM |
Importing Contacts from Excel | Pauline | Contacts | 1 | June 12th, 2004 04:51 PM |
Importing Contacts from an Excel file | Kevin | Contacts | 1 | May 5th, 2004 12:56 PM |
Cannot open large excel file | Niall Caslin | Worksheet Functions | 3 | October 29th, 2003 05:24 PM |