Prev: VBA Workbook Open Function
Next: VBA to check omissions and show/hide form
From: Josef on 19 May 2010 16:12
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
From: broro183 on 19 May 2010 17:34

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/showthread.php?t=203895

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: VBA Workbook Open Function
Next: VBA to check omissions and show/hide form