Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
mail workbook
Hi,
I have a spreadsheet which has various macros in it. One macro existing copies the spreadsheet as values only into a new workbook and saves this onto the local disk as "Workbook name " as at now hh:mm am/pm etc. What I want it to do before it closes the activeworkbook is to email me with the subject "Workbook name" as at now, hh:mm. Anyone know the code I can insert into my existing macro? Thanks Adam |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
mail workbook
Adam
www.rondebruin.nl www.dick-clicks.com -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Adam" wrote in message ... Hi, I have a spreadsheet which has various macros in it. One macro existing copies the spreadsheet as values only into a new workbook and saves this onto the local disk as "Workbook name " as at now hh:mm am/pm etc. What I want it to do before it closes the activeworkbook is to email me with the subject "Workbook name" as at now, hh:mm. Anyone know the code I can insert into my existing macro? Thanks Adam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Result Change when Workbook Sent by E-mail | Excel Discussion (Misc queries) | |||
E-mail Excel workbook as hyperlink | Excel Discussion (Misc queries) | |||
How do to e-mail only one page of a workbook? | New Users to Excel | |||
Can I e-mail a workbook that contains links to other workbooks? | Excel Discussion (Misc queries) | |||
Can I e-mail only one worksheet in a workbook using MSN Hotmail? | Excel Discussion (Misc queries) |