File Attachment Macro Question

[lawre2000]

Hello, I am attempting to attach a file to an email with a macro and am currently using:

.Attachments.Add ("H:\PALMERL\Power Report Test.xls")

Is there a way to reference the file name from a cell but keeping the same directory? Perhaps it is easier to have both the path and file name both located in the same cell reference.

Thanks

 

[John_w]

If just the file name is in A1 on the active sheet then:

.Attachments.Add "H:\PALMERL\" & Range("A1").Value

or if both the folder path and file name are in A1:

.Attachments.Add Range("A1").Value

 

[lawre2000]

Thank you

 

[Tom.Jones]

I