Recent content by dsk96m

It sends the email, but none of my recipients get it. i get the system admin email response This message could not be sent. Try sending the message again later, or contact your network administrator. Error is [0x80070057-00000000-00000000].

I did, everything up to adding the recipients works, but setting the recipients is failing

That didnt work. Here is my code. Dim cnn As Database Dim Dist_list As Recordset Dim qdQry As QueryDef Dim Email_Msg As String Dim Addr As String Dim objoutlook As Object Dim objOutlookRecip As Object Dim objOutlookAttach As Object Set objoutlook =...

So i have this: Dim objoutlook As Object Dim objOutlookRecip As Outlook.Recipient Dim objOutlookAttach As Outlook.Attachment Dim Addr As String 'create Outlook sesion Set objoutlook = CreateObject("Outlook.Application") It is failing on the bold lines, what do i...

Thank you, will give that a try. That is how I had it, but I had the reference selected, so I unselected them. Will see what happens.

So i have an access database that uses outlook/excel/etc. I developed it in access 2007. So I selected the 12.0 version of the object libraries (ie Microsoft Excel 12.0 Object Library). Since then some have upgraded to Office 2010. So there is a mix of people using access that have either...

I have a form that the user enters some info into. The textbox i have set as rich text. The table has the value set as rich text. When I export it to an excel presentation, it has all the formatting code. <ul> <li>, <div>, etc. Can anyone help me with export rich text or copying rich text...