Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a range of data then E-Mail
I prefer to copy a range of data ex. B4:H27 to the body of the message. Mix
of text and values. Copy values only. Then send to the same user each day. Also we are using Office 2000 and XP both prompt repeatedly for user input when using any Excel SendMail code. Is there a way around this? I need to schedule this as a task each morning without any user intervention. I don't want to buy any third party software just do this using Excel VBA or VB6. Any suggestions, samples etc. would be really appreciated. Thanks, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to look up and copy a changing range of data ? | New Users to Excel | |||
How do I copy a range of data to another sheet? | Excel Worksheet Functions | |||
macro to copy only range with data | Excel Discussion (Misc queries) | |||
Copy Range Data Macro | Excel Discussion (Misc queries) | |||
How do I copy data range of the same name to another tab? | Excel Worksheet Functions |