When I try to export data from Excel to Outlook I get a message in Outlook that says I have to name the range of data in Excel. I can't find how to do that.

The information I am trying to import to Outlook contains, title, frist name, last name address, birthdate, appointment date and appointment time.

I can successfully import title, first name, last name, and address by clicking on the option in Outlook that says "Tab Separated Values". However, when I click on Excel I get the message that says "...the file has no named ranges. Use Excel to name the range of data."

Can the appointment date and time be imported into Outlook or can I only import the title, name and address? If so how?

Hi,

If You use a VBA-procedure then it will help if You can provide it to the thread.

Kind regards,
Dennis