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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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:


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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
   5.     Set rsJob = Me.Recordset
   6.     Set rsChild = rsJob.Fields("attachments").Value
   7.     Set field = rsChild.Fields("filedata")
   9.       rsJob.Edit
  10.       rsChild.AddNew
  11.         field.LoadFromFile ("c:\temp\1.bmp")
  12.       rsChild.Update
  13.       rsJob.Close
  15.     Set fld = Nothing
  16.     Set rsChild = Nothing
  17.     Set rsJob = Nothing

Open in new window
lusfernandosAuthor Commented:
I have used another steps to help inserting the image.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.