Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 Letter doc and Excel 2003 data source | Mailmerge | |||
Loosing access to data source in Word 2003 | Mailmerge | |||
Word 2003 as Data Source: Using Word Doc Form Fields as Data Sourc | Mailmerge | |||
Winword 2003 on MS Server 2003 keeps losing data source. | Mailmerge | |||
Word 2003 merge data source Excel Ques | Mailmerge |