Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
'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
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!