Search results for query: send email

Hi All, Iam trying to work out an weird issues with sending emails. I've written a process which send attachements via email, this process runs find if it ran manually. However, If i setup an automated scheduler ( to run this msaccess at X time). the email section of the program is blocked from...

Hi, iam using the below code to send Monthly salary slips to employees, and it working fine but having 2 issues 1. if the employee email in null, its stopping every thing ( need to edit to ignore if email not avaliable or at least if i closed the outlook email it will continues) 2. added a...

While clicking on button "Email Salary Slip" as attached in *.mdb file we are getting the following error (Snapshot attached) Description: The System cannot find the file specified.; Error Number:-2147025894; Source :CDO.Message.1 Unable to send Salary Slip Email in PDF format with password...

...setting from 465 to 587 , but it is not working. Please suggest the VBA code to change the SSL Setting. or Please correct the code to send email. Sub SendMail() Dim objEmail Dim objMail As Object Const cdoSendUsingPort = 2 ' Send the message using SMTP Const cdoBasicAuth =...

...need to store the values as they are not going to be needed later. Will I have to generate a report first? Ideally I would like to.. 1- have user complete the form 2-press "send email" 3-List the form controls as text in an email, one after the other. 4-not save any of the data Is this feasible?

I have been using sendobject code for many years to send invoice copies through my email client which until last Friday was Windows Live Mail. The issue I am having is that I now want Outlook to send my reports. I have changed the default email app, but WLM is still opening when I run that code...

Hi, I have been using VBA to send an email for several years now. The email is generated from a form where payments are inserted for property lots. Things have changed and I now need to include in the email information how much the payment was for each lot. For instance, owner ID number 21 owns...

How can I eliminate the Microsoft Outlook email safety message when sending an email using "SendObject" ? Attached is the image of the message.

...individual payslip to employee around 900 a month . But challenge is, can we do it without ms outlook. I want Access should directly use SMTP and send email without using outlook. I have folder where all payslip are stored. Payslip names are on the Employee Code. Expert help is appreciated.

Good morning all, I'm battling with some code that takes a report and sends it out to a client, with a filename built from the [Customer ID] and

I have a button that exports a PDF to Outlook. Everything on that end runs perfectly. However, if I choose not to send that email, my database locks up. This is happening on the front end which is locked down. Is there a code that I should put in to stop the macro error due to not sending...

Your email server appears to be the bottleneck then. What anti-virus software is running? Are there rules about acceptable content in your organization's email? The fact remains that Access is sending out the emails, does it not? And that means looking outside Access for possible problems.

I posted this because just the other day I discovered that in Germany, it is very common to send faxes instead of emails. https://www.androidpolice.com/send-fax-from-gmail/

If it processed 1 then it processed the first and the last. Send yourself three emails. Open the code and step through it as each email is processed so you find the problem.

Hi, Hoping someone can help. I have the following code in my database which, when a payment is authorised, will send an automatic email to our finance team to say the payment needs to be made and will also attach the bank statement from a file directory. However, if the file doesn't exist/is...

From a quick Google https://www.access-programmers.co.uk/forums/threads/outlook-security-warning-bypass-when-sending-emails-from-vba-code.305782/ Is this the case with you?

...so simple! All you do is send an email to text magic and then it forwards the email as an SMS. Extract from the text magic website:- Send Email to SMS Mobile marketing (for product promotion) is a very powerful tool for your business – and this is where sending SMS messages using email...

Hi, 1. I have entered the below VBA code in excel, which creates PDF files (i.e., employees payslips from excel sheet) in a folder based on the datalist in the range. Sub Iterate_Through_data_Validation() Dim xRg As Range Dim xCell As Range Dim xRgVList As Range Set xRg =...

Hello Everyone, Is there any way to send an email by vb script when Excel file gets unprotected? If there is, can you provide me the code as well? I need this for one of my review courses. Thanks in advance for your suggestions. Best Regards.

1. Exclude records from recordset that don't have email: WHERE email IS NOT NULL 2. Why? This is a DELETE query? Why remove records? Why remove if any issues happened? 3. What do you mean by "confirm" - a MsgBox to accept/cancel or save data into table that send was successful?