Email Body contents of word file

mattpfc

Active Member
Joined
Nov 21, 2002
Messages
299
Hi all,

I am creating a little tool on a system I currently use which will let me email my customers with their invoice information confirming their purchase. The code below is the section which builds the email with its various elements. Everything works fine apart from the body of the email. I am trying trying to send an email with a body that is from a template i have saved. This template has text and graphics in it but am unaware of a way to successfuly open an email with the body showing the contents of my word document template.

Can this be done??


Code:
With oEmail
    .Subject = EmailSubject
    .Body = email_string
    .To = EmailAddress
    .cc = "Chris.Chaddock@btinternet.com;"
    .Importance = olImportanceHigh
    .Display
    .send
End With


Code:
oWord_Document.Documents.Open Me.CommonDialog_Email_Body.FileName, False, True
email_string = oWord_Document.Documents(1).Content
EmailBody = email_string
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,221,821
Messages
6,162,157
Members
451,750
Latest member
pnkundalia

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top