An even bigger Find and Replace

[Guest]

I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two paragraph
marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with the name
at the same time. There are over 200 and, as usual, they say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any find and
replace or macro information.

 

[Suzanne S. Barnhill]

To keep each address in a block, replace ^p (paragraph break) with ^l (line
break), then replace ^l^l with ^p.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Jay Freedman]

Graham Mayor covers exactly that situation in
http://www.gmayor.com/convert_labels_into_mail_merge.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Guest]

Thanks, as always, Suzanne for your reply.

One more thing. Is it possible, after replacing the paragraph breaks and
line breaks as you suggested, to keep the address block together with the
name while at the same time rearranging the name in the first line of each
block to last name first? What I'm trying to avoid in my now hazed mind is
separating all the names from the address block, rearranging them, and then
putting them back in their proper place. I've been thinking so hard that I'm
probably not making sense.

Thanks for all you do and have done, Suzanne!

To keep each address in a block, replace ^p (paragraph break) with ^l (line
break), then replace ^l^l with ^p.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two paragraph
marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with the name
at the same time. There are over 200 and, as usual, they say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any find and
replace or macro information.

 

[Suzanne S. Barnhill]

Since I don't know how you're rearranging the name, I can't offer any
further help, but each address block is now a single paragraph and can be
handled as such.

As Jay suggests, however, converting the text to a table and using it as a
mail merge data source is a more satisfactory approach.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Thanks, as always, Suzanne for your reply.

One more thing. Is it possible, after replacing the paragraph breaks and
line breaks as you suggested, to keep the address block together with the
name while at the same time rearranging the name in the first line of each
block to last name first? What I'm trying to avoid in my now hazed mind is
separating all the names from the address block, rearranging them, and then
putting them back in their proper place. I've been thinking so hard that I'm
probably not making sense.

Thanks for all you do and have done, Suzanne!

To keep each address in a block, replace ^p (paragraph break) with ^l (line
break), then replace ^l^l with ^p.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two paragraph
marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with

the
name

at the same time. There are over 200 and, as usual, they say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any

find
and

replace or macro information.

 

[Guest]

This is not the first time that Suzanne, you and Graham have made me happy!!

Graham Mayor covers exactly that situation in
http://www.gmayor.com/convert_labels_into_mail_merge.htm.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two paragraph
marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with the name
at the same time. There are over 200 and, as usual, they say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any find and
replace or macro information.

 

[Graham Mayor]

As an alternative to Suzanne's suggestion - this is a standard data format.
You can create any finished layout you want from that data by running a
mailmerge to Directory format.

If you just want the address list sorted see
http://www.gmayor.com/convert_labels_into_mail_merge.htm covert it to a
table, sort on whichever column you want then convert back to text (or if
you want it for mail merge etc, leave it as a table.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>.

 

[Graham Mayor]

Ooops - I should have read all branches of the thread before replying

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Graham Mayor covers exactly that situation in
http://www.gmayor.com/convert_labels_into_mail_merge.htm.

I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two
paragraph marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with
the name at the same time. There are over 200 and, as usual, they
say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any
find and replace or macro information.

 

[Guest]

It's always comforting to see your name, Graham. I used your website method
and everything worked out just fine. Thanks!

Ooops - I should have read all branches of the thread before replying

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Graham Mayor covers exactly that situation in
http://www.gmayor.com/convert_labels_into_mail_merge.htm.

I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two
paragraph marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with
the name at the same time. There are over 200 and, as usual, they
say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any
find and replace or macro information.

 

[Graham Mayor]

Glad someone appreciates what I do

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

It's always comforting to see your name, Graham. I used your website
method and everything worked out just fine. Thanks!

Ooops - I should have read all branches of the thread before
replying

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Graham Mayor covers exactly that situation in
http://www.gmayor.com/convert_labels_into_mail_merge.htm.


I thought I had the job done and then --

I have now been sent an address list formatted as follows:

John A. Jones [paragraph mark]
2111 Alabama Street [paragraph mark]
Miami, FL 33131[paragraph mark]
[paragraph mark]
Mary Smith [paragraph mark]
50 Park Place [paragraph mark]
Miami, FL 33131 [paragraph mark]
[paragraph mark]

In other words each last line of the address is followed by two
paragraph marks.

I know how to change last names first if the names are on a line by
themselves, but I don't know if there's a way keep the address with
the name at the same time. There are over 200 and, as usual, they
say, "It's a rush!"

What now, coaches?

Thanks so very much for any advice on how to approach and also any
find and replace or macro information.