Sending email attachment(s) from Excel 2007

**nobleprince** · 10-15-2010, 05:47 AM

Hi All,

I would like some help generating some code as I wish to send an attachment (located at c:\test.txt) with every email I send from Excel 2007. I have attached the file used to send emails using the UserForm method.

Cheers
Ash

**MarMo** · 10-15-2010, 07:35 AM

nobleprince ,

pls visit Ron de bruin's website.
He has a lot of info on this issue.

http://www.rondebruin.nl/tips.htm

If you cannot find anything there , pls come back to the forum and open a new thread.

**nobleprince** · 10-15-2010, 10:34 AM

MarMo / All, could you please send me the code as oppose to the generic link.

**jaslake** · 10-19-2010, 11:32 AM

Hi Ash
You need to simply add one line of code

Please Login or Register  to view this content.

I still have an open issue with you. Has it been "Solved"? If so, please mark it as such.

John

**nobleprince** · 10-27-2010, 12:12 PM

Hi John,

I tried adding single line but nothing happens. Did you manage to attach a file?

Regards!
Ash

**jaslake** · 10-27-2010, 12:48 PM

Hi Ash

Yes I tested the procedure with this line of code added

Please Login or Register  to view this content.

If C:\test.txt exists, it gets attached. If it dosen't exist nothing gets attached.

John

**nobleprince** · 10-28-2010, 11:06 AM

Hi John,

Thank you it works great.

**jaslake** · 10-28-2010, 12:33 PM

Hi Ash

Glad it works for you. If you're satisfied with the solution, please mark your thread as solved. A tip of the scales is always appreciated.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

John