Attachment Location as Cell Value

[jalrs]

Hello guys,

I want to address the location to the attachment through a cell value.

The attachment is named by cell(2,5).Value -> Row 2, Column E -> Formula here is:

=VLOOKUP(A2;Instructions!E:I;5;0)&"_"&F2

Formula on location column is -> Row 2, Column J ->

="C:\Users\joafrodrigue\Desktop\share\finaldocname\"&E2&".xlsx"

Therefore I addressed attachment as

attachment = cell(2,7).Value

on VBA

Happens that it doesn't upload the file when displaying the e-mail window.

Any help is appreciated,

thanks

 

[jalrs]

This line did the job

.Attachments.Add ThisWorkbook.Path & "\SubFolder\SubSubFolder\" & Cells(i, 5).Value & ".xlsx"