Mail merge with attachment on Macbook using Word + Excel + Outlook 2016

Question

I use Mail merge on my Macbook using Word + Excel + Outlook 2016. However I can't understand how to send emails with attachment using the mail merge feature. 

I have seen clarification tutorials on how to send the attachments in outlook 2011 version using C:\location\filenmane.xls to be mentioned against each mail merge contact, but even thats not very easy to define in macbook, its not easy to define the file location in macbook as we can define in conventional windows platform.

I am aware that it can be done through mozilla thunderbird add-on, but I don't want to download and add more complexity, as my Mac runs on 128 GB space and always remain tight on space..

Answer 1

Doug,

I had a look at doing something like this a couple of years ago. There are a number of things on Windows that are either at least different or significantly harder on Mac so there are potentially a lot of new problems to solve. I haven't looked at your code but for example

 a. there is no reliable documentation for Mac Office VBA or Mac Office Applescript. Many things are the same, some things are missing or different, and some things look the same but are different or behave differently.

 b. it is not even possible to look at the Word object documentation via the Mac Word 2016 VBA editor, because that option does not exist. So although so far I have found that using the equivalent feature in Mac Word 2011 gives the right informaiton, only experiment can verify that new features have not been added and that behaviour remains the same.

 c. you can only really control Mac Outlook via Applescript or by using a Javascript Addin (as mentioned by Jim Gordon).

 d. Even doing a one-merge-at-a-time mailmerge has to be done differently because the object model on Mac Word is like an older version of the Windows one

 e. AFAIK the only reasonably simple way to access Excel data is via the object model (there is no ADO, DAO, OLE DB and using ODBC requires a commercial third-party add-on). IME controlling Excel reliably via Automation is not as easy on Mac.

I'm not saying it can't be done. What I'm saying is that there's a lot to discover, deal with, and make robust. And then there's the support...

But having a bunch of VBA code as a starting point would certainly make a huge difference, and I would certainly be willing to have a crack at a re-working if you are willing to share the code.

Answer 2

More about AppleScript.

The VB MacScript command changed beginning in Mac Office 2016 version 15.33 (build 170331 and later). This will affect all macros that rely on MacScript in Office 2016.

A macro that invokes MacScript will encounter a runtime error #5 ("invalid procedure call or argument").

To avoid this runtime error, enable MacScript with the following command in the Terminal:

defaults write com.microsoft.office AllowVisualBasicToRunMacScript -bool YES

Answer 3

Thanks, Jim. A rather important piece of information!

Answer 4

Does this mean that it's not possible to add an attachment currently in mail merge using Outlook on a Mac?

Did someone find the answer?

Thanks!

Answer 5

> Did someone find the answer?

The short answer is probably "no".

But it would probably be simpler if you can spell out exactly what you want to do.

e.g. you have a form letter, and you want a personalised version of that to go to a list of recipients, but you also want to attach

 - the same file for every recipient?

 - a different file for each recipient?

 - or what?