Scheduled email of a datalink file

Discussion created by Jay5962 on Aug 27, 2010
Latest reply on Jan 19, 2012 by mhalhead

I’ve got a simple problem I’m sure vcampus member have already solved many times before, hence I’d like to borrow off experience to find the cleanest and most efficient solution.


I would like to wrtite a ACE routine to send a daily email to user group containing a datalink file with refreshed values for that day. What are some of the best practices to be followed eg: message handler(CDO or Mapi?), how to refresh the spreadsheet etc. All advice would be greatly be greatly appreciated as I rather borrow off existing infrastructure than write everything from scratch.