+ Reply to Thread
Results 1 to 3 of 3

Loop through Access table and send e-mails - conception

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Loop through Access table and send e-mails - conception

    Hi guys,

    i have query in Access like in attachment.

    Bez*tytu?u.png

    E-mail is the same for company number & Area.
    So for company1 and area Wrocław there will be [email protected]
    But for company2 and area Bydgoszcz there will be [email protected].

    Now i want to send for key company-area e-mail.
    within first e-mail should be:

    50002 company1 Wrocław Document1
    50002 company1 Wrocław Document2
    50002 company1 Wrocław Document3
    second e-mail:

    50002 company1 Bydgoszcz Document2
    50002 company1 Bydgoszcz Document1
    How can i do this?

    I can send e-mails (i have code) but i need to find suitable VBA object in order to do this.
    I am thinking about dictionary.

    Key would be company-wrocław and item document1 but how to add more then 1 item into dictionary?

    All help will be welcome,
    Best Wishes,
    Jacek Antek
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Loop through Access table and send e-mails - conception

    Here is a video using an older version of Access that demos how to email from Access. You should be able to adapt this to later versions

    http://www.datapigtechnologies.com/f...sendemail.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Loop through Access table and send e-mails - conception

    thank you alansidman.

    i solved the problem using only dictionary:

    Please Login or Register  to view this content.

+ 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. Replies: 1
    Last Post: 01-26-2016, 01:05 PM
  2. [SOLVED] Send mails with attachment
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2015, 10:00 PM
  3. Unable to send mails problem
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2015, 09:32 PM
  4. Send sheet data to access table
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-05-2015, 02:43 PM
  5. Send custom E-mails from Excel
    By lord_enzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-07-2012, 06:02 AM
  6. [SOLVED] i am not getting any e mails when clicking rec/send how do i re
    By maxysaxy in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 12:15 PM
  7. [SOLVED] Loop through email address list to send e-mails
    By Paul. in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 08:06 AM

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