Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    Sending An Email With Data From Access - But It Is Several Records For Each Email Add

    I'm trying to see if I can do this myself without having to bother our IT department.

    I have a list of 50 people and they need to get a report for 5 records they are responsible for. So, if I was doing this the old fashioned way, I'd set up a report in access and have it break at each person then print and send 50 reports via snail mail to each person. I would love to be able to use access.

    I tried the Word Merge Function under external data but it is sending one email for each of the 5 records so that ends up in 250 emails sent out and the recipients will get annoyed. I want it all consolidated into one email (5 records per email per email address so that I'm only sending out 50 emails.

    Any ideas? I would greatly appreciate any help and I just have a feeling there might be an easy answer I'm not seeing.


  2. #2
    Join Date
    Aug 2017

    Have you figured this out yet, or do you still need a solution?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts