How do i attach the bound object frame to the body of email?

**dmcmillo** · 10-17-2015, 01:08 AM

Hello Everyone. I'm having a very tough time trying to figure out how to get this to work. Please help????

My email comes out like this:

Click image for larger version.

Name: Access.JPG
Views: 11
Size: 32.1 KB
ID: 22429

here's my code:

Private Sub Complete_Click()
Dim OL As Outlook.Application

Dim MyItem As Outlook.MailItem

Dim sHTML As String
Dim sSubject As String

Dim sTo As String
Dim sCC As String

'Dont forget to specifiy the references for the object library
'This is the body of the email, the " are breaks for the html

sHTML = "<html><body> Collation Team," & " " & "AutoRelease priorities have been chnaged to the below settings." & " " & "Reason" & " " & _
"New Settings" & " " & "" & " </body></html>"

sSubject = "Collation AutoRelease Priority Change"
'sTo = ""
'sCC = ""
'calls the function to email
Call SendEMail(sTo, sCC, sSubject, sHTML)

End Sub

**June7** · 10-17-2015, 05:15 PM

Where do you want the Reason text to come from? A textbox on form?

AFAIK, the image must come from an external file using <img> tags.

sHTML = "<html><body>Collation Team, AutoRelease priorities have been changed to the below settings. Reason: " & Me.textboxname & " " _
"New Settings: <img src='filepath/imagename' alt='some text' style='width:145px;height:126px;'></body></html>"

**dmcmillo** · 10-19-2015, 11:47 PM

Originally Posted by June7

Where do you want the Reason text to come from? A textbox on form?

AFAIK, the image must come from an external file using <img> tags.

sHTML = "<html><body>Collation Team, AutoRelease priorities have been changed to the below settings. Reason: " & Me.textboxname & " " _
"New Settings: <img src='filepath/imagename' alt='some text' style='width:145px;height:126px;'></body></html>"

I want the reason text to come from a text box on the form.

I added the syntax from the modified code you added here. I get a problem now with the image. Shows a x image. Am i not refernceing everything i need to?

Click image for larger version.

Name: ImageTest.JPG
Views: 8
Size: 18.0 KB
ID: 22442

Click image for larger version.

Name: References.JPG
Views: 8
Size: 39.4 KB
ID: 22443

sHTML = "<html><body> Collation Team," & " " & "AutoRelease priorities have been changed to the below settings." & " " & "Reason:" & Me.Reason & " " & _
"New Settings:" & " <img src='filepath/imagename' alt='some text' style='width:145px;height:126px;'></body></html>"

**June7** · 10-19-2015, 11:54 PM

Well, you must use some actual filepath and image filename from your computer in place of the example 'filepath/imagename'.

**dmcmillo** · 10-20-2015, 12:43 AM

That may be my problem. I was trying to just paste an image in the bound object frame. I figured this would be easier as there can be many variations of the image that is pasted. Is there a way?

**June7** · 10-20-2015, 11:10 AM

Pasting image into object frame (https://www.accessforums.net/modules...ect-27704.html) will not resolve including image in email.

**dmcmillo** · 10-20-2015, 11:14 PM

This doesn't help me. I rather not have to call for excel to paste the image. Is there a way i paste a random image into a field (If not bound object frame then What>) and send it with the text in my email???

**June7** · 10-20-2015, 11:20 PM

Again, only method I think available is to attach to email external image file.

I posted that link because it seemed to lead to an Access VBA solution for pasting image into object frame.

**dmcmillo** · 10-20-2015, 11:31 PM

OK Np i follow you now. I'm trying to get away from the million Spreadsheets we use right now. I will continue to look, that may be an option down the road. Thanks

!

**June7** · 10-20-2015, 11:50 PM

Doesn't matter how you get image into object frame. It won't help get image attached to email.

**dmcmillo** · 10-20-2015, 11:53 PM

Originally Posted by June7

Doesn't matter how you get image into object frame. It won't help get image attached to email.

So is the only way to go the excel route to get the image in body of email???

**June7** · 10-20-2015, 11:59 PM

That Excel link has nothing to do with attaching image to email. It was about getting image into object frame. Image must be an external file for attaching to email.

**dmcmillo** · 10-21-2015, 12:01 AM

Originally Posted by June7

That Excel link has nothing to do with attaching image to email. It was about getting image into object frame. Image must be an external file for attaching to email.

ok i feeling completely lost now. Forgive me. Please walk me through this method if you have time...

**June7** · 10-21-2015, 12:14 AM

Walk you through what - attaching external image file to email? I already gave example code for that in post 2.

**dmcmillo** · 10-21-2015, 12:21 AM

Ok yeah i remember that example and i tried it. Even with the source location and filename. still got the image with x. how do i fix that?

How do i attach the bound object frame to the body of email?

Thread Tools

How do i attach the bound object frame to the body of email?

Similar Threads

Bound Object Frame

Bound Object Frame Combo sorted Results

Using attached document as source for Bound Object Frame

The bound or unbound object frame you tried to edit doesn't contain an OLE object

Posting Permissions