address book

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...
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

Kevin,
Thanks for the reply but everything was in MS Word, then brought into Excel.
redman

"Kevin H. Stecyk" wrote:

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

Take a look at this topic first for a worksheet solution
http://www.mvps.org/dmcritchie/excel...ol.htm#snkAddr

There are various examples, that should help you pick out a solution.
As it stands from my perspective your example is ambiguous because
it does not show the next set whether you have a blank row between,
whether you always have exactly the same number of lines per
name/address group.

My preference is to use macros but if the same number of rows is
in each group you can do this with or without macros.


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"redman" wrote in message ...
Kevin,
Thanks for the reply but everything was in MS Word, then brought into Excel.
redman

"Kevin H. Stecyk" wrote:

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