Displaying pictures from a field with a file path

okiegirl · #2 07-27-2012, 07:34 AM

OMG! Yea, I figured out how to get the picture in, the only problem now is to get the picture to insert in the location I want. Here is how I fixed the issue:

I recorded a macro of me inserting the picture and then I took the recorded macro and copied and pasted it into the event behind the command button in Access that performs the mail merge where it would run right after it opens the Word document. Worked great! Now I just need to figure out how to make the picture come in sized 3.5 x 5.7 and on the 3rd line with a border. Does anyone know how I can modify the below VB to do this type of formatting?

Here is my modified code that brings the picture in:

Code:

Private Sub Command127_Click()
 
'generates the individual comp template for the current record
LOCAL_TEMPLATE = Me.txtCompTemplate
 
'SEE IF THE TEMPLATE IS OPEN
DoCmd.SetWarnings False
 
'THIS QUERY CREATES A TEMP TABLE FOR THE MERGE
DoCmd.OpenQuery "qryCompData", acViewNormal
Call OPEN_WORD_MERGE_DOC(LOCAL_TEMPLATE)
 
'This is a copy of the Word macro to bring in the picture
'Will need to change Filename to a field from Access, this was to see if it worked
Selection.InlineShapes.AddPicture Filename:="K:\AC_CompPics\210019544.jpg" _
, LinkToFile:=False, SaveWithDocument:=True
 
End Sub

Thanks a million!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
File Path for Outlook 2007 pst	eliz.bell	Outlook	2	10-29-2011 07:04 PM
Displaying contact pictures in e-mail header	christer	Office	0	10-03-2011 09:40 AM
Modify default template to include file path	jacl	Excel	1	03-26-2011 10:24 AM
Show Full File Path in Title Bar	paulj	Excel	3	02-10-2010 07:18 AM
get file name without Path	Ziggy1	Word VBA	1	09-29-2006 07:55 PM