+ Reply to Thread
Results 1 to 7 of 7

Excel Generic Bulk Mailer

  1. #1
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Excel Generic Bulk Mailer

    I've been kicking this technology around for about a decade. The attached application is designed to send out a bulk email by filling in a table and clicking a button. The only requirement is to enable the macro. It can be copied and modified to suit whatever bulk mail you might have. It is as generic as I can make it at the cost of some data validation.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,911

    Re: Excel Generic Bulk Mailer

    I have to admit that I am TOTALLY against any sort of bulk email programs. We get enough crap emails as it is, without this forum helping to generate more!
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Excel Generic Bulk Mailer

    There is a valid reason for the development of this program. In my job we have over 150 suppliers to whom we have to send reports every week. It used to take each buyer about 8 hours a week to do it manually. It now takes them about 5 minutes. What's more, the program is designed to be run by another buyer to cover them in their absence.

    The version I use at work is a bit more customized in that the suppliers get a three-tab spreadsheet specifically designed for them and the subject and body of the email is customized for them.

    I also get called upon to do ad-hoc mailings such as warning our suppliers of a spoofed email sent in the company's name and sending out notices on terms and conditions, privacy notices and such.

    I can imagine other companies have similar requirements to mass mail employees, customers, suppliers and other people that they do business with.

    A true spammer is going to buy a package that is much more efficient than the one I wrote.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    51,911

    Re: Excel Generic Bulk Mailer

    Valid reasons can be made for any program/process - I am still...and always will be...against this sort of thing.

  5. #5
    Registered User
    Join Date
    01-19-2022
    Location
    Alaska, USA
    MS-Off Ver
    2013
    Posts
    13

    Re: Excel Generic Bulk Mailer

    Quote Originally Posted by dflak View Post
    I've been kicking this technology around for about a decade. The attached application is designed to send out a bulk email by filling in a table and clicking a button. The only requirement is to enable the macro. It can be copied and modified to suit whatever bulk mail you might have. It is as generic as I can make it at the cost of some data validation.

    Make sure your data source has a column for email addresses and that there's an email address for everyone you're sending email to. And follow these following steps

    1- Go to Mailings > Select Recipients.
    2- Choose a data source. For more info, see Data sources you can use for a mail merge.
    3- Choose File > Save.

  6. #6
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,410

    Re: Excel Generic Bulk Mailer

    The application I use this for is as a mailer to send weekly "report cards" to our suppliers. I have a table with a list of buyers, suppliers and the supplier email addresses. I do check for the existence of an email address before attempting to mail the report out.

  7. #7
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    20,875

    Re: Excel Generic Bulk Mailer

    Quote Originally Posted by Victoriaviolet View Post
    Make sure your data source has a column for email addresses and that there's an email address for everyone you're sending email to. And follow these following steps

    1- Go to Mailings > Select Recipients.
    2- Choose a data source. For more info, see Data sources you can use for a mail merge.
    3- Choose File > Save.
    @Victoriaviolet This is in the Tips forum. It is not a question, it is an example solution. Your post is only vaguely related to the topic. Repeated posts like this will earn infractions or a ban.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mass Mailer CC's me How do I stop it?
    By dflak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2021, 04:47 PM
  2. Renewal due auto mailer with excel row- need macros
    By sweetykamdi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2019, 12:58 PM
  3. Auto mailer to send only new entry in excel
    By Supriya Shukla in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-03-2016, 06:24 AM
  4. Auto Mailer using Macro
    By VENKYS in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2010, 09:34 PM
  5. automatic mailer to a certain id
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-10-2010, 04:25 AM
  6. Automatic Mailer
    By arnab0711 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2010, 07:37 AM
  7. changing colums to rows for a mailer
    By exodus125 in forum Excel General
    Replies: 4
    Last Post: 05-18-2009, 03:00 PM

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