For a mac be prepared to spend a lot more than a windows computer with the same specs or windows even having the better specs of the two. PC vs Mac – Power and Price If you are using adobe creative suite or any adobe products, they are the same product on a windows or an apple computer. It is not the same battle that it once was. I honestly hate to see anyone waste money, especially when they don’t know the difference between windows and mac in 2015.
When converting a Word document from an Excel data source to mailing labels, you must re-name your Excel file to the document name and the appendage '.xls' and NOT.xlsx!! This took me a frustrating afternoon to figure out that on a Macintosh Powerbook G4 run on Mac OS X 10.4.11 my Excel workbook will not convert to labels readily unless I renamed the extension.xls.
After this, when I opened the Word and Mail Merge and go to Open Data Source, it will read with the.xls! My Word is Microsoft Word 2008 for Mac version 12.2.3.
I'm trying to send a mail merge from multiple people. I was wondering if there was a way to choose the sender address based on the recipient email address? I'm using an Excel file as the source of the merge and the sender names associated with the recipients in the excel file so I can add a field after the closing line in the document to have the senders name appear.
No, Outlook can’t do this, at least not as a native feature within the mail merge. Mail merges will always be sent from the default email account. However, it is possible if you use a macro to handle the merge, not the mail merge wizard. This macro reads values from an Excel worksheet and sends a mail merge, replacing unique values in the Outlook template with values in the worksheet. It also sends the message From an address in the worksheet. Create an Outlook template, entering unique values where the merge fields would be entered.
Microsoft Office for Mac 2011 tutorial: Use Mail Merge to create a form letter 15 Hints • To complete the mail merge to Outlook e-mail messages, click Generate e-mail messages. This macro reads values from an Excel worksheet and sends a mail merge, replacing unique values in the Outlook template with values in the worksheet. It also sends the message From an address in the worksheet.
While you could use standard merge fields or bookmarks, you would need to use the Word Object Library to update the fields. Using unique values allows us to use VBA's Replace function. The finished merge will look like the following.
This might be easier to do with a mailmerge. If you use that, Word would allow you to insert fields for the data you want to export. You could do that, then select/filter the record(s) you're interested in and finish the merge. Do note that mailmerge is much less functional on Macs than it is on PCs.
The Mac mailmerge converter doesn’t let you specify anything other than one of the suggested names ('Entire Workbook' or a sheet name), despite the fact that you can type into the combo box – you can’t specify a named range, for example. Typing a range name greys out the OK button.
Only typing a range in An:Bn or RnCn:RnCn formats works. Other problems can occur if Mail merge field names are too long. Set font to default in microsoft word 2016 for mac.
Mail merge field names are limited to 40 characters. Anything longer than this gets truncated and can result in error messages and data not being merged when the merge is executed. The alternative is to use a macro to automate Word (if you're running it from Excel), create a document from your template, then populate a series of bookmarks, docvariables or document properties in the document. This might be easier to do with a mailmerge.
If you use that, Word would allow you to insert fields for the data you want to export. You could do that, then select/filter the record(s) you're interested in and finish the merge. Do note that mailmerge is much less functional on Macs than it is on PCs. The Mac mailmerge converter doesn’t let you specify anything other than one of the suggested names ('Entire Workbook' or a sheet name), despite the fact that you can type into the combo box – you can’t specify a named range, for example. Typing a range name greys out the OK button. Only typing a range in An:Bn or RnCn:RnCn formats works. Other problems can occur if Mail merge field names are too long.
Mail merge field names are limited to 40 characters. Anything longer than this gets truncated and can result in error messages and data not being merged when the merge is executed.
The alternative is to use a macro to automate Word (if you're running it from Excel), create a document from your template, then populate a series of bookmarks, docvariables or document properties in the document.