Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
'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.
Join the community of 500,000 technology professionals and ask your questions.