Recent content by pld60

arnelgp, thanks that works great!!!!

I have a command button on an excel spreadsheet to open a word document with this code. Private Sub CommandButton1_Click() Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True objWord.Documents.Open "H:\Spreadsheets\400 Book\400...

Is this not a solvable problem or did I place it in the wrong group?

In an on click Event to send emails from a form I have to following line of code as part of code that sends an email. .ReplyRecipients.Add "email@gmail.com"This is for the recipient to reply to a different email than the one it was sent from. This works great if sent to an email address. Does...

Thanks Bob that worked perfectly:D

Have a form that is only for viewing records. When opened the first text box is selected and then very difficult to read. I could change the tab order, but I don't want any selected. Is there a way to do this?

Gasman, I think my problem is with the exchange server. I am working with IT to help me out with this, but the guy I'm dealing with does not seem to know. I will post when I have a solution.

I have a table with the following fields, ID (primaryKey) Date_Created Date_of_Event Time_of_Event Number_Staff_Needed Staff1 Staff2 Staff3 that keeps track of events that 1 to 3 staff may be involved in. My question is does this violate the 1st normal rule of no repeating groups. If it...

RogerH and Gasman, Thank you so much for your help, I have it working. With this Private Sub Command42_Click() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim strbody As String Dim objMyTable As Object Dim strEmailAdds As String Set OutApp =...

RogerH, I think we are very very close. When I run this I get a Run-time error 3021 No Current Record, and it shows the error at strEmailAdds = strEmailAdds & "; " & objMyTable.email When I hover over strEmailAdds it shows all of the email addresses from my field with ; between them...

I think a string, BCC

RogerH, Yes it is the same message to everyone in the table.

Still only sends the first record and then the same error.

Rogerh, Thank you I seem to be making progress. When I placed your code and entered my table and field name I got a compile error. Invalid or unqualified reference at the .Send line I made some changes to: Private Sub Command42_Click() Dim OutApp As Outlook.Application Dim OutMail As...

I have this code to send an email on a click event of a command button on a form. Need it to get the email from the Field email on the Table EmailTest. Private Sub Command42_Click() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Dim strbody As String Dim MyDB As...