ufsphere.blogg.se

How to do a mail merge in word 2010 from excel
How to do a mail merge in word 2010 from excel











how to do a mail merge in word 2010 from excel

So, my suggestion would be to to either insert your txt file into a word document and convert text to table and insert a header row at the top, or to insert additional rows in the header document and place the text in the rows with the information required. Someone here will probably explain that side of it. How you linked the txt file to be in the right columns and it worked I don't know you have me stumped on that one. However, with only the header row it returned an error message. I tested putting additional rows in your table to put dummy text in and had no problem with the merge. Otherwise I would create the data source in Excel - word of warning though, sometimes the dates do not appear as you want them to so I suggested formatting those to text. If you need to do this in Word I would suggest adjusting the table and the font to be small but the zoom to be big. If I convert the text to table it has 26 different columns and this is hard to read in Word due to page setup and restrictions. If I use the txt file, it only has the information and no corresponding headers. The myheader.docx only has one row, the mail merge is looking for the header row and subsquent rows of information, which there aren't any. Note: the header source is a doc(also tried it as a.docx) and the data source is a text file. I have tried this both on a network and on my desktop and I experience the same results. But when I save it and re-open it, it doesn't recognize the header again and the data is still screwed up. Weird part is that if I relink the header file I can preview all the data correctly. I view the datasource in both.Īs you can see the header file isn't being recognized correctly in the. There is only one row in the datasource and the header source is in a table as suggested by microsoft.Įxample: I have both versions open and go to the mail merge helper. docx file doesn't recognize that theres a header file anymore and instead it is using the first record in the datasource as the header and datasource. I am in the process of converting mail merge documents from.













How to do a mail merge in word 2010 from excel