Discussion Locked

Send Excel file with multi-sheets

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I would like to send an email with either:
1. Several attachments, or
2. An Excel File created from several tables ,each in a different worksheet
via email directly from the application (say with a command button on my form.

3 replies

by roc180

Use OLE automation from your application to create an EXCEL object. Once you have a code reference to the object you can manipulate it through code (Add workbooks, worksheets, save the file, etc..). Depending on your Email system (Outlook, Groupwise, Lotus Notes) you can write code to attached the file and send it much the same way you created the Excel file. The code is not extremly difficult but depending on your exact needs it may be lengthy. Check out Microsoft.com for examples of OLE automation.

Good Luck
Neal Martinelli

This discussion is closed to new replies.