Email PDF to multiple contacts.

  Jen4 16:59 12 Jan 2018
Locked

I hope some one out there can help me. Part of my job is to send out a newsletter once a month. I have just been told this needs to be in PDF format, and the email addresses are all in SAGE, but transition email is not set up. I have managed to extract the email addresses (all 600 odd of them) in to excel, and therefore word. But then I'm stumped. Mail merge doesn't appear to much use as it would take forever to fill in the details for the contact list, which will change as customers change every month. Oh and I am unable to cc people as the details need to be kept confidential. Please please please can someone help me figure out how to do this with out having to copy and past in each email address one at a time, attach the PDF and send it as this would take me forever. I'm off home for the weekend now but hopefully when I get back on Monday morning someone will have came up with a way to do this, if not I may need to go tell my Boss its impossible, something I do not relish having to do.

TIA

  Jen4 11:11 22 Jan 2018

Thanks for your help. I ended up having to spend ages creating a contact list. But now I can use the Bcc thingy to send one email to everyone.

  Forum Editor 15:02 22 Jan 2018

There are some neat little 3rd party applications that enable you to send individual emails with an attachment to everyone on a list.

Here's one, picked at random.

  Forum Editor 18:11 22 Jan 2018

octal

I know the feeling.

  alanrwood 18:48 22 Jan 2018

Copy all the email addresses as a csv file. Open an email and send it to yourself. Open the Bcc option and cutand paste the contents of the csv file into it. Add whatever text you wish to the email then add the pdf as an attachment. Send.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Book 2: Release date, price and specs

This First Man soundtrack vinyl cover art is exquisitely composed

How to watch Apple’s October 2018 iPad launch

Meilleurs VPN (2018)