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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|