Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 21st 09, 08:28 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2008
Posts: 14
Default Automatically Send Excel Spreadsheet Daily

Is it possible to send an excel spreadsheet daily to an email address at a
specific time e.g 5:00 pm.

Thanks

  #2   Report Post  
Old May 21st 09, 11:36 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Automatically Send Excel Spreadsheet Daily

Chip Pearson explains how to use Application.ontime (excel has to be open) he
http://www.cpearson.com/excel/OnTime.aspx

If you don't want excel open, maybe you can find a windows scheduler that you
like--some versions of windows have one built in.

And if I were going to learn about sending a workbook via excel, I'd start with
Ron de Bruin's site:
http://www.rondebruin.nl/tips.htm

======
Heck, I've never done this, but maybe you can find out how to use your
scheduling program to email the file you want and drop excel completely.

Zee wrote:

Is it possible to send an excel spreadsheet daily to an email address at a
specific time e.g 5:00 pm.

Thanks


--

Dave Peterson
  #3   Report Post  
Old May 22nd 09, 02:51 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,101
Default Automatically Send Excel Spreadsheet Daily

It is better to do this as an outlook macro. See under VBA help in Outlook

Reminder Event


You can schedule in outlook a daily event for 5A:00 PM. Then when the event
occurs you can attach an excel workbook to an email and sent the email.

"Zee" wrote:

Is it possible to send an excel spreadsheet daily to an email address at a
specific time e.g 5:00 pm.

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can i set a button in excel to automatically send the page when George Excel Discussion (Misc queries) 1 December 21st 07 02:33 AM
Daily send copy of Excel Spreadsheet Via Email Sean Excel Discussion (Misc queries) 1 March 19th 07 04:36 PM
daily personal expense spreadsheet in excel MB Excel Discussion (Misc queries) 1 October 26th 06 09:29 PM
Macro to automatically open a website or send an e-mail in excel Byron Excel Discussion (Misc queries) 3 April 7th 06 09:05 AM
How do I automatically send daily email of updated Excel workbook. How to automate emails with excel file. Excel Discussion (Misc queries) 1 May 9th 05 08:55 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017