[Lonnie]

I am relatively new to a complicated mail merge like the one I am doing now.
I hope there is some hope for a better solution then the labor intensive one
I am currently using. I have 200+ data source (angle bracketed) fields in 3
different sections of the document.
When I double click to bring each element from the Insert Merge Fields
button each one is placed next to each other going across the page then onto
the next line.

«Brand162»«Brand163»«Brand164»«Brand165»« Brand166»«Brand167»«Brand168»«Brand169»«Br and170»«Brand171»

I need to have one on each line by itself with the paragraph mark right
after it inorder to have the empty ones skip the line i.e not add an extra
blank line, AFAIK. My brute force solution is click in between each one to
manually perss the enter key to get the new line (paragraph symbol) in
between each one.

I have to double click between each element from the Insert Merge Field at
the same time otherwise I have to get out and get back in for each element.

Is there an easier way to do this? I tried doing a search and replace with
the double angles from the Latin-1 symbols Insert menu but search and replace
does not recognize the symbol.

I hope this is understandable. Any help is appreciated. I tried searching
the lists but I probably am not using the correct phrases.

Lonnie

[Doug Robbins - Word MVP]

If you run a macro containing the following code, it will insert a paragraph
mark after each of the mergefields in the document:

Dim i As Long
Dim frange As Range
With ActiveDocument
For i = 1 To .Fields.Count
With .Fields(i)
If .Type = wdFieldMergeField Then
Set frange = .Code
frange.Collapse wdCollapseEnd
frange.Move wdCharacter, 1
frange.InsertAfter vbCr
End If
End With
Next i
End With


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Lonnie" wrote in message
...
I am relatively new to a complicated mail merge like the one I am doing
now.
I hope there is some hope for a better solution then the labor intensive
one
I am currently using. I have 200+ data source (angle bracketed) fields in
3
different sections of the document.
When I double click to bring each element from the Insert Merge Fields
button each one is placed next to each other going across the page then
onto
the next line.

«Brand162»«Brand163»«Brand164»«Brand165»« Brand166»«Brand167»«Brand168»«Brand169»«Br and170»«Brand171»

I need to have one on each line by itself with the paragraph mark right
after it inorder to have the empty ones skip the line i.e not add an extra
blank line, AFAIK. My brute force solution is click in between each one
to
manually perss the enter key to get the new line (paragraph symbol) in
between each one.

I have to double click between each element from the Insert Merge Field at
the same time otherwise I have to get out and get back in for each
element.

Is there an easier way to do this? I tried doing a search and replace with
the double angles from the Latin-1 symbols Insert menu but search and
replace
does not recognize the symbol.

I hope this is understandable. Any help is appreciated. I tried searching
the lists but I probably am not using the correct phrases.

Lonnie

[Lonnie]

Thank you, thank you, thank you. That does the trick. I very much appreciate
your help!

"Lonnie" wrote:

I am relatively new to a complicated mail merge like the one I am doing now.
I hope there is some hope for a better solution then the labor intensive one
I am currently using. I have 200+ data source (angle bracketed) fields in 3
different sections of the document.
When I double click to bring each element from the Insert Merge Fields
button each one is placed next to each other going across the page then onto
the next line.

«Brand162»«Brand163»«Brand164»«Brand165»« Brand166»«Brand167»«Brand168»«Brand169»«Br and170»«Brand171»

I need to have one on each line by itself with the paragraph mark right
after it inorder to have the empty ones skip the line i.e not add an extra
blank line, AFAIK. My brute force solution is click in between each one to
manually perss the enter key to get the new line (paragraph symbol) in
between each one.

I have to double click between each element from the Insert Merge Field at
the same time otherwise I have to get out and get back in for each element.

Is there an easier way to do this? I tried doing a search and replace with
the double angles from the Latin-1 symbols Insert menu but search and replace
does not recognize the symbol.

I hope this is understandable. Any help is appreciated. I tried searching
the lists but I probably am not using the correct phrases.

Lonnie