Merging Invoice data from excel

[ag2324]

Hello, I need help with merging all the invoices in an excel spreadsheet into a word template in a single shot. Whether it requires code or a simpler solution is something I do not know. Any answer of help will be appreciated. Basically you have:

L Name of Patient F Name of Patient Balance Due
Column B Column A Column C

Template: Dear Mr./ Mrs. .........

You have a balance of (Column C), Please remit payment

Would really like to automatically push all of the data from excel into a word doc in a single shot, creating over 100s of invoices in a single shot without manually having to do them. Appreciate it. Please reply, I really need help. Is there anyway to this or something similar, if anyone has any ideas feel free to reply, again, I am reallyt in need of help.

Thanks

[Dennis7849]

Open Word, search the help for "mail merge with excel", the first hit will explain how this is done.

[ag2324]

I want to merge patient inovice data from excel to word automatically without having to do it one by one manually, mail merge does not cover this process.

[ag2324]

Please help!!