![how to do a mail merge in word 2003 from excel how to do a mail merge in word 2003 from excel](http://www.gmayor.com/Images_2007/2007Merge1.gif)
Its just getting Word to show the image thats either in the cell or from the link in the cell in the 'Photos' column that I need your help with.
![how to do a mail merge in word 2003 from excel how to do a mail merge in word 2003 from excel](https://stevechasedocs.files.wordpress.com/2013/08/example-of-data-list-excel1.jpg)
Ive got all the excel columns in the mail merge. If your Excel document has only one sheet, you’ll see only Sheet1. So, the excel file would be the same as above except links instead of the pictures themselves: B1:/dog.jpg B2:/cat.jpg. Choose the Excel worksheet you want to merge with the Word document and click OK. In addition to letters (which can be any sort of document, including certificates and coupons), you can choose emails, envelopes, labels, or directories as the document type. Select the Excel file you want to use as the contact list for your letter and click Open. Repeat this for other types of documents you'd like to use mail merge for. If you have used Excel to create your header file you will see a window appear where you can set the sheet that contains the header information.