MIS Systems Thread, Sims Parent Email records to Outlook in Technical; Hi,
Does anyone export the email records in Sims to use as a mailing list and if so how do ...
13th January 2010, 01:29 PM #1
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.
By Luke_T in forum Office Software
Last Post: 9th September 2009, 11:11 PM
By farquea in forum Windows
Last Post: 6th September 2009, 01:50 PM
By CarolBooth in forum MIS Systems
Last Post: 23rd December 2008, 09:32 PM
By rush_tech in forum General Chat
Last Post: 8th April 2008, 12:46 PM
By BKGarry in forum MIS Systems
Last Post: 19th November 2007, 10:12 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)