VBA to Export data into Word and generate PDF report

[crvazquez954]

Greetings my fellow Excel enthusiasts, I am hoping someone here can help me develop a code that will export data from excel to a word template, generate a report/proposal and attach it to an email in a pdf format. I already have the code to generate the proposal but can't seem to figure out the rest. Any help would be appreciated.