+ Reply to Thread
Results 1 to 2 of 2

Add to existing list of contacts and mail merge only to the new contacts

  1. #1
    Registered User
    Join Date
    06-19-2019
    Location
    UK
    MS-Off Ver
    2010 & 2016
    Posts
    1

    Add to existing list of contacts and mail merge only to the new contacts

    Hi
    I have a list of contacts in an Excel sheet, which is frequently being added to.
    I have columns for First name, Last name, email etc.
    I would like to mail merge, at times of my choosing, to those contacts that have been added to the sheet since the last time I mailed.
    An indication in each row (a Yes or No placed in a column?) that contacts have or have not been emailed would be useful.
    Is this possible? I'm guessing that some coding might be involved.
    This would be a nice introductory project for me to start learning.
    Thanks for reading.

  2. #2
    Registered User
    Join Date
    06-18-2019
    Location
    Chile
    MS-Off Ver
    MS OFFICE STANDARD 2013
    Posts
    7

    Re: Add to existing list of contacts and mail merge only to the new contacts

    What if you spilt your worksheets? Say you email 10 of your contacts today. New costumers (ie which haven't been emailed yet) would be added on another sheet or a new excel file. Whenever you want to email merge you select the appropiate sheet or file.

    If you still want to have a consolidated list of all your contacts you could use Power Querry to merge them all.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1