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

Asked By Fiona Meneses 0 points N/A Posted on - 01/20/2012

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?

• Status: Open
• Question Views: 1017
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Microsoft Others

Answered By ELM_Steve 0 points N/A #116410

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

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.

About ELM_Steve

Questions
0

Answers
27

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 01/23/2012
• Question Category: Microsoft Others