Export from Outlook Contacts to Excel Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have exported my contact info into an excel spreadsheet to enable me to
upload it to my website for email marketing campaigns. I have two problems:
1. All email addresses have exported OK but have each aquired an apostrophe
in front of the first letter of the address. Thus mail is undeliverable. I
have in excess of 800 addresses, is there any way of fixing this without
deleteing every apostrophe on every email address.
2. Business addresses (multiple lines) have exported as one line, into a
single column. I thought Business Address 2 and 3 would be the different
lines.
3. I am using Outlook 2003 and Excel 2002
Thanks, Karen
 
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
 
Karl Timmermans said:
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.
Click to expand...

It's the Text-to-Columns function.....
 
How do I find the option to export as a CSV file? I am using Excel 2003 and
OUtlook 2003. I see the import/export option then I choose export to a file,
then I choose Microsoft excel (the other options do not have the CSV option)
How do I save this as a CSV file?

Suxan
 
[email protected] said:
How do I find the option to export as a CSV file? I am using Excel 2003
and
OUtlook 2003. I see the import/export option then I choose export to a
file,
then I choose Microsoft excel (the other options do not have the CSV
option)
How do I save this as a CSV file?
Click to expand...

File-Import and Export-Export to a File-Comma Separated Values (Windows).
That's what CSV stands for....
 
Back
Top