How to create Labels with pictures?

Hi experts,

  I'd like to build a label based in a excel database. My excel is a tab delimited file and one of its column has a file name, which is the pictures name.
  I'd like to create an id card with this data and I'd like to use Word to do all this job. I have google it and I saw it is possible to use a logo, however this image would apper in every id card, that's not what I want.
  I want to be able to create picture id, based in a tab excel file. The photo is in the same directory as the tab excel file.
  Please find enclosed an example. excel-del.zip
LVL 2
lusfernandosAsked:
Who is Participating?
 
GrahamSkanRetiredCommented:
It isn't clear exactly what you are trying to do. If you want a set of different labels, you could use Mailmerge. The pictures could be in separate files with the locations in a column of the Excel sheet. You would then need to put the merge field into an INCLUDEPICTURE field.

With the field codes showing (Alt+F9 is the toggle), it would look like this:

{ INCLUDEPICTURE { MERGEFIELD picture } }

However, toy say that you do not want the image/s to appear on every card, so we have to know where you do want it/them.
0
 
Swapnil NirmalManager, Audit AnalyticsCommented:
Instead of using excel and word, use Access 2007. Please find attached Access database using using the students template. It contains data in students. Further see the report "ID Card" to fulfill your requirement.

Your first problem would be to update excel data in access. use the following code to update jpg in access database. just make the report same as "ID card" to serve your purpose.

   1.     Dim rsJob As DAO.Recordset2
   2.     Dim rsChild As DAO.Recordset2
   3.     Dim field As Field2
   4.  
   5.     Set rsJob = Me.Recordset
   6.     Set rsChild = rsJob.Fields("attachments").Value
   7.     Set field = rsChild.Fields("filedata")
   8.  
   9.       rsJob.Edit
  10.       rsChild.AddNew
  11.         field.LoadFromFile ("c:\temp\1.bmp")
  12.       rsChild.Update
  13.       rsJob.Close
  14.  
  15.     Set fld = Nothing
  16.     Set rsChild = Nothing
  17.     Set rsJob = Nothing

Open in new window

Students.zip
0
 
lusfernandosAuthor Commented:
I have used another steps to help inserting the image.

http://hubpages.com/hub/IncludePicture
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.