outlook

[Solved] How can I send the same email message to more than 3000 customers [closed]

by

List<Customer> customerList = GetAllCustomers(); string subject = “Hello World”; string content = GetContent(); // Loop through all customers and send e-mail to each foreach(Customer customer in customerList) { MailMessage newMail = new MailMessage(“[email protected]”, customer.Email, subject, content); newMail.IsBodyHtml = true; SmtpClient sender = new SmtpClient(); sender.Send(newMail); } You can move the GetContent() within the loop if … Read more

[Solved] How to copy Outlook mail message into excel using Macros

by

I think this should pretty much do what you want. Sub Extract() On Error Resume Next Set myOlApp = Outlook.Application Set mynamespace = myOlApp.GetNamespace(“mapi”) Set myfolder = myOlApp.ActiveExplorer.CurrentFolder Set xlobj = CreateObject(“excel.application.14”) xlobj.Visible = True xlobj.Workbooks.Add xlobj.Worksheets(“Sheet1”).Name = “Statusmail” ‘Set the header xlobj.Range(“a” & 1).Value = “Absender” xlobj.Range(“a” & 1).Font.Bold = “True” xlobj.Range(“b” & 1).Value … Read more