merge values from excel file into .html file opened in word 2007
- by Kelbizzle
I have this newsletter I've written. I want to be able to use the values in the rows and some how have them merged into this html file I have opened in word. Sort of like a mail merge. In the newsletter I have 3 urls that look like:
www.mydomain.com/php?id=
I want to be able to replace all of the urls for all 230 records in the excel file. With something like:
www.mydomain.com/?id=$id
Where $id would get replaced with the id of the record.
And the same goes for the rest of the rows like $firstname $lastname $email $phone number
Is there a simple way to do this?
