Sending Email from MS Access

[iritesh]

Hi All,
Hope you are doing well.
I need help to send email from MS Access as I have millions of vendors to whom I need to send email notifications when payment has been released to them through email.

Conditions:

1. Each vendor has multiple records of consultants to be selected from MS access.
2. Email needs to be send to vendor pulling record from Vendor list table with Specific subject line identified for that vendor
3. Emails should attach excel file while sending email.
4. Excel file should include only record pertaining to that vendor to whom email will be sent.
5. If email was not able to send vendor, then need record for those vendor.
Your help in this matter will be highly appreciated.
P.s. I don’t have technical knowledge of VBA or Macros.
Thank you.

 

[pr2-eugin]

Hello Rithes, Well what you are trying to achieve is quiet a long way to go.. As all your requirements are dependent on each other at one stage or other.. For all this to work, you need to have a good understanding of how VBA code works.. Sending email via Access is quiet common and there are plenty of threads available right here on this forum.. Some would be available just under this thread, scroll down to the bottom of the page you will find similar threads..

So lets see what you have and what needs to be done regarding the issue..

1. Each vendor has multiple records of consultants to be selected from MS access.

You will need a Query that will organize these information.. Based on the Vendor ID/ any information that will uniquely identify the Records.

2. Email needs to be send to vendor pulling record from Vendor list table with Specific subject line identified for that vendor

Is there a table in your database, that have the appropriate Subject lines for every Vendor?

3. Emails should attach excel file while sending email.

Not a problem look for examples.

4. Excel file should include only record pertaining to that vendor to whom email will be sent.

How do you wish to achieve this? Are the files separately (organized and) stored ?

5. If email was not able to send vendor, then need record for those vendor.
Your help in this matter will be highly appreciated.

What do you mean by not able to send email? No valid email ID?

P.s. I don’t have technical knowledge of VBA or Macros.
Thank you.

That is the Key here.. You have to understand how it works before just copying and pasting the code; even if you do copy & paste, please understand how that part of the code works, so if in case you are struggling with an error you will know what to ask..

Start with the basics.. You will be there in no time..

 

[iritesh]

Hi

Thanks for the reply. Please see my comments below:

1. Is there a table in your database, that have the appropriate Subject lines for every Vendor? (Ritesh) - Yes It has.
2. How do you wish to achieve this? Are the files separately (organized and) stored ? (Ritesh) - Yes It should be as backup on local computer drive.
3. What do you mean by not able to send email? No valid email ID? (Ritesh) - Yes, if it is not a valid email id or email bounce back due to any reason.

 

[LukeChung-FMS]

You could have this up and running in minutes with our commercial Microsoft Access Email product Total Access Emailer.

It will let you send personalized emails to your list of contacts including attachments filtered to each recipient. You simply need to create a query with the list of email addresses to send. In your case, it would be the vendors that need to be notified.

You can create a message that references data in your query and/or attach a file that has information filtered for that vendor (based on a table or query). You can also have an Access report that's filtered to each vendor and attach it as a PDF. For security, you could compress and password protect it.

It runs as an add-in which requires no programming. For automation via VBA module calls, get the Professional Version, which will let you tie your email blasts to events or other VBA code through a VBA library interface. The Professional Version also includes runtime distribution rights so you can include it in your Access application and distribute it to non-Total Access Emailer owners royalty-free.

A free demo is here: http://www.fmsinc.com/MicrosoftAccess/Email/free-trial.html

Hope this helps.