Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Database creation

  • 23-09-2011 11:54AM
    #1
    Days
    Registered Users, Registered Users 2 Posts: 63 ✭✭


    Hi I'm starting my database of customers at the moment. I have it in excel. But I want to be able to exclude an email or phone number. For example if a person emails me and tells me that they don't want to be on our mailing list that's fine I can take them out, but if they get back on? How do I deal with that, any way to to on excel. Or is there a website I can use for my database, that is secure of course.

    Thanks


Comments

  • #2
    Johnboy1951
    Registered Users, Registered Users 2 Posts: 13,978 ✭✭✭✭Johnboy1951


    Excel is hardly Open Source ...


  • #3
    croo
    Moderators, Technology & Internet Moderators Posts: 1,338 Mod ✭✭✭✭croo


    I think this might be better in the developer section.
    Moving...


  • #4
    OREGATO
    Registered Users, Registered Users 2 Posts: 898 ✭✭✭OREGATO


    Have a flag with an integer value and name it 'mailing list'. If the user wants to subscribe, set the cell value to 1 otherwise zero.

    When you're generating your mailing list, filter value and set to 1, extract email addresses and send.

    Hope this helps.


  • #5
    Robdude
    Closed Accounts Posts: 709 ✭✭✭Robdude


    If this is something you intend to do by hand - you can use something like Google Docs. It's free and it's online (so you can worry less about things like your hard-drive failing and losing the important spreadsheet).

    I agree with OREGATO's suggestion - have another column called 'MailingList' and a value that indicates if they get mail or not.


Advertisement
Advertisement