AutoPDF From WORD ()
VBA mail-merge macro: generates PDFs with custom names, saves them to a chosen folder and sends them by email, all from a source Excel file.
My first real automation reflex, at 16, during a summer job in a call centre. The job, as it was Hand-scan the La Poste acknowledgements of receipt Generate the PDFs one by one Send them one by one What I did about it Rather than keep going, I wrote the macro that did it for me. It reads the data from the source Excel file, then: • Generates the PDFs with a custom name • Saves them to a chosen folder • Sends them by email From a fully manual mail-merge to a complete VBA macro. It's the oldest project on the site, and probably the one that best explains the rest.
Authors: Ilian A2Z
Tags
- Professional