Excel mail merge to pdf to email - possible? -
| posts: 3,376 | Location: Old Europe
this is a bit of a left-field query. I regularly mail merge letters from information contained in a spreadsheet. This letter is then saved in pdf under a standard naming convention "location_first_last name_date".pdf. This pdf is then emailed to the recipient and cc'd to a group of people who are also in the spreadsheet.
I would like to automatize this process. Does anybody know a system (cheap and cheerful is OK) that can do all of it or parts of it?