Mar 21, 2004 #1 Peps Programmer Feb 11, 2001 140 ES Hi Guys, Just a couple of quick questions, is it possible to email the results of a query (as text) using the SendObject cmd? Is there a limit to the amount of text you can send from Access97 to Outlook by using the SendObjet cmd? Peps,
Hi Guys, Just a couple of quick questions, is it possible to email the results of a query (as text) using the SendObject cmd? Is there a limit to the amount of text you can send from Access97 to Outlook by using the SendObjet cmd? Peps,
Mar 21, 2004 #2 vbainchicago Technical User Aug 7, 2003 102 US Send the results of the query into a report, then attach the report to an e-mail using the mentioned action as a text file. VBAinChicago http://www.jjscomputing.comhttp://www.blueboxshopping.com Upvote 0 Downvote
Send the results of the query into a report, then attach the report to an e-mail using the mentioned action as a text file. VBAinChicago http://www.jjscomputing.comhttp://www.blueboxshopping.com
Mar 22, 2004 Thread starter #3 Peps Programmer Feb 11, 2001 140 ES Hi VBAinChicago, I can't do that, the emails are being sent via satellites to ships, attachments are normally cut out to save money on connections. Peps Upvote 0 Downvote
Hi VBAinChicago, I can't do that, the emails are being sent via satellites to ships, attachments are normally cut out to save money on connections. Peps