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.
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.