Mailmerge from excel spreadsheet

Hello Tashi,

Thank you for your question regarding merging data from an Excel spreadsheet into Word.

I have found that the easiest way to overcome this problem is to open a new file in Word, then copy the data from the Excel data list and paste into Word using destination formatting.

This will create a table in Word with the exact same information as you have in Excel. Save the file and close it. Then go to your invoice template in Word and insert the various fields that you require. Once you go to the preview stage you will notice that all formatting problems you mentioned have disappeared.

Give it a try!

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer