Insert a picture from userform into bookmark in word document
I am a novice at vba but have created a userform to be used to insert customer data into bookmarks in a word template. All of the code inserting text from text boxes on the userform works fine but it doesn't work for the image. Instead of the image it uploads a string of numbers. The relevant part of the code is below:
Dim Proposal As Range
Set Proposal = ActiveDocument.Bookmarks("Proposal").Range
Proposal = Me.Image1.Picture
The bookmark name is Proposal which is where I want a JPG image (Image1) to be placed. The image has been uploaded to the userform via a command button and is visible on the userform.
Any help to correct the code would be much appreciated.
|