word templates

[Admiral Huddy]

I'd like to create a script that I want to schedule daily, that automatically produces letters based on a csv file. One letter per row.

So I'm looking for a way of updating a word document template, filing in certain parts (or fields) with data from the csv file.

I've had a good look around but the information is a bit hit and miss. I'm using office 2013.

One suggestion was to use a VBA scripts.. no idea.

Any help or pointers would be great
thanks

 

[skyripper]

Thats a mail-merge then. Create your standard format, add some fields. Then use the mail-merge functionality to load your CSV and do a test run. When happy send via email, which will go via Outlook.

If you want that automated, you will need to use VBA to do the above, but I'd iron out the manual process first and be prepared to send some test runs to your own email account before sending to others.

 

[gpuerrilla]

Agree. It seems step one is to get the MM working on the template you create. Then you test to a couple of email addresses you control to get either VBA to automate or you could do it using Python.