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.