Importing to Outlook 2007

[ljc]

Trying to import from excel 2007 to outlook 2007; it keeps asking for a data
range?
How do I make my Excel worksheet data range compatible for outlook?

 

[Brian Tillman [MVP - Outlook]]

Trying to import from excel 2007 to outlook 2007; it keeps asking for a data
range?
How do I make my Excel worksheet data range compatible for outlook?

Open the spreadsheet in Excel, select all the rows and columns containing your
data, then enter some name into the Name field (where the cell name us usually
found). Save the sheet. You now have a named range. Use that name in
Outlook.

Alternatively, open tjhe spreadsheet in Excel and save it as a comma-separated
values file. Use the csv file, which obviates the need for named ranges.

 

[Diane Poremsky [MVP]]

See http://www.slipstick.com/Tutorials/import/import.htm for instructions.

--
Diane Poremsky [MVP - Outlook]

Outlook & Exchange Solutions Center: http://www.slipstick.com/

Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

Do you keep Outlook open 24/7? Vote in our poll:
http://forums.slipstick.com/showthread.php?t=22205