General discussion

Locked

Send Excel file with multi-sheets

By frankus ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Send Excel file with multi-sheets

by roc180 In reply to Send Excel file with mult ...

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

Collapse -

Send Excel file with multi-sheets

by frankus In reply to Send Excel file with mult ...

The reply was very useful. Thank you!

Collapse -

Send Excel file with multi-sheets

by frankus In reply to Send Excel file with mult ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums