How to send embedded word document as a mail

[ravidcurious]

Hi All,

I'm a new bee in access with VBA. I'm doing a project and got stuck somewhere. Please help me.

Problem discripton: I'm using ACCESS 2010. I have a form which is having a embedded word document. What i'm trying to do is i want to enable user to format a mail in the embedded word document which will contain rich text and screenshots then with a click of button an outlook mail should open and content of this document should be pasted there. Once user sends this email, i want to save contet of embedded document in the database.

Many thanks in advance !

 

[spikepl]

Your requirement sounds, on the face of it, pretty strange. Describe what your application is about in business terms, and the workflow that leads to your not very common setup.

 

[ravidcurious]

My requirement is to track all mails of a perticular process from all the employees in a centralized location. To enable this i want to use embedded document in access for formating the mail and with the click of a button one mail will be sent to the intended recipents and one copy will be saved in a word document and link of this this document will be saved in an access file. All senders and recievers will follow the same process thus mails from all the users will be saved in the centralized location.

 

[David R]

Hrm. Could you save the 'email' as a PDF report instead, maybe?

Or one of my processes emails an Excel spreadsheet, so it saves the spreadsheet in a central location, and we rely on Outlook to store the data about the actual email and attachment.

 

[spikepl]

You should separate needs from your intended solution. It is not clear here which is which.

If Word is required then why? If embedding Word-documents is required then for what purpose? Why do mails have to be saved inside a Word document, when they can be saved in Outlook, or other mail client, and also in native mail format?