We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
'we are in a loop which produces single email addresses as the var xx Set objOutlook = CreateObject("Outlook.Application") Set objOutlookMsg = objOutlook.CreateItem(olMailItem) With objOutlookMsg Set objOutlookRecip = Nothing ' clear previous recipient from loop Set objOutlookRecip = .Recipients.Add(xx) objOutlookRecip.Type = olTo .Subject = Me!subj '<--Subject .HTMLBODY = "<HTML><H2><b>This is HTML Text in the BODY of the email</b></H2></HTML>" .HTMLBody = "<HTML><Head></Head><Body><table><tr><td>" & hdrtbl & "</td><tr><td><hr>" & Me!msgtxt & "</td></tr><tr><td><small>" & signath & "</small></td></tr></table></Body></HTML>" xxx = "Email address ERROR for " & xx MsgBox xxx End If Next .Send End With 'Cleanup Code Set objOutlookMsg = Nothing Set objOutlook = Nothing Set objOutlookRecip = Nothing Set objOutlookAttach = Nothing Me!Text14 = xx & " " & zz 'go to next email address in loop
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How display file name that two linked table reside in on a form||4||28|
|Dll Created For Access App cannot locate web services configuration info in App.config file||19||27|
|Access Report formatting issue||5||22|