Launch up Word and under Mailings, select the type to be Letters. Save the Excel file some place where you can find it easily later. Make sure your Excel worksheet has at least an email column and another column (e.g., First Name).
System/Library/Frameworks/amework/Versions/A/Frameworks/amework/Versions/A/Support/lsregister -kill -r -all local,system,user (Don't run it prefaced with sudo-just run it as is). If you find that Mail keeps reverting the default email client to be Mail instead of Outlook, you may have to run this command: Under Default email reader, select Microsoft Outlook.app. Unfortunately, Apple has made it so you can't select the preferences until you have set up at least one account, so you may have to set up your email account in Mail as well, even though we won't be using it. Now, launch up /Applications/Mail.app and go to Mail and select Preferences. This step isn't necessary, but I highly recommend it, because it gives you a chance to spotcheck the merged emails before they go out. Then click on Outlook and select Work Offline. Since we're using a Gmail account as an example, you would click Other Email.Įnter the appropriate information, and then click Add Account. Launch up Outlook and select Outlook > Preferences.Īdd whatever account you plan on emailing from. Under Forwarding and POP/IMAP, make sure Enable IMAP is selected (you may have to scroll down a bit to see the option).įor some reason, Google doesn't consider Outlook to be secure, so in order to access Google from Outlook, you'll have to go to /settings/security/lesssecureapps and select Turn on. So, with Gmail as an example, go to Settings. I'm using Gmail as an example, but you can do an email merge with any kind of email account, as long as it can be put into Outlook (Exchange, POP, IMAP, etc.).Īlso, please be mindful, since you don't really have an unsubscribe button in Outlook email merges, that you should still be complying with the CAN-SPAM Act guide.
FOR MAC WORD 2017 HOW TO
This blog post is really about how to do an email merge using Microsoft Office on a Mac, so here are the steps and considerations.
Microsoft Office (Excel, Word, Outlook) Email Merge
FOR MAC WORD 2017 MAC OS X
This Apple support communities discussion has some interesting other workarounds in Mac OS X for doing an email merge, including using the Mail Merge add-on for Thunderbird. If you don't mind the developers having access to your Google information, then you may want to explore these options: There are also some third-party add-on solutions. Here are some examples of those SaaS solutions: If you're an organization doing a lot of targeted mailings and campaigns, you may want to consider uploading your email lists to an online service that will track campaigns and templates for you as well as give your users an easy way to unsubscribe.
0 kommentar(er)
