Active8 months ago
I have an Excel spreadsheet with the grades of my students. Every so often I'd like to email out their current grades, one email per student, that will only include their last three homework grades or so.
Ideally I'd use Thunderbird to email it out but that might be trouble. Mail.app could also work, or Outlook in a pinch.
On a Mac you can do mailing labels, envelopes of lists from the Contacts app. No need to export to a word processor like with MS Office. Simply select a group within your contacts and do the Print command (command p). The dialog box with look like this if you use the 'show details' button. Question: Q: Mail Merge More Less. Apple Footer. Personalizing messages with mail-merge tags You can personalize your email for each recipient by including mail-merge tags. When your message is sent, Direct Mail will merge your email with data from your mailing list, so that each recipient receives a personalized email just for them. First, the answer is YES. Second, Do you want to create physical mail letters or e-mail? Third, I don't know anything about iWork, but in Office 04, you will find it inordinately helpful to click on the assistant and type 'mail merge' as your help search.
I've tried Word's Mail Merge and got all the way to the sixth step but the 'Generate e-mail messages' option there is always greyed out, whatever I seem to be trying.
I'd also be happy with another solution, like using LibreOffice or exporting as text and using some command line tool to email it out but so far I haven't been able to emailing anything via mailx..
C KönigC König
2 Answers
In the end, staying within the Microsoft Office environment is probably the easiest answer. Sorry for not having researched that more thoroughly before asking the question.
'Generate e-mail messages' in the last step was greyed out because Microsoft Outlook was not the default email application. So to make it work:
- (Temporarily) Make MS Outlook the default email application: This is an option within the Mail.app preferences.
- Go through the usual mail merge steps. Note that the email-address does not need to be in the Word message, but I would recommend to have it as a field in the Excel sheet.
- In the last step the 'generate e-mail messages' option should not be greyed out anymore. Select it.
- A small window pops open. Among other options (Subject, for example) the field containing the email address can be chosen here.
- The format can be chosen as 'Text', 'HTML' and 'Attachment'. When sending as text, all me line breaks would disappear, so I ended up sending as HTML, even though I very much prefer 'text'..
- Done.(7. Don't forget to undo your choice of default email app, if you normally use another one.)
C KönigC König
This might help. It worked for me.
G. T.G. T.
You must log in to answer this question.
Not the answer you're looking for? Browse other questions tagged emailms-officemerge .
Hello Apple Community, 🙂
I am desperately trying to find an email solution to email my clients within OS X Yosemite. I have tried a few applications from the AppStore, but I find them mostly problematic and not a real solution.
Intention = Send several hundred emails to several hundred people, all individually addressed with 'Hello FIRSTNAME,' then bla, bla attached is (your monthly newsletter or whatever I want to attach) , with my email signature included.
Over a decade ago I could get this done in with Word and Outlook on Windows 7 and though I find OS X light years ahead on many levels, there is this one feature I find tremendously valuable is unfortunately missing and I have struggled with for years.
PLEASE HELP 🙂
This index powers Goto Definition, which is exposed in three different ways: • A popup is displayed when hovering over a symbol • Pressing F12 when the caret is on a symbol • The Goto Symbol in Project functionality Symbol indexing can be customized on a per-syntax basis via configuration files, allowing users to tailor the feature to their needs. Goto Definition Using information from syntax definitions, Sublime Text automatically generates a project-wide index of every class, method and function. Best coding text editor for mac.
Solutions tried so far:
1. First, I know how to create a mail merge document in Pages from Numbers with the Pages Data Merge app. As you can tell from what I wrote, this is not what I am trying to do.
2. Three AppStore apps, one would stop the entire process if there was a faulty email and I would have to start over, but I would not know at which point in the list to start from, another that would not support attachments and another that would not support text formatting, so my email signature looked like an old typewriter font.
There is one more solution I have not tried and that is MaxBulk Mailer SE. I just don't want to spend another $60 to be disappointed again. So if anyone has used this please let me know the pros and cons.
One last thought, I really think lacking this feature is a complete stupidity. So please, please, please, put this simple feature back, please.
Mac OS X (10.7.1), Preview
Mail Merge For Text Messages Mac Generate Email
Posted on