Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2021, 01:36 PM
mtandino mtandino is offline Can images be inserted using mail merge with a unique identifier? Windows 10 Can images be inserted using mail merge with a unique identifier? Office 2016
Novice
Can images be inserted using mail merge with a unique identifier?
 
Join Date: Dec 2019
Posts: 3
mtandino is on a distinguished road
Default Can images be inserted using mail merge with a unique identifier?

So I have a list of about 55 employees. The employees are judged in 3 areas, Office, Floor, Sales. Each area has a designation of either Raise, Stipend, Bonus, or Nothing. All the employees are listed in one document as well.

The pictures are saved as O-Raise, O-Stipend, O-Bonus, and O- Nothing for Office, F-Raise, F-Stipend, F-Bonus, F-Nothing for Floor, S-Raise, S-Stipend, S-Bonus, S-Nothing for Sales. They are saved in a local folder on the computer. If that code is found within the report, I would want to replace the text with the matching image.



The report would be listed something like this:

John Doe - Office
[REPORT O-Bonus]

John Doe - Floor
[REPORT F-Nothing]

John Doe - Sales
[REPORT S-Nothing]

Jane Doe - Office
[REPORT O-Raise]

Jane Doe - Floor
[REPORT F-Nothing]

Jane Doe - Sales
[Report S-Stipend]

Report is the several page long report regarding the employee in that specific field. The image title represents what image needs to be inserted in that report. So in the example above, the same image would be inserted into John and Jane's reports for Floor because they have the same image code. There are of course 53 other employees who need images inserted as well.

Can image insertion be done via mail merge utilizing criteria such as this or should I look to use another method to insert images tied to specific text?
Reply With Quote
  #2  
Old 01-05-2021, 02:16 PM
macropod's Avatar
macropod macropod is offline Can images be inserted using mail merge with a unique identifier? Windows 10 Can images be inserted using mail merge with a unique identifier? Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,702
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

The issue of image insertion in a mailmerge is addressed in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
identification, image insert, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
E-mail merge with unique attachments in Office 365 debora Mail Merge 1 10-21-2019 11:38 PM
Can images be inserted using mail merge with a unique identifier? Word mail merge with unique charts retro Mail Merge 8 09-11-2019 02:56 PM
Can images be inserted using mail merge with a unique identifier? Mail Merge List of Items for Unique OwnerIDs HunterH Mail Merge 1 10-12-2018 02:03 PM
Can images be inserted using mail merge with a unique identifier? Mail Merge URL - a unique question kitefrantic Mail Merge 1 12-31-2013 07:34 PM
Can images be inserted using mail merge with a unique identifier? data roll up under unique identifier NewGirl Mail Merge 1 11-15-2012 04:47 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft