underscorede
04-24-2012, 08:58 PM
Hello,
I know mail merge is easy to use and speaks for itself, but we are encountering a problem with a bottleneck with having to insert a company logo on each individual name tag we create.
We are creating a name tags based on a list of names using mail merge. After the name tags are created we have to individually add the company logo to each persons name tag.
The issue is this:
The company logo is always different depending on the day of the week. Ie: For Monday the name tags all have "company A's logo" on Tuesday all the name tags have "company B's logo"
Is there way i can add some VBA to my spreadsheet so that when I open "names.xls" a dialogue box appears and asks me to insert first name, then last name, then gives me the option to select a company logo from my desktop using a "browse" button.
Has anyone ever done this before? Or does anyone have any recommendations on an easier way to automatically change a company's logo from day to day without having to change each individual name tag.
I know mail merge is easy to use and speaks for itself, but we are encountering a problem with a bottleneck with having to insert a company logo on each individual name tag we create.
We are creating a name tags based on a list of names using mail merge. After the name tags are created we have to individually add the company logo to each persons name tag.
The issue is this:
The company logo is always different depending on the day of the week. Ie: For Monday the name tags all have "company A's logo" on Tuesday all the name tags have "company B's logo"
Is there way i can add some VBA to my spreadsheet so that when I open "names.xls" a dialogue box appears and asks me to insert first name, then last name, then gives me the option to select a company logo from my desktop using a "browse" button.
Has anyone ever done this before? Or does anyone have any recommendations on an easier way to automatically change a company's logo from day to day without having to change each individual name tag.