Win a copy of Machine Learning for Business: Using Amazon SageMaker and JupyterE this week in the Jython/Python forum
or Object Design Style Guide in the Object-Oriented programming forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Paul Clapham
  • Jeanne Boyarsky
  • Knute Snortum
Sheriffs:
  • Liutauras Vilda
  • Tim Cooke
  • Junilu Lacar
Saloon Keepers:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Joe Ess
  • salvin francis
  • fred rosenberger

How to send multiple email messages to different contacts

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I am a beginner in programming. I would like to have your advise about which application to use in order to send multiple email messages to different contacts once but individually.
More exactly, I need to create a table in which all persons will be filled with their email addresses in a separate column. The forst column will be for the names, the second column will contain the messages being delivered to the contacts (a separate and different message for each contact) and the third column will have the email addresses. After filled the second column I would like the application be able to send the messages separately to each contact but only clicking on a button. I think Microsoft Access would be able to do this job but I need to know how to program it in Access. Many thanks for every help!
 
Sheriff
Posts: 4723
309
IntelliJ IDE Python Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In Microsoft speak I think you'd call this a "mail merge". I expect there's less programming required than you'd think, but I'd start by searching for "mail merge" in the context of MS Office products.
 
Tim Cooke
Sheriff
Posts: 4723
309
IntelliJ IDE Python Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And welcome to the Ranch!
 
Bartender
Posts: 1868
81
Android IntelliJ IDE MySQL Database Chrome Java
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to CodeRanch Vales Goles.

You are almost correct Tim (this depends on the version of MS Access).
Mail Merge is when you want to create physical labels for envelopes and other packages which us the postal system and that is all that it can do. I've done this too many times to count.
Newer versions of MS Access allow you to use Mail Merge for doing exactly what you want to do.
Plus they allow you to create physical labels for envelopes and other packages, just like older versions.
However you may need to have Microsoft Word and/or Microsoft Outlook installed on the same system that has Microsoft Access and the Access database.

The key Google phrase here is
ms access mail merge email
Your results should include one or more links to a Microsoft web site explaining how use the Mail Merge Wizard to accomplish your task is under 12 steps, no programming required.

A few notes of caution:
  • Your email service provider may not like you doing this and may consider your email SPAM.
  • If this is a corporate thing and your business has you own email server then you should double check with the email server team before completing this task.
  • I would advise against attaching files to these emails. Binary attachments in emails are expended by at least 5% on the email server when in transit.
  • Your email client (Outlook) or your workstation, may not function as expected when sending if there are many (hundreds) emails being sent.

  • One of the good things about Microsoft Office products is that they can usually talk to each other without hassle. For instance in MS Access and MS Excel can share data, this is done using a built in wizard.
     
    Vales Goles
    Greenhorn
    Posts: 2
    • Mark post as helpful
    • send pies
    • Quote
    • Report post to moderator
    Thanks for your answers. I will try what you suggested me and I will keep you informed.
    Many thanks!
     
    Would anybody like some fudge? I made it an hour ago. And it goes well with a tiny ad ...
    Sauce Labs - World's Largest Continuous Testing Cloud for Websites and Mobile Apps
    https://coderanch.com/t/722574/Sauce-Labs-World-Largest-Continuous
    • Post Reply Bookmark Topic Watch Topic
    • New Topic
    Boost this thread!