Import of Excel file to Outlook takes only first 2 rows of data -.

L

Lanetloo

I am trying to translate an excel address database into Outlook. I created a
template by exporting Outlook Contacts to Excel file and copying my fields
into those corresponding to Outlook. When I tried to inport the data, it
only took the first two rows of data and not the next 300 rows of data. Any
ideas?
 
S

Sue Mosher [MVP-Outlook]

Sounds like your named range in Excel covered only the first two rows. It
needs to cover all data you want to import.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Converting isse with Export in Outlook 0
Adding a big matrix in Word 2013 5
Import Contacts From Excel to Outlook Not Working 3
Excel file linked to external source 0
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Importing Contacts From Excel 4

Top