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.