Getting full file path instead of photograph in mail merge document

[mso3]

Bump!

Hi friends,

I want to insert a photograph in a mail merge document for each record. I'm getting a full file path of a jpg file instead of a photograph in a mail merge document.

Any help will be highly appreciated.

Thanking you in anticipation.

[mso3]

Bump!

Hi friends,

I want to insert a photograph in a mail merge document. I'm getting a full file path of jpg file instead of a photograph in word document.

Any help will be highly appreciated.

Thanking you in anticipation.

[macropod]

See Managing Mailmerge Graphics in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-m...ps-tricks.html
or:
http://windowssecrets.com/forums/sho...ips-amp-Tricks

[mso3]

Hi Paul,

Greetings from me!

Thank you. First of all I take an opportunity to congratulate you for your excellent guide for mail merge. I visited the sites you suggested and found it informative. However, I didn't understand the instructions to insert an images in a mail merge document. I'm confused. Will you please see my document attached in a first post and guide me step by step instructions to achieve the target?

Sorry for trouble.

Thank you and have a nice day.

[macropod]

The instructions in the links are about as straightforward as they can get. Since the path to the images is held in the same field as the image name in the mailmerge data source, you could use a field coded as:
{IF{INCLUDEPICTURE {IF TRUE "«Image»"} \d} {INCLUDEPICTURE {IF TRUE "«Image»"} \d}}
or:
{IF{INCLUDEPICTURE {IF TRUE "{MERGEFIELD Image}"} \d} {INCLUDEPICTURE {IF TRUE "{MERGEFIELD Image}"} \d}}

and, as Note 1 at the top of the link page says:
The field brace pairs (i.e. '{ }') for the above examples are all created in the mailmerge main document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this thread or another website. Nor is it practicable (for the most part) to add them via any of the standard Word dialogues. Likewise, you can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the 'Insert Merge Field' dropdown. The spaces represented in the field constructions are all required.

[mso3]

Hello Paul,

Extremely sorry for not able to insert image in a mail merge document despite the clear instructions. The instructions in the links are about as straightforward as they can get. I click on insert mail merge field and get a column 'PICTURE' field to insert. After that in word document I get a merge field 'picture' with brackets. After running mail merge I get a full file path of picture which is in column 'picture' in excel file.

Please see my word and excel file and suggest me what I'm doing wrong.

Sorry for trouble. If possible send me a corrected file to understand your suggestions clearly.

Thanking you and have a nice day.

[macropod]

Extremely sorry for not able to insert image in a mail merge document despite the clear instructions. The instructions in the links are about as straightforward as they can get. I click on insert mail merge field and get a column 'PICTURE' field to insert. After that in word document I get a merge field 'picture' with brackets. After running mail merge I get a full file path of picture which is in column 'picture' in excel file.

Please see my word and excel file and suggest me what I'm doing wrong.

Well, what you say you're doing isn't even close to what the instructions tell you to do. Inserting the «PICTURE» mergefield is only a small part of what's required. My last post even spelled out what you need to do...

[mso3]

Hi Paul,

Sorry! I didn’t understand the instructions correctly. I didn’t get an image path as per your suggestion. I do not understand where I’m going wrong. Please see the word mail merge output and suggest me correction.

I’m doing it first time so I have a problem to follow the instructions correctly. Please don’t mind and guide me to achieve this target positively.

Sorry for trouble.

Thank you and have a nice time.

[macropod]

There is nothing in your attachment to indicate that you've done anything more than just use your original mergefield. If you want help, you might at least post a document containing your implementation of the field code.

[mso3]

Hi Paul,

Extremely sorry for not understanding the instructions. I press F9 after inserting the original merge field 'picture' in the word document but no change in merge field. So I manually type the code you suggested in the word document but no require image output.

Please guide me what shall I do after inserting the original merge field 'picture' in a word document. I have a problem here to understand the next action.

Sorry for trouble.

Thank you and have a nice day.

[macropod]

So I manually type the code you suggested in the word document but no require image output.

Which only goes to show you have ignored the instructions you were given, both in the link and in post #5.

[mso3]

Hi Paul,

Now I changed the field name in excel file and got the merge field as per your suggestion in word document. Then ctrl +A and then F9. But still there is something wrong in my understanding. I’m getting the full path instead of picture.

Now I’m nervous. Will you please share a corrected workbook for me to understand the mail merge image problem well? I’m feeling myself feeling guilty for not understanding your guidance correctly. I don’t want to trouble you more and waste your time on me.

Sorry.

[macropod]

You did not need to change anything in the Excel workbook. Messing around with the mergefield's code the way you have isn't going to achieve anything either. Maybe you should try do what the instructions say you need to do.

[mso3]

Dear Paul,

Extremely sorry for trouble. Really I'm confused and not understanding the instructions correctly. Therefore, I request you to send me a corrected copy of mail merge document and excel workbook. I will learn from that sample attachment. I found it very difficult to understand.

Do send me a corrected sample positively for my better understanding.

Sorry for trouble and have a nice time.

[macropod]

See attached. Select the field and press Shift-F9. Then compare the field code with what the instructions say to do...

[mso3]

Hi Paul,

Thank you for picture field attachment. Since yesterday I tried my level best to follow your instructions to insert a picture in a mail merge document but in vain. I want to insert pictures in my mail merge document without fail. I’m feeling very guilty of me because since last 2/3 days you are guiding me to achieve the target patiently and I’m not able to follow you.

Therefore, to achieve the target and close this prolonged thread I humbly request you to create a macro for me to avoide manual job. I’m optimistic that it will solve my problem.

Please don’t mind and assist me positively.

Waiting to receive a positive response from your end soon.

Thanking you in anticipation.

[macropod]

I’m feeling very guilty of me because since last 2/3 days you are guiding me to achieve the target patiently and I’m not able to follow you.

Therefore, to achieve the target and close this prolonged thread I humbly request you to create a macro for me to avoide manual job. I’m optimistic that it will solve my problem.

I'm certainly not going to provide a macro to create something that requires you to do nothing more than either:
1. follow some instructions that thousands of others have followed over the years; or, even more simply,
2. copy and paste from the attachment I provided.
As far as I am concerned, this discussion is ended.

[mso3]

Hi Paul,

Greetings from me!

Now I have worked on it but I have problem in editing the path. I have deleted a column ‘picture’ from the database. There is a ‘NAME_E’ column which contains the names of persons. The file name of jpg file and name of person in column ‘NAME_E’ are same inn matching.

Problems:
1. Unable to delete .jpg extension from inserted picture file path. It selects entire path when the cursor moves on it. So I’m unable to edit it. How to make it editable?
2. To avoide the the problem I changed the file format ‘word 97-2003’ format but in vain.
3. Which is the correct format to save the file and output file?

Steps I followed:

1. Ctrl + F9 3 times
2. Type ‘ INCLUDEPICTURE ’ in between second and third bracket.
3. Type ‘ IF TRUE “
4. Insert a picture file ‘link to file’ (here I want to delete the file extension .jpg which I’m unable to edit.)
5. Insert merge field ‘NAME_E’ and type extension .jpg “
6. Type ‘ \D ‘ in between first and second closing bracket.
7. Select the link; copy it
8. Press ctrl + F9; paste the link.
9. Type ‘ IF ‘ in a left most first and second opening bracket.


I’m attaching both word files for your reference. Please see it and guide me where I’m doing wrong. How to overcome this problem. Now if I run mail merge then there is no image.

Sorry for trouble.

Thanking you.

[macropod]

See the last sentence in my previous reply. You have already had more than enough help.