Sims Parent Email records to Outlook
Does anyone export the email records in Sims to use as a mailing list and if so how do you do it.
I would prefer to keep them all in the same place and had an idea of running a report with the emails listed then creating a macro to do the following.
- Merge the 3 columns into one (theres pupil email addresses, parents home and work)
- Copy and replace in place deleting duplicates
- Type ; in column 2 next to each record
- Copy all the cells
Then all the user has to do is paste them into the to field in outlook.
Almost got it but wondered if anyone has a better way to do it.