A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

many many data source fields - windows 2003 - word 2003



 
 
Thread Tools Display Modes
  #1  
Old August 4th, 2009, 12:01 AM posted to microsoft.public.word.mailmerge.fields
Lonnie
external usenet poster
 
Posts: 33
Default many many data source fields - windows 2003 - word 2003

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

  #2  
Old August 4th, 2009, 02:36 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default many many data source fields - windows 2003 - word 2003

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


  #3  
Old August 4th, 2009, 05:26 AM posted to microsoft.public.word.mailmerge.fields
Lonnie
external usenet poster
 
Posts: 33
Default many many data source fields - windows 2003 - word 2003

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.