Search results

Thank you, I have to paste a query result in the message body. I can do that in the send object method, but I wish to format the message body with colors and font sizes. Your answer helps me to format the mail body, but I can not paste the query in the message body with this html - because it...

Can I use html to format the message body in send object method ? If I can, please let me know how to do that. Thanks for your help.

With the below function, I am able to paste the query in the email body without any issue, but I need to add column heads and gridlines around the query result, they are missing. Please help. Thank you. Public Function SubmitInternal() As Boolean Dim DbsLCA As DAO.Database Dim RSTLca As...

Hi GinaWhipp, The mails goes from the command button click event. "To" is static email id, does not change. The "Subject" is user's first name and last name ( capturing from Text Boxes - txtFirstName and txtLastName), message body is captured from txtMessage textbox. In every repeated...

Is there a way to save the emails sent with docmd.sendobject method? I wish to save the Date Sent, To, Subject and the message body in a table (tblEmail) in the fields DateSent, To, Subject and MessageBody. Thanks for your help.

I am designing an unbound form (Form1) with a text box for the emails (recipients), a text box for subject and a text box for message text. I need to fill the text box with emails from another text box which is in form ( form 2 ) which are bound with a table which has two fields. Email Ids...

Please help me. I am building a form where user can send emails from the form. I have bound eTextbox (Textbox) with email ids (around 40 email ids) and bound check box (ChkEmailSelect) to select the email id in frmEmailSelect. It is a continuous form. I wish to add the check marked emails in...

Thank you very much. It works.

I tried this above link with docmd.sendobject method. It fetches only the last email id in from the recordset. Please let me know where I am missing. Thank you Private Sub CmdEmail_Click() On Local Error GoTo Some_Err Dim MyDB As Database, RS As Recordset Dim strBody As...

Thank you, I will try step by step.

1. This is highlighted: cn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=C:\Users\Philip.Daniel\Documents\Benefits.accdb" 2. Yes, I am able to open the database directly 3. I copied the database into My Documents and also to the desktop and tried to avoid the directly...

Thank you. Somehow I got the space while pasting the code. I tried again - making sure there is no space, but getting the same error. Thanks for helping.

Please let me know what is wrong in this; I am getting the error " Unrecognized Database Format Error. Thanks for your help. Sub ShowUserConnected() Dim cn As New ADODB.Connection Dim cn2 As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long...

Normally I open the form with record source as query with all the fields - with a where condition query which retrieves no records from the table ( example: WHERE [CUSTOMERNAME]="YUGJHG") - May be I am wrong!

Thank you, it runs the code, if this code is to run only once a day, what should be the time interval. Thank you,

No, it did not run the code. I am not sure why. Thanks again.

I set timer interval to 10000 Thanks

Yes the form is open. The time interval is everyday at 5 PM.

This is what I tried: Private Sub Form_Timer() If Hour(Now()) = 12 Then Call Daily_Activities_Snapshot End If End Sub But when I call this function from a command button, it works well.

Thank you, I tried. Doesn't work. Can you please let me know how you would do. Sorry for the trouble.