Hi,

I'm trying to create an Excel macro to eventually produce a mail merge document in Word.

The macro should use the data of a particular row in the excel file and produce a mail merge document.

I have gone through the VBA 2007 programers reference, but the books gives the example of mail merge from ms access.

Any suggestions would be much appreciated.

Hi,

I have not looked at the mail function yet, but guess if you set the reference to the outlook, word library, include your code, then insert into word the values from sheet rather than ms access should work also. You can define your variables to be values from cells e.g. strFirstName = Cells(1,2)