question

JurgenVerhelst-1030 avatar image
0 Votes"
JurgenVerhelst-1030 asked $$ANON_USER$$ Deactivated commented

Word Label mail merge with image only if there is a record

Hi Guys,

spent most of my sunday getting my mail merge skills up to speed ;)

SITUATION
List of computernames (10 in this example)
Avery 48 label per sheet A4
Label should have a logo on it when there is data

PROBLEM 1
I can click "Update Labels" and the 10 names populate the first 10 labels. but the image get replicated to all labels. I want it to only show on the labels that contain a computername.

WORKAROUNDS
I could first print the logo on all labels first. Then make a new document without the logo and just the computername records and feed the logo labels back in the printer and print only the names the second pass. But would be cool to do it in one go.

PROBLEM 2
Zo lets assume I get the first and only first 10 labels printed with Logo A. Next day I need to print 15 more with a different label, so I copy the same document and switch the label and update the recipients. How can I tell word to start at label 11 as the ten before are already used? By adding 10 empty records in the source?

82116-image-089.png


office-word-itpro
image-089.png (173.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@JurgenVerhelst-1030

PROBLEM 1:

but the image get replicated to all labels.

How did you insert the image? Is it by inserting in the label or from the source list?
If it is from the source list, I suggest you back up files first, then delete the corresponding images to check the issue.
Besides, you could Edit individual labels to delete the unnecessary images after completing the merge.
82364-64.png

PROBLEM 2:

How can I tell word to start at label 11 as the ten before are already used?

Do you mean to print the next 15 labels immediately after the first 10 labels?
Could you provide us with a sample file? So that we can check the issue better. Thanks for your understanding.

Any misunderstandings and updates, please let me know.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


64.png (6.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JurgenVerhelst-1030 avatar image
0 Votes"
JurgenVerhelst-1030 answered $$ANON_USER$$ Deactivated commented

Hi Emily

I followed this MS video

video-format-and-add-a-graphic-d7755be9-b24c-4f25-82ca-ba6ebeddf41c



So I added the image in the first label and then clicked update labels.

But I thing you get what I am trying to say right? If I only hve 5 records in the access DB, I want word to only print the firt five labels with computernames and the image and leave the other labels empty

I attached the document. Oh no I cannot upload a doc file here. How can I send you?

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@JurgenVerhelst-1030
Thanks for your reply.
Currently Q&A forum does not support uploading Word documents as a attachments.
You may post a new thread on Q&A forum with tag "qna-feedback" to feedback this issue.
Thanks for your understanding.




0 Votes 0 ·

@JurgenVerhelst-1030
Based on the effective information provided by PaulEdstein-5060, I had a test. If you want to achieve the results of PROBLEM 1, you may need to change the way to insert images.
83480-1.png

Please go to Insert > Quick Parts > Field > Select IncludePicture and type the path of Image, click OK.
Then press Alt + F9, change to as shown in the left of the following image. Then press Alt + F9 again, click Update Labels. You could see the right of the following image under the Preview.
(As PaulEdstein-5060 said, "{}" must be added by Ctrl + F9.)
83601-2.png

For PROBLEM 2, You could also refer to the links provided by PaulEdstein-5060.

0 Votes 0 ·
1.png (14.4 KiB)
2.png (34.5 KiB)

You do not need INCLUDEPICTURE fields for this. As described in my post, the image can be inserted directly into the IF field. Nor do you need * MERGEFORMAT or the empty "".

0 Votes 0 ·
$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ Deactivated answered

The simple solution for (1) is to insert the image in an IF field coded along the lines of:
{IF{MERGEFIELD Data}<> "" "Your image goes here"}
where 'Data' is any field that is any field that exists for all valid records (e.g. 'ComputerName').

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. The spaces represented in the field constructions are all required.

For (2), see:
https://answers.microsoft.com/en-us/msoffice/forum/all/mail-merge-labels/163507a6-1f4d-40d8-a6b7-84313c29bd13
https://www.msofficeforums.com/73079-post6.html

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.