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 !

[zmbd]

ravidcurious
That is quite the undertaking!
We ask that each thread be limited to one question and that the question be fairly limited in scope.

Some advice,
1) Do not use an embeded document - use a template instead.
2) I would suggest using the automation code with that template. Your Access tables can have the links to the images, store the body text etc... for examples of automation code: http://bytes.com/topic/access/insigh...ion-automation This covers Outlook and Excel; however, word will have the same concepts - just different object model.
3) Storing the documents within the database will quickly fill up the 2GB limit especially with graphics. I would offer instead that your Access tables store a link to the file
4) Interoperoperations between the two programs will be somewhat tricky, even with the automation code.

[gutts009]

In Word 2010 and in Word 2007, the Send to Mail Recipient feature is not available in the Ribbon. To use this feature, you must add this command to the Quick Access Toolbar (QAT). To do this, follow these steps.

Word 2010

On the File menu, click Options.
Click Quick Access Toolbar, and then click All Commands in the Choose commands from list.
In the list that appears, click Send to Mail Recipient, and then click Add to add the command to the Quick Access Toolbar.

Word 2007

Click the Microsoft Office Button Office Button, and then click Word Options.
Click Customize, and then click All Commands in the Choose commands from list.
In the list that appears, click Send to Mail Recipient, and then click Add to add the command to the Quick Access Toolbar.

Word 2003 and Word 2002

To send a document directly from Word 2003 or from Word 2002 as an email message, follow these steps:
On the File menu, point to Send To, and then click Mail Recipient to send the document as the body of the message. Or, point to Mail Recipient (as Attachment) to send the document as an attachment to the message.

Note If Send To or Send is not available on the File menu, you must install Microsoft Outlook, Microsoft Outlook Express, or a Messaging Application Programming Interface (MAPI)-compliant third-party email program. For more information about Outlook and Outlook Express, see the "How to install Microsoft email programs" section that follows.
If the Choose Profile box appears, select Default Outlook Profile or another valid profile that you have created, and then click OK. Word adds an email header to the document.
Type the email address of the recipient on the To line, or select the email address from your Address Book.
Type a subject for the email message on the Subject line.
Click Send a Copy if you want to send the document as the email body. Or, click Send if you want to send the document as an attachment.

Note In Word 2010 and in Word 2007, if you click Send to Mail Recipient by mistake and want to cancel the action, click Send to Mail Recipient again. In Word 2003 and in Word 2002, if you click Send a Copy by mistake and want to cancel the action, click Send a Copy again.

Thanks
Jeff Jones

[zmbd]

Because there have already been a few views since Gutts009 post, there is a need to clarify some information:

In Word 2010 and in Word 2007, the Send to Mail Recipient feature is not available in the Ribbon.

Other than for convenance, none of the instructions are required as the feature is available via the backstage. Ribbon>File>[Save & Send]>select option
I have cut off the pane for Office/Word2010 for space; however, in my installation there is an option to send via "Attachment," "Link," "PDF Attachement," "XPS Attachment" and "Internet Fax."

Note If Send To or Send is not available on the File menu, you must install Microsoft Outlook, Microsoft Outlook Express, or a Messaging Application Programming Interface (MAPI)(...)

This is true if you wish to use the built in features; however, I do believe that the CDO method is still available at the OS level. However, this would require the use of VBA to accomplish.

@Gutts009: How does your post help ravidcurious accomplish the posted goal of automating the entire process?

@ravidcurious: I still stand by my first reply.
1) Embedding the documents is not really the best situation.
2) If you can tell us specfically where and how you got stuck, perhaps we can get you moving again; however, without some more detailed information there's not much more that can be done.
3) Please keep in mind that there is still the single question limit per thread.
(^_^)

[ravidcurious]

Hi ZMBD,

Thanks for taking time and providing guidance.

Sorry, i didn't know the rules but i think breaking the problem in the pieces will not give all possible ways in which the problem could be solved. (Peices will not create a bigger picture)

1. I was using embedded document just to format the mail.

2. I have not tried mail template, will give a try and ask you if i need help.

3. I'm going to store mails in word documents and in access table a link to the document. If i use template then i should be able to a) save template code in a word document b) load content of word document in the template (for forwarding and reply).

4. Will try every possiblity.

I will do some home work and come back to you.

@GUTS009 Thanks for taking your time however that will not solve my problem.