Search results

The following is the description of the program's email functions: Member data for this organization reside in a table which contains a checkbox that will include that person in the upcoming email when checked. The email form itself contains blanks for sender name, the reply email address...

My cdo routine written several years ago, allowed the user to specify a return email address that could be different from the sending address. Now, that is no longer working in my code--if the two addesses are different, it thinks it sent correctly but never show up in the recipient's inbox...

Thanks so much! Working great now. Not sure why previous code that worked for several years suddenly needed your expertise, but glad to have it. BTW, I did have to make one other change in case someone else runs into this. I had to add Microsoft Office 16.0 object library to my references.

I am using a bit of code that allows user to browse for an address of a file to attach to an email. It works beautifully unless the user cancels the browse operation, after which an error message pops up: "The expression you entered has an invalid reference to the parent property." How to...

It was set at 1.

Doc_Man, I obviously don't have a clue. My program records the response in case of an error so what follows is a list of responses for one of the two rejected emails. after changing recipient to: sEmail & " <" & sEmail & ">" I copied and pasted the error: Email to Judy D Failed: The server...

Isladogs, I have tested using your program. One delivered properly, the other said: Error # -2147220977 The server rejected one or more recipient addresses. The server response was 555 5.5.2 Syntax error: a207sm2377284qkc. 135 -gsmtp

isladogs, I finally have time to get back on this--downloaded your zip and it only has the documentation, not the program. Where might I find it?

Not sure what happened--I posted code several days ago. Anyway, here it is again. I thank you for taking a look at it. As I said, it has worked for several years and only fails on these two legitimate gmail addresses. I just cannot figure out a way to troubleshoot. Private Function...

Ranman256, I have no way to tell where it fails that I know of. All other gmail emails arrive at their destination. I harvest the error message in case of failure as is specified in my first post above.

Thanks for the document. I won't have a chance until tomorrow to study it and post code, etc. but will get back to this then. I need to figure this out! Just note that the cdo routine happily sent 38 emails, the majority of which are gmail addresses. Also, I sent using my email address as...

My cdo code for sending emails has been working error free for several years. Now, a strange problem has arisen. I have a group of 40 people in the membership list, each with a selection box for receiving the next email. I just sent out emails to the entire group via my email form. 38 were...

My client prints invoices on letterhead from tray 1 and office copy from tray 2. I connect remotely. I can't set up print properties on remote system.

When I change the focus line: 'DoCmd.GoToControl "[order subform]" Me.[Orders].[order subform].SetFocus I get error: "Program can't find the field "|1" referred to in your expression." I have no such field in any expression.

When I do that, it says "You can't go to the specified record. You may be at the end of a record set." I assume it is talking about the main form and not the subform. That is why I put the gotorecord new in the on focus event in the subform.

Code from the Order Popup wherein the order number is chosen in a combo: DoCmd.Minimize 'OrderPopup DoCmd.OpenForm "Orders", acNormal, "", "", , acNormal DoCmd.Maximize DoCmd.GoToControl "text0" 'Order number DoCmd.FindRecord Forms!orderpopup!Combo3, acEntire, False, ...

When I do that, it says "You can't go to the specified record. You may be at the end of a record set." I assume it is talking about the main form and not the subform.

When the order# is selected, it opens Orders form to the correct order, then goes to bound Order Sub form properly (which contains the order details). It always goes to the sub form's first record, not new record, even though the sub form's on Open event directs it to. Edit: After I execute a...

Thank you, Doc Man. That all makes sense. What is the best way to handle program updates?