Inserting multiple images from a unique URL to a word document via VBA

Hi Guys

I am trying to put together a macro that will insert multiple images into a new Word document. The images themselves are from a website URL, the URL which is concatenation of a URL and the data in column A.

Row 1 of my workbook is all headings. The URL I am using is "http://qrcode.kaywa.com/img.php?s=8&d=" with the value of Column A, starting at A2 and working its way down (to the last value).

As an example, A2 contains the data 1-85858, so the URL image will be http://qrcode.kaywa.com/img.php?s=8&d=1-85858.

In addition, I would like to be able to insert below each image the data that is respective Columns B and C (First and Last Name).

I've done some work on it and am having difficulties getting all of the images into one word document.

Sub Test1()

Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim objWdRange As Word.Range
Dim lLR As Long
Dim result
Dim ws As Worksheet
Dim LastRow As Long
Dim i As Long
Dim BrokerName
Dim GraphImage


lLR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To lLR
    result = Range("A" & i).Value
    BrokerName = Range("B" & i).Value & " " & Range("C" & i).Value
  
    GraphImage = "http://qrcode.kaywa.com/img.php?s=8&d=" & result

    Set wrdApp = CreateObject("Word.Application")

'Set objWdRange = wrdDoc.Content
With wrdDoc
        Dim wrdPic As Word.InlineShape
        Set wrdPic = .InlineShapes.AddPicture(Filename:=GraphImage, LinkToFile:=False, SaveWithDocument:=True)
        wrdPic.ScaleHeight = 50
        wrdPic.ScaleWidth = 50


End With
Next i
End Sub

The Word document itself doesn't have to save anywhere, can be saved by the user later on.

Attached is an Example of the Data (Excel Document where I would like to run the VBA from) and an Example of the Output I am looking for.

I appreciate any assistance.

Example Data.xlsxExample Output.doc

Regards,
Simon