How do I merge JPG photo URL into MS Publisher file?

Asked By 0 points N/A Posted on -
qa-featured

My excel spreadsheet has a URL field that links to a JPG format photo. I want to merge the URL into an MS Publisher file. I have tried to use the mail merge option but without success. The photo could not appear in the MS Publisher file. Is it possible to achieve what I want i.e. enabling a photo from a URL in a spreadsheet to appear in the MS Publisher file. If yes, explain how?

SHARE
Answered By 0 points N/A #116410

How do I merge JPG photo URL into MS Publisher file?

qa-featured

After looking at your question I think you don’t have much need to do the same. If this is correct then I will suggest you to you access instead of doing it in MS publisher. Access will be an easy and scalable option. If my assumptions are wrong and you have to do this in MS publisher then please use the following code snippet and that will help you to achieve the required results:

 

I am going to suggest this solution to you based on my understanding with MACROS. You can use the following macro to do the same for each page:

MyDocument.Pages(Pointer).Shapes.AddPicture();

 

Please let me know if this worked.

Login/Register to Answer

Related Questions