Results 1 to 4 of 4
  1. #1
    arjun5381 is offline Novice
    Windows 8 Access 2007
    Join Date
    May 2016
    Posts
    12

    How To Send Bulk Email With There Relevant Data From Ms Access Table, Access 2007

    Hi,



    i want to send email to multiple users with there relevant attached information from MS Access Table.

    Suppose In a table having all Account details where Account Number, Outstanding Amount, Email ID & Owner Name.

    Ex.
    Collection Guy 1'st --> he is responsible for 100 Accounts (it means 100 rows)
    Collection Guy 2'nd --> he is responsible for 20 Accounts (it means 20 rows)
    Collection Guy 3'rd --> he is responsible for 40 Accounts (it means 40 rows)
    Collection Guy N'th --> he is responsible for 45 Accounts (it means 45 rows)

    Here I want to send bulk emails to all collection guys with there relevant attached account details with Excel Format.

    can you please help me to automate this process through MS Access VBA. Please find the Sample data for your referanceClick image for larger version. 

Name:	Untitled.png 
Views:	16 
Size:	109.8 KB 
ID:	25292Email_With_Attachment.accdb

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In a form , have a list box with all those to email. Person, email.

    A combo box to pick the query. The one to email. This query will look at the person in the email listbox and pull his/her data.
    Select * from table where person= forms!frmEmail!lstEmails

    now a button to scan the list and send each person THEIR data....
    Code:
    sub btnSend_click()
      for I = 0 to lstEmails.listCount-1
           SName= lstEmails.item(I)
           LstEmails = sName
            STo = lstEmails.column(1)    ' get the email address from list box
            
            Docmd.sendObject  acQuery, cboQry, ,,,,...sTo, ....   'Send email here using the query in cboBox
      Next
    end sub

  3. #3
    Kennertoy is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    29

    How to send bulk emails from MD Access

    Hi Ranman256,

    I like your code but I have had problems with my mail server (Telus) that restricts me to 25 emails at a time and a maximum of 100 per day. do you have any comments of changes you could recommend to accommodate this restriction? I use my database to communicate with some 175-200 fellow workers
    for various events. The one I always struggle with (because of this restriction of the server), is the Xmas luncheon invitation. I usually manually patch the addresses from my query into the email. I thought I would try to find a solution. Yours would work but I have to limit each email as above. Thanks in advance for any thoughts you may have.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If the information is not private between recipients I can think of 3 possible options.
    1) send all the information in the email body, prefaced by the recipient name (either in one large email or broken into groups).
    2) send an attachment such as a spreadsheet or pdf version of a report that contains the aforementioned information, again in one email
    3) find another email provider with fewer limitations.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 15
    Last Post: 10-17-2015, 07:02 AM
  2. Replies: 2
    Last Post: 01-30-2015, 09:08 AM
  3. Replies: 10
    Last Post: 11-01-2013, 01:20 PM
  4. Replies: 6
    Last Post: 12-28-2012, 01:26 PM
  5. Replies: 6
    Last Post: 06-26-2012, 12:16 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums