Results 1 to 4 of 4
  1. #1
    PHIRIM is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2025
    Posts
    1

    Auto generation and sending of payslips to employees in the database

    Dear Forum members,

    I have a database that we are using to generate payroll reports including payslips. So far, we have been printing them. What steps do i need to take to allow for generation of payslips, and at a click of a button, the payslips be sent to employees' email addresses? I thank you in anticipation

  2. #2
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    433
    you print (sendTo) each payslip to a pdf.
    then using Outlook (or CDO) automation to send them.

  3. #3
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,157
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    I thought I was having deja vue there for a moment, as I am sure this exact question has recently been asked?, presumably by another person, as bot this and their crosspost was only posted today?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 0
    Last Post: 05-14-2019, 03:18 PM
  2. Auto number generation with specified format
    By nishant.dhruve in forum Access
    Replies: 2
    Last Post: 03-13-2017, 11:26 AM
  3. Replies: 4
    Last Post: 11-08-2016, 07:49 PM
  4. Replies: 3
    Last Post: 02-05-2013, 06:34 PM
  5. Combining 'sending mail' with 'sending a report'.
    By Mattbro in forum Programming
    Replies: 2
    Last Post: 11-25-2012, 07:42 AM

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