Forum Discussion
Carl_61
Dec 19, 2024Iron Contributor
Mail Merge to Email Addresses
Need some help. I am using Excel as a data source and created word document templets for mail merging. With in the data source I have for columns for entering email addresses. Personal Email ad...
Carl_61
Dec 19, 2024Iron Contributor
I was hoping for a different result but I get it. I currently have individual records with individual email addresses for emails I stated here in. This gives me 4 separate columns plus the combined column of email addresses. I am doing a mail merge to all the personal emails, then a merge to work emails and so on. Is this what you are saying as the work around? It would be nice if this functionality was part of a future version.
Carl
HansVogelaar
Dec 19, 2024MVP
Using 4 separate mail merges is one option.
Another is to use formulas to return as many copies of a row as non-empty email addresses in that row, and populate one column with those email addresses. So for example if the original source has a private email address and a work email address, you'd create two copies of the row, with the personal address in one row and the work address in the other.
But I guess that 4 mail merge runs is easier in the end.