Using excel data to send email

**InsideShoulder** · 01-30-2019, 11:41 PM

I am a refugee from filemaker pro with no real excel experience. I want to create a workbook of projects which will include the client's email address and the project name, among other bits of data.
Each project will occupy a seperate row in the sheet and I have set up some lookups to limit data entry.
I would like to know if it is possible to populate email fields (address and subject, where subject = project name) by creating a "script" or a macro in excel.
The solutions I have seen on here seem to envisage sending a whole sheet to a fixed (i.e. does not change according to row) email address.
Thanks in advance for any help you are able to offer.

**kersplash** · 01-30-2019, 11:43 PM

You might be better attaching a sample of your data and mock-up what you are trying to achieve.

Go Advanced -> Manage Attachments -> Upload

**InsideShoulder** · 01-31-2019, 12:30 AM

Hopefully the file is attached.
My plan iso click the "email" button to have excel populate an email with the row of data relating to the row of the sheet in which the button was clicked - if there is some means other than use of a button which can achieve the outcome that's cool too.