We currently use MS Office 2003 and are trying to encourage the use of tools such as Mail Merge to speed up some mundane functions within departments.
Our Finance Team are trying to use Merge to Email using a Excel data source where the email field contains multiple email addresses. The table has been laid out this way as each row of data is unique and may have to be sent to one or more recipients. To keep the table as simple as possible, rather than add in multiple rows of the same information for each recipient we want to send one row of data to multiple people. We have tried entering the email addresses within one cell, separating the addresses with semicolons and commas, surrounding all the addresses and the addresses individually with quotes to no avail..
The only other way that I have thought this might be possible would be the creation of Distribution Lists, and send to the DL rather that to the addresses individually.. Anyone got any other thoughts on how this can be achieved?
