Save as cell reference then email
 

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

Save as cell reference then email
 

hi Josef,

You may some suitable code on one of Ron DeBruin's pages or on one of
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


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?u=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=203895

http://www.thecodecage.com/forumz