Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-30-2018, 01:37 AM
Ulises_hm Ulises_hm is offline Mail merge - pictures instead of url INCLUDE PICTURE Windows 7 64bit Mail merge - pictures instead of url INCLUDE PICTURE Office 2016
Novice
Mail merge - pictures instead of url INCLUDE PICTURE
 
Join Date: Jan 2018
Posts: 1
Ulises_hm is on a distinguished road
Default Mail merge - pictures instead of url INCLUDE PICTURE

Hello,



I am trying to pull data including pictures from excel and into word. The problem is that I am getting the URLs and have tried with different formulas to get the photos instead but have not been successful.

Please look at my template in word. The formula that I am trying is only in the highlighted cell of the word table. For all the others it is the formula with the link.

Any help is greatly appreciated.
Attached Files
File Type: docx Recommendations_link.docx (61.4 KB, 25 views)
File Type: xlsx mailmarge.xlsx (70.2 KB, 20 views)
Reply With Quote
  #2  
Old 01-30-2018, 03:14 AM
gmayor's Avatar
gmayor gmayor is offline Mail merge - pictures instead of url INCLUDE PICTURE Windows 10 Mail merge - pictures instead of url INCLUDE PICTURE Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Merging images and hyperlinks are not straightforward - see http://www.gmayor.com/hyperlink_merge_fields.htm and http://www.gmayor.com/mail_merge_graphics.htm and http://www.gmayor.com/mail_merge_graphics_addin.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 01-30-2018, 04:07 AM
macropod's Avatar
macropod macropod is offline Mail merge - pictures instead of url INCLUDE PICTURE Windows 7 64bit Mail merge - pictures instead of url INCLUDE PICTURE Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Additionally/alternatively, see Mailmerge Hyperlink ‘Click Here’ Insertion 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
includepicture, url

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge - pictures instead of url INCLUDE PICTURE Include Table of Contents by Mail Merge Field vandelayindies Mail Merge 1 01-08-2018 03:06 PM
Mail merge - pictures instead of url INCLUDE PICTURE how to format a picture switch in a merge field to only include the numbers in the middle? becca Mail Merge 2 06-08-2016 01:15 PM
Mail merge - pictures instead of url INCLUDE PICTURE How do i include embedded images in a mail-merge? Hindmost Mail Merge 14 09-18-2015 02:01 PM
Mail Merge with Pictures DewaldDeJager Mail Merge 10 12-23-2013 01:15 AM
Mail merge from Excel to Word and include hyperlinks chay Mail Merge 5 09-28-2013 01:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:05 AM.


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