Save as cell reference then email

[Josef]

Hello all

I am having trouble building a macro to Save As named by a reference
to a cell then email it to a predefined email address.

Does anyone have any VB code to make it happen?
-Josef
Ms Excel 2007

 

[broro183]

hi Josef,

You may some suitable code on one of Ron DeBruin's pages or on one o
the links:
'Example Code for sending mail from Excel
(http://www.rondebruin.nl/sendmail.htm)
'Links on the Internet about mailing
(http://www.rondebruin.nl/mail/links.htm)

hth
Rob