VBA to write message in word from Excel

[corbinw22]

I've tried to search the forums but couldn't find how to do this. I am trying to write a message in word that will insert basic information from excel. For example, in Column A I have a list of client names and in column B I have a list of how much they owe me. I would love to write a generic message that inserts their name and how much they owe.

For example,

"Hello, [Insert Client Name from A1],

We notice your account is past due and you still owe [Amount from B1], please send payment to.."


How can I got about doing this so then the output text ends up in a word document? This would save me tons of time as other wise I have to copy and paste this information over and over again.

Thanks,

 

[JonXL]

I've tried to search the forums but couldn't find how to do this. I am trying to write a message in word that will insert basic information from excel. For example, in Column A I have a list of client names and in column B I have a list of how much they owe me. I would love to write a generic message that inserts their name and how much they owe.

For example,

"Hello, [Insert Client Name from A1],

We notice your account is past due and you still owe [Amount from B1], please send payment to.."


How can I got about doing this so then the output text ends up in a word document? This would save me tons of time as other wise I have to copy and paste this information over and over again.

Thanks,

Is there a reason you can't use Mail Merge?

It sounds like it'd be perfectly suited for solving this problem...

 

[RobertSF]

Yes, mail merge is the answer. Create an Excel spreadsheet with the columns that you will use (ClientName, Amount, etc.). Put the column names in row 1. Don't put spaces in the column names, and keep the column names reasonably short.

Then open Word, create a new document, and click on Mailings. Then click on Start Mail Merge, and then click on Step-by-Step Mail Merge Wizard. It should be pretty self-explanatory.