Outlook Mail Merge Configuration
Budget: $10 – $30 USD
I would like someone to setup the outlook mail merge logic. I have an excel spreadsheet with various columns.
For example - Column A, Column B, Column C
I would like the mail merge to be configured as follows....
If there is data in Column A, it should return a preset message on line 1, then check Column B and Column C for data and return a preset message for each of them (on separate lines, so lines 2 and lines 3)
If there is NO data in Column A, then it should check to see if there is data in Column B, then return a preset message, then check Column C for data and return a preset message for each of them (on a separate line)
If there is NO data in Column B, then it should check to see if there is data in Column C, then return a preset message
For example - Column A, Column B, Column C
I would like the mail merge to be configured as follows....
If there is data in Column A, it should return a preset message on line 1, then check Column B and Column C for data and return a preset message for each of them (on separate lines, so lines 2 and lines 3)
If there is NO data in Column A, then it should check to see if there is data in Column B, then return a preset message, then check Column C for data and return a preset message for each of them (on a separate line)
If there is NO data in Column B, then it should check to see if there is data in Column C, then return a preset message