I've been following Macropod's excellent tutorial on how to send a catalogue/directory mail merge via email. I've got most of the way, but have hit a couple of stumbling blocks:
1. The heading "Recipient" at the top of the EmailDataSource table keeps deleting itself. Without this heading the sending via email won't work as it gets as far as the last ".Execute" and falls over as it doesn't know where to find the email addresses. I stepped through the code and the heading gets created, but then deleted by the following ".Paragraphs(1).Range.Delete" line. Commenting this line out did fix it, but I wasn't sure if that was contributing to my other issue...
2. The EmailDataSource table isn't merging all of the cells properly. Most of it is ok, but as you can see from the attachment, it isn't merging all the rows for a single vendor (i.e. everything that needs to be sent to that same email address). I've tried to have a look at what's causing it, but I'm afraid I can't get my head round that bit.
Any help gratefully received!
Many thanks
Bookmarks