Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory and merge from Excel
I am using Excel 07 and Word 07.
I am trying to merge the data in .csv form into Word. I am doing this using the mail merge feature and selecting 'directory'. I match the fields and place them in the document and then use the rule of 'next record' in hopes that it will keep placing the records with the same format as the first. When I click preview I only see the first record and when I do a 'finish and merge' Word locks up. There are 1755 records. I amd doing this on the first line of the page: «LastName», «FirstName» & «Spouse» «Address1», «Address2», «City», «State», «ZIPCode» «HomePhone» «Children» «Next Record» «Next Record» «Next Record» In return I only receive the first record A., Kristopher & Cyndi 1022 Ae, , Indianapolis, IN, 46227 ### ### #### Ceer thoughts? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory and merge from Excel
You do not need the Next Record field. Also a preview will not show the
result of executing the merge. Just execute the merge to a new document and you should get what you want. -- 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 "Murph" wrote in message ... I am using Excel 07 and Word 07. I am trying to merge the data in .csv form into Word. I am doing this using the mail merge feature and selecting 'directory'. I match the fields and place them in the document and then use the rule of 'next record' in hopes that it will keep placing the records with the same format as the first. When I click preview I only see the first record and when I do a 'finish and merge' Word locks up. There are 1755 records. I amd doing this on the first line of the page: «LastName», «FirstName» & «Spouse» «Address1», «Address2», «City», «State», «ZIPCode» «HomePhone» «Children» «Next Record» «Next Record» «Next Record» In return I only receive the first record A., Kristopher & Cyndi 1022 Ae, , Indianapolis, IN, 46227 ### ### #### Ceer thoughts? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Directory Merge does not pull in all data in Excel Cel | Mailmerge | |||
Mail Merge Excel to Directory Format in Word | Microsoft Word Help | |||
Directory Merge Excel 2002 | Mailmerge | |||
Word Directory Style Merge from Excel | Mailmerge | |||
Mail merge directory using excel file | Mailmerge |