Sending a PDF letter from a row of a sheet - Excel 2010

Hi,

Hope someone can help.

The hospital I work at are taking away any support for Microsoft Access. Normally I use Access as a database for patient's details that I input into using forms/datasheets. From each form that is filled in I was able, at the click of a button to create a PDF that is attached to an email.

I have taken the data and moved it across to Excel 2010. I am able to view each row's data (now in Excel) using a form.

Is there anyway I can use the information from each row/form and create it into a PDF and then possibly use mail merge to place it into an email?

Not expecting a quick fix, but if there is a way that I can learn to put this process in place that would be really appreciated if someone can steer me in the right direction.

Thanks