Hi everyone,



Has anybody had any experience with using the last macro in Macropod's catalogue mailmerge tutorial running on Mac OS Sonoma or later and Word Version 16.97.2?

I have successfully worked through the whole tutorial on my machine, but the final macro stops at:

" .SaveAs FileName:=StrDoc, AddToRecentFiles:=False, FileFormat:=wdFormatDocument"

Ending the process at that point, leaves a "catalogue" file with table rows not yet joined but sorted into groups, and not yet split into their respective documents.

After resetting word and redownloading the mailmerge tutorial files to start from scratch many times, trying different file formats (doc. docm.) I am beginning to think it may be my machine that's not compatible with this final macro.

I should mention that I am completely new to using mailmerge, not to mention VBA.

Any assistance with this would be greatly appreciated. This final mail merge macro would make my style of invoicing so much easier.

Josh

That code is written for PCs. I don't know how well it would work on a Mac. In any event, the DATABASE field approach discussed on the Microsoft Word Catalogue/Directory Mailmerge Tutorial page (https://www.msofficeforums.com/mail-...-tutorial.html) would seem to be a better approach. It works with emails and, provided your data source is set up appropriately, doesn't need a macro to tabulate the data. The only thing it doesn't do 'out of the box' is tally the columns, but a macro could be used to deal with that.

For some more DATABASE field examples, see:
MS Answers : Mail Merge - To a Word Table on a Single Page
MS Answers : Many to one email merge using tables

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thanks for clarifying that.
It seems the database approach also doesn't work on Mac. I suppose any code with file paths or filenames won't run on mac.
I'm going to try to install a virtualizer on my Mac to run windows. Thinking of FusionVM because it's free but I'm having registration issues. Once that's sorted I'll give those mailmerge macros another go.

Josh

AFAIK DATABASE fields do work on Macs. As do macros with file paths & names; the 'gotcha' is that you need to have the right syntax. For example, the folder separator on a Mac is ':' rather than '\'. Fields with file paths & names don't require such things to be taken into consideration. The solution with the macro you're having trouble with may be as simple as changing:
"\EmailDataSource.doc"
to:
":EmailDataSource.doc"

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]