Hi,
I'm trying to create multiple JPG files with a birthday greeting for use on Facebook (Full explanation at end) Using MS Publisher.
So each JPG would have a message saying "happy Birthday <<Name>>"
and would save to a file named <<name>>.jpg

I've created the start of an excel file with 3 columns: Name, Save folder path and file name which should be attached to this post hopefully, but this is as far as I can get using the merge feature (I have previously used Mail merge with Excel to create newsletter style personalised emails so I have a little experience but not much).

My purpose behind this is I have several thousand Facebook friends, many with the same name and I like to put up birthday greeting every day, changing the background picture every year to keep it fresh. In previous years I have created a template with publisher and gone through the birthday names every morning, changing the name and saving each JPG separately. I figure I can use the file names from the previous year to populate the excel list fully and automate the process to give me a folder with 500+ JPGs all named after the greeting it contains (Aaron.jpg, Adam.jpg, Allen.jpg etc.) allowing me to just click on each birthday profile and add the picture without having to create new files each day as needed.

Thanks in advance for any help or advice
Tim

Attached Files

0-Names.xlsx (10.2 KB, 10 views)