Thanks Macropod
I have set the reference From within ms word to the ms outlook object library and created a macro based on the code provided.
I also created a two column table in word and filled it with data from my data source(excel) and sent it to a directory type document using the mail merge function. I saved this doc.
I went back to my original mail merge doc that I want to email, used the same data source and pulled in the fields i needed merged.
I ran the macro from within this mail merge doc and was able to select the doc with my table that contained the email and attachment from the data source. It runs but says " 0 messages sent"
Am I on the right track? Any suggestions? Thanks so much for your help!
|