distribution list

Hello, I do found a VB formula in order to extract a set of email addresses from Excel to an Outlook email draft, so email drafting will be way easier especially if we maintain a lot of distribution lists for different email communications. My problem is I want to implement this to a...

Hello, I am trying to send an attachment to 60 people. I have the 60 names on a tab named Email List to be updated as needed. When adding names to the to field I obtained the error message "To many line continuations". Is it possible to correct the below to send to all 60 email addresses? Sub...

Hello All, I have been a MR.Excel fan for a quite long time and many tricks have helped me a lot. Now i need something little bigger. I know the ask is big but am sure you all would be able to assist me. I am trying to send a pdf attachment to a distribution list using a pre-defined template...

Hi, I’m looking for a way to query a specific Outlook distribution list from Excel to see if a member of staff is included on it or not. I’ve searched quite extensively for a solution and I’ve found plenty of examples of how to extract all the members of a DL, or how to add people to a DL etc...

I stumbled across Ron Debruin's site Sending mail from Excel with CDO and was able to get an email to send in gmail finally (had to change port to 465 and then change my gmail settings) but he also had a couple of other things to try - - - Download Example workbook...

Good day all from a sunny South Africa I have a VBA code that work fine 99% It creates an email Add an attachment Personalise the email Have a distribution list Use a default body created in advance Can set a time delay between emails etc. The only problem The first email adds the attachment...