Excel Email Macro

[Airdrielad]

HI, I have an EXCEL marco designed, which searches a particular folder (using a browsefolder function) for excel attachments, then it opens each file in turn, uses the filename (minus the .xls) and searches a worksheet using vlookup which contains email addresss to then populate the ".to" variable and automatically saves the the email to my oulook, as well as saving the open workbook as an attachment.

However, I cannot get the ".to" to be populated byt the email address, which is saved as a variable "Smail". Can anyone help? I am at my wits end....

I'm using Windows XP & Excel 2003/Outlook 2003

Please Login or Register  to view this content.

[Airdrielad]

Finally found the problem, The vlookup was referring to a worksheet that wasnt currently active, therefore the ".To" box was always empty. I have since added the following code in just before the Vlookup function:

Please Login or Register  to view this content.

[DonkeyOte]

Thanks for taking the time to post back with your resolution.