Command button to open email template

[avarusbrightfyre]

So I have a command button that I'd really like to be able to use to create an email message in outlook that pulls from a specific template and fills in the record information from the currently selected record.



I've looked around and the docmd.sendobject seems to be the closest thing, but it seems to attach the template rather than putting the text into the body of the paragraph. I am aware that you can put text in the docmd.sendobject function arguments, but I want the end user to be able to adjust what the message says without having to know access code and such.

Is there a way to use the send object function to pull from a specified template and place that text into the body of the message? Or is there a better way other than send object to do what I'm looking for?

[June7]

Here's how I send an email:

'open Outlook, attach zip folder or file, send e-mail
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
    .BodyFormat = olFormatRichText
    .To = "email address"
    ''.cc = ""
    ''.bcc = ""
    .Subject = "text here"
    .HTMLBody = "text here"
    .Attachments.add ("path\filename")
    ''.DeleteAfterSubmit = True 'This would let Outlook send the note without storing it in your sent bin
    .send
End With

You can get the info for the email elements from textboxes on a form or recordset.

[avarusbrightfyre]

I'm not sure if I'm reading the code right. It seems to me that this code will generate an email with whatever you put in each line and can't be changed by a person who doesn't know the code. Also, I'd like the body of the text to come from a pre-made template that the user can open and edit without the need to understand access code. I don't really need any attachments.

What I'm looking for is an option that will pull the body of the email message from a template word document that is attached to the database and will then pull the required information from the currently selected specific record in access and "fill in the blanks" like the regular mail merge does.

I'm already able to do this with word documents using a free code set I found online (was a huge blessing!) that automatically opens the specified template and points to the record I have open in access and then automatically merges the document, but I have no idea how it works. I'm looking for exactly the same thing, but for an email instead.

So....is there a way to pull up an outlook message that draws the body of the email from an already created word document? I would preferably like it to just create the message and wait for the user to click the "send" button. Also, I need the end user to be able to adjust the template if needed when I'm gone and they're not going to be able to go in and change the VBA code.

All that being said, I'm not looking for a free handout or anything, just point me in the right direction. I can do research if someone knows a function that has all the things I need for it.

Thanks again!

[June7]

Any of the items you see in quotes (such as "email address") can be replaced with a variable. How you get that variable populated is the trick. I have never tried to grab content from a Word document and feed it into code. It's been a looooong time since I've done a document merge and was accomplished entirely within a word processor program, no database. Documents merged because of embedded code tags in both documents (an address list and a letter). You have a Word document template as an attachment in a record? This template must have embedded relationships to fields of a form.

So modify the code I provided to refer to a form as source of email elements, like:
.To = Me!fieldname
.HTMLBody = Me!fieldname

Replace .Send with .Display and the message will open and wait.
Comment out or delete the line about attachments.

Put code behind that form in a button Click event.

[avarusbrightfyre]

I definitely understand what you mean about pulling from fields on a form, but I really need to be able to pull from an external document. None of the other people in my office have any access development experience and they need to be able to just open up the required template, change it to what they want it to read and then save it and the access program will just pull the required text and merge fields from the word document. Otherwise, my master plan here won't work out, lol.

Is there a way to set the body of the email to pull from a word document? I understand all the other entries, it's the extracting from the word document that I don't know anything about.

[June7]

What you need to do is have user edit the Word document content in a form. Then have the Word document grab the info from the form (or actually the record that the form is entering data into). This is a merge procedure. Check this article http://office.microsoft.com/en-us/ac...010285219.aspx

Then the email procedure can refer to the same form. I don't know any way for the email procedure to grab data from a Word document.

I don't know if the edits can be done directly in the Word template and then those edits fed into Access. Might be doable with VBA coding in Word. I have never programmed in Word. Maybe the email procedure can be in a module in Word. Don't know.