Solution to your first problem:

#1 - Export as a CSV file
#2 - If you absolutely need an .XLS file - open CSV file in Excel and resave
it as an Excel worksheet

*** behaviour you're seeing is standard for anything that creates an XLS
file using the Microsoft Excel driver and there is no way to eliminate the
leading apostrophe

Solution for your second problem

Option #1 - there has been an Excel solution posted here on multiple
occasions that will split the address line but unfortunately don't have it
handy else I'd include it. Hopefully someone else reading this will be able
to supply it to you or you can search the newsgroup. The street address
fields for all addresses are exported from Outlook as a single "multi-line"
with line breaks included between each of the individual address lines.
Depending on what you're using for mailing, this may be perfectly fine.

Option#2 - if you're going to be doing all this on a regular repeated
basis - you may be interested in our CG Exporter (CGX) product
(http://www.contactgenie.com/cgxfeatures.htm). However, exporting to an
Excel file via CGX will exhibit the same "leading apostrophe" issue you're
encountering with Outlook. As for street addresses, there is a built-in
option to export street address lines as separate fields.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com