I also read somewhere that I need to use the VBA programming code to get this to happen. I thought that by sorting the data by worker, Excel would know when to start a new docuemtn when the name changes to a differnet person. Since there are seven evaluation questions, there are seven rows per person, but when I run the merge it makes seven documents. How to use mail merge in Microsoft Word with an existing list of receipients, creating a new list, selecting from Outlook contacts and personalize the document before sending. Step 4: I sort by worker and arrange the directory by choosing "More Items" from here I select the different fields from the database fields provided, >, >, >, >, >, > (In table) and > Step 3: I use existing list and selsect my excel spread sheet. Step 2: Select document type: Directory > Current Document Is this even possible? Pike I think understands what needs to be done, but I am having trouble having the data merge over due to the multiple rows. There might be a way that I can get that done, but this is a report that is pulled for somebody else who likes the report to be in this format, so this is the delema I need to be able to merge the data as it is formated currently. I am aware that the mail merge will work smoothly if I had all the information on one row. Re: Mail Merge in Word to create a list of data from multiple rows in Excel
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |