Clicking Hyperlink to create an email and attach specific files

[Gkr1981]

Hi All,

I am trying to create a hyperlink upon clicking on the link it will generate a new email (this part I can do) however I also want to attach two files listed in a folder that is listed a few cells above.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client 1[/TD]
[TD]Client 2[/TD]
[TD]Client 3[/TD]
[TD]Client 4[/TD]
[/TR]
[TR]
[TD]C:\1\File.xlsx[/TD]
[TD]C:\2\about.xlsx[/TD]
[TD]C:\3\abc..xlsx[/TD]
[TD]C:\4\xyz.xslx[/TD]
[/TR]
[TR]
[TD]D:\1\File1.xlsx[/TD]
[TD]D:\2\About2.xlsx[/TD]
[TD]D:\3\abc2.xlsx[/TD]
[TD]D:\4\xyz2.xlsx[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]HYperlink to create an email and attach above files[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


The data above is a primary table of what I'm trying to do.

I have a Create Sheet, where I capture all the data, and I click "Create", and this copies all the data to a summary page.

I need the hyperlink to look above in the "Create" sheet, and when it copies across to the summary page, it can reference the same rows as it goes across in the table.

Is this possible?

Cheers
G

 

[Gkr1981]

Is there anyone who can assist with this? Or is this just not possible?

Cheers
Graeme