Check out Ron's site. Maybe it will answer your question.

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

"Curt" wrote:

Have a folder (Parade) within it is (Parade.xls) I am after (MailE)in
Parade.xls Is there a way to get to this worksheet in VBA I wish to use this
worksheet for mail merge. Can copie it to C:\ and delete after. Was hopeing
to not have to go this route Parade\Parade.xls\MailE didn't work or other
combos. Anyone?
Thanks