Converting data in Excel to Word and embeded images

My problem is the next:

1.- I have an Excel file with the following data:

Name.
Job.
RFC.
Adress.
Work.
Number Consecutive.

This information must be replaced in each Objet "TextBox" in the template "Template.dotx" in word.
In the The template of word exist the same fields that the sheet of Excel.

Excel                         Word
Name--------->(TextBox) Nombre
Job------------->(TextBox) Job
RFC----------->(TextBox) RFC
Adress------->(TextBox) Adress
Work---------->(TextBox) Work
Number (consecutive)------------>(TextBox) Number

2.-The template (word)  has three fields where three images are inserted locate in different folders,
The three images correspond to one data record in excel.
And must be replaced too, in each three Objet "TextBox" in the same template.
Image corresponds to know that these are named "RFC", the same  "RFC" in the field fromExcel.

Like this images:

C:\Carpeta\Photo------------ -> (image "JPG" (containing the photo) with the same name "RFC" of the person to which it belongs the "RFC") example:  AAJJ750421.jpg
C:\Carpeta\Singnature----> (image "TIF" (containing the signature) with the same name "RFC" of the person to which it belongs the "RFC") example: AAJJ750421.tif
C:\Carpeta\CodeQR--------> (image "JPG" (containing the codeqr) with the same name "RFC" of the person to which it belongs the "RFC") example: AAJJ750421.jpg

So the template will be filled with data from the sheet of excel and three images.
This process will be repeated 4000 times.
the resulting file will be a Word document format for each employee

Tanks

Alex.
DATA.xlsm
Template.dotx
LECA750301.tif
LECA750301.jpg
LECA750301.jpg
alexandro leónAsked:
Who is Participating?
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.

GrahamSkanRetiredCommented:
I suggest that you try Word's Mail Merge.

For the pictures you will need to embed the MERGEFIELD for the file address in an INCLUDEPICTURE field.
Use the Alt+F9 toggle to show the field codes, so that <<PHOTO>>  is shown as { MERGEFIELD PHOTO }
Select the field and press Ctrl+F9 to enclose the field in another empty field so that it looks like this: { { MERGEFIELD PHOTO } }. Type in the field name and quotes so that it looks like this: { INCLUDEPICTURE "{ MERGEFIELD PHOTO }" }.
Toggle back to the results view with Alt+F9.

Note that the field will not be visible in the results view.
Note also, do not type in the field delimiters (curly brackets ) individually from the keyboard. They are not the same .
0
GrahamSkanRetiredCommented:
Here is a partially completed mail merge document.

I have removed the datasource since it will have a different path from yours which makes opening it a bit tricky. You will have to set it up as a Letters type of merge document and use the Select Recipients button to find your workbook.
MailMergeMain.docx
0

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
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
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 Excel

From novice to tech pro — start learning today.

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.