Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-02-2018, 08:07 AM
catflap's Avatar
catflap catflap is offline Merging graphics from url Windows 7 64bit Merging graphics from url Office 2013
Advanced Beginner
Merging graphics from url
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default Merging graphics from url

Hi



I'm trying to set up a merge field which will either:

1. Display a graphic retrieved from a url in a merge field if the url is OK.
2. Display some placeholder text if no url is in the merge field.
3. Display some placeholder text if the url text is present but no graphic can be downloaded - ie a bad url

I've managed #1 and #2, but #3 is causing me problems. This is what I have so far:



blank.jpg is just a blank graphic file I've made to act as a spacer.

'No image' text appears if the url text is blank.

But how can I check if the url text is present, but not correct?

If I run this as it stands I get a message appearing 'The linked image cannot be displayed. The file may have been moved.... (etc) - that's what I'm trying to avoid.

Thanks!
Reply With Quote
  #2  
Old 05-03-2018, 05:26 PM
macropod's Avatar
macropod macropod is offline Merging graphics from url Windows 7 64bit Merging graphics from url Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

The mailmerge can't check that - you need to validate the data beforehand.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-04-2018, 02:12 AM
catflap's Avatar
catflap catflap is offline Merging graphics from url Windows 7 64bit Merging graphics from url Office 2013
Advanced Beginner
Merging graphics from url
 
Join Date: Aug 2015
Location: UK
Posts: 72
catflap is on a distinguished road
Default

OK thanks - it's a shame, but I might now download all the graphics first and then link to the files so I can control it better.

Good to know it can't be done so I don't keep banging my head against the wall trying to work it out!

Cheers
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to keep graphics with text DBlomgren Publisher 0 07-12-2016 12:20 PM
Graphics Filters judicial85 Office 0 10-15-2011 10:46 AM
Graphics won't print TechEd Drawing and Graphics 2 08-11-2011 05:37 PM
Merging graphics from url ^g for all graphics, what about drawings only? ghumdinger Word 8 06-22-2011 08:30 PM
Merging graphics from url Graphics resolution Roscoe Drawing and Graphics 5 07-02-2010 07:43 AM

Other Forums: Access Forums

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


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