redman...
Is there a macro or other way (short of cutting & pasting) of putting
address book entries into a row format. For example:
John Smith
123 Main Street
Anywhere, state 10000
phone 222-222-2222
to be
john smith 123 main street anywhere state 10000 phone
thanks for your help
redman,
Are you using Outlook as your address book? If you are, then the following
information from XL's help might be of benefit. Effectively, I think you are
simply exporting the data from Outlook to XL.
Import Outlook contacts into Excel
Start Outlook.
On the File menu, click Import and Export.
Click Export to a file, and then click Next.
In the Create a file of type box, click Microsoft Excel, and then click
Next.
In the Select folder to export from box, click Contacts, and then click
Next.
Note To import only the contacts you want, you can copy them to a new
folder in Outlook, and then click that folder. For more information, see
Outlook Help.
In the Save exported file as box, specify a path and a name for the file,
and then click Next.
If necessary, map fields from the file you are exporting to Excel.
How?
Click Map Custom Fields.
In the From box, drag the field you want to convert onto the Microsoft Excel
field listed in the To box.
If you want to see additional records in the From box, click Previous or
Next.
If you want to remove all mapping, click Clear Map.
If you want to reset the original mapping, click Default Map.
To display additional fields in the To box, click the plus sign (+) next to
the field. For example, to display the Business Street and Business City
fields, click the + next to Business Address.
Click OK.
Click Finish.
In Excel, open the file you created.
Note If you want to create a Microsoft Word mail merge from your Outlook
contacts, you can do so without importing the contacts into Excel. Microsoft
Word 2002 or later can access your contacts directly from Outlook. For more
information, see Word Help.
Regards,
Kevin
