EMailing Work Sheet Trying to Attach File Listed In Cell

Hello all any help will be appreciated. I am new at macros and need a little help. I am using a macro to e-mail any work sheet with an address in A1. I would also like to attach a file that will be listed in cell E1 of that worksheet. The file is different for each work sheet that is being sent but will be listed in the same cell of each work sheet.

This is the code I am using (i got it from ron de bruin) when I use the .Attachments.Add (C:\test1.txt) it works but i can not seem to figure out how to get it to read the file address in the E1 cell. The code i am trying to use is .Attachments.Add = ws.Range("E1").value Thanks in advance for any help you offer.

Please Login or Register  to view this content.

hello
Maby somethink allong the lines of

Please Login or Register  to view this content.

Hi

I'm assuming E1 contains just the filename. In which case include the path, either hard coded as here or as a variable
Change the line to

Please Login or Register  to view this content.

HTH