Mail Merge Pictures using MS Excel and MS word

  javaBalls 13:21 29 Jun 05
Locked

I would like to mail merge picture files into a MS word document.

I have successfully done this using MS publisher but I does anyone know how to do this with MS word?

The Excel file looks like this:

Forename Surname image
John Smith image1.jpg
Karen McMcCall image2.jpg

Note: if the image files are in the same location as the excel files then all that is required is the file name.

And the Word document looks like this:

«Forename» «Surname» «image»

The problem is that the image tag does not contain the properties of an image. There is an option in Publisher to 'insert as picture' but there does not seem to be an equivalent in Word.

  recap 13:31 29 Jun 05

In your <image> field, try entering the file path of the image this may work?

  javaBalls 13:43 29 Jun 05

recap - I've tried this also. It just displays exactly what is in the cell and not the image.

i.e. the word doc shows:
C:\Documents and Settings\MyName\My Documents\folder\image1.jpg

  brambles 19:36 29 Jun 05

I would first of all Open a Word document.
Tools MAIL MERGE Create FORM LETTER use ACTIVE WINDOW
Get DATA Open DATA SOURCE but click not the Word Option BUT the Excel type of file and locate the Excel Database you want to use.

Edit Main Document when you get a warning that Word can't find any merge fields.

You will now have a Merge Fields button - left hand top.

Click on the fields you want.

Write the letter

Insert the Picture

Click on MERGE button

WORD TOOLBAR BEFORE YOU START ENSURE THE DATABASE TOOL IS LOADED.

IF IT ISN'T RIGHT CLICK ON A BLANK GREY PART OF TOP TOOLBAR AND TICK DATABASE.

Suppers ready - best of luck

Brambles

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…