Merge inconsistent I use MS Excel and MS Word from Office 2010 to merge a variet
ID: 3561276 • Letter: M
Question
Merge inconsistent
I use MS Excel and MS Word from Office 2010 to merge a variety of documents - Check Requisitions, emails, letters to the recipients. Each sheet row contains the details for one recipient: Name, address, amount., check number... etc.
Regardless of what I do in either the Excel Workbook or the 'receiving' Word document, the merge emerges with a space behind the name in only the first page! The column in Excel is formatted as TEXT, and there is decidedly NO SPACE after the name in the cells.
The results can be seen here. They are snips from the merged document (Victor and Freeman) and of the field syntax.
Why does the merge enter a space inconsistently? Moreover, HOW does it get fixed?
Explanation / Answer
JHi,
In order to help you better I require more information:"
Are you facing issue with the space between First and last name or between the last name and Full Stop?
Check the box Confirm file format conversion on open from File-> Options-> Advanced-> General in word 2010.
Once checked, start the mail merge and then select source
You will then get a pop up for Confirm Data Source.
Perform a trial and error , check which one works with your data source.
Hope the above information is helpful, let us know if you need any further assistance and we will be glad to help you.
Thank you......