Email PDF document from Excel using Word mail merge

[MarkHeersink]

Being a new contributor to this forum, i'm not a new user here, I used your forum often to get tips on how to crack VBA coding questions. This time, I cannot find the solution to something I want to build.

I want to build a macro which:
- takes details from a list in excel (a single row at a time)
- merging this with a nice formatted Word document
- and attaches this to an email (Outlook) in PDF format

I can find code for automatically mass mailing from Excel, sending PDF from a Excel worksheet and other ideas but not what I want.

Questions I have:
- Can this be build?
- Does anyone have tips on how to do this?