Hands-on: Samsung Galaxy S8 review
I have a database of Society Members and I want to e-mail merge a letter and attach two files to the e-mail. I don`t have a problem sending just the message but I can`t seem to fathom out how I automatically attach a couple of additional Word documents.
Word 2003 and Outlook 2003
That looks good. I`ll try that out whilst I`m on the train later and let you know. Thanks.
I struggled with this over the weekend. Although I have set up the Catalogue (Directory) I have struggled with saving the macro. I copied the macro from the link and pasted it into my macros in Word however it won`t run properly and goes into debugging. Does that macro need some form of editing? Here`s what Ive got:
VBA is a total mystery to me, Taff36, I'm sure someone will be along shortly that knows more about it. :-(
Me Too! Thanks for the link anyway.
There's a lot of spaces missing in that code - maybe a result of the formatting on this site. For example
Dim Source As Document
In the Visual Basic Editor, Tools|References and make sure Microsoft Outlook <version> Object Library is ticked.
Thanks VoG. I`ve checked my macro which I copied and pasted from Maj`s first link. It too is missing the spaces so the formatting needs checking against the original.
Object Library is ticked OK. Will let you know how I get on.
Never quite got to grips with this one. In the end I e-mail merged from Outlook using Word as my editor. I had to define the worksheet fields and created a seperate address book for the members with just their names and e-mail addresses. Then I set up three distribution lists within the address book each with about 100 names in it - my ISP limits the number of recipients to 200 but with 4 attachments I thought I`d play safe. I then simply wrote the newsletter in Word, copied it to the e-mail, attached 4 files and sent it to the three distribution lists.
This thread is now locked and can not be replied to.