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?
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.
