Hello
I have a mailmegere all in one file that has customer details to be put onto a letter, then the letter is signed off but one of our advisors depending on where the customer lives. the excel sheet that the data is taken from has the addvisor name for each customer in a collum. because I want multiple Signatures appearing in the one mail merge depending on who the advisor is, is there a way to do that rather ran creating 10 different mail mergers as I have 10 advisors???
Thanks Jordan
Hi,
one option would be to add the signature lines for each advisor in the data file, one column per signature line. If you're using Excel as your data source, you could auto-fill these columns from a table where all your advisors are listed via VLOOKUP.
Alternatively, you could use Word to check the name of the Advisor and add the signature lines based on the advisor name with an IF statement in Word. Looks ugly, something like:
I'm not sure how many nesting levels can be achieved, but I hope you get the general idea.Code:{ IF { MERGEFIELD advisor }="Bill Gates" "Ex Microsoft CEO" { IF { MERGEFIELD advisor }="Steve Jobs" "Apple CEO" "Sales Representative" } }
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks