merge values from excel file into .html file opened in word 2007
Posted
by Kelbizzle
on Super User
See other posts from Super User
or by Kelbizzle
Published on 2010-04-01T13:56:42Z
Indexed on
2010/04/01
14:03 UTC
Read the original article
Hit count: 492
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?
© Super User or respective owner