Populate Mailmerge word document from list of excel data

Hi Guys,

I'm trying to do a Mail merge through vba from list of Excel data into one word document with uniqe information on each page.

Eg. In excel row contains rows of data with state city and representative column this should appear One row info in each page as like
State City Representative
ACT Canberra Yang
NSW Coffs Harbour Roulston
NSW Dubbo Kristiansen

i.e Yang
ACT, Canberra

Yang thank you for the support

----Same as like this-------

I have created code but it works for one row after that page is not adding up and not populating any infor.

Please Login or Register  to view this content.

Thanks
Thiru

This page is an interesting read as it speaks about Excel and Word with mail merge in mind too. Have a look at it:

http://gregmaxey.mvps.org/word_tip_p..._combobox.html