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

Related posts about mail-merge

Related posts about excel-2007