This is an extension for Microsoft Outlook which allows mass mailing to be done based on data in an XML file.
This is useful particularly for handling mass mailing of custom attachments. It can also handle adding Oultook signatures to messages when creating the emails.
- Open the visual basic editor (Outlook, Alt-F11)
- Import the .bas and .frm files
- Add references to ** "Microsoft XML, v6.0" ** "Microsoft Office x.0 Object library" ** "Microsoft Word x.0 Object library"
- Save
- Then run the macro "makeToolbar"
XML files look like something like this...
<root>
<row>
<to>somebody@company.com</to>
<cc>somebody@company.com</cc>
<bcc>somebody@company.com</bcc>
<subject>somebody@company.com</subject>
<body>Some plain text here</body>
</row>
<row>
<to>somebody@company.com</to>
<cc>somebody@company.com</cc>
<bcc>somebody@company.com</bcc>
<subject>Test message with HTML body and attachments.</subject>
<htmlbody><p>Some text here in <b>HTML</b></p></htmlbody>
<attachment>C:\temp\somefile.txt</attachment>
<attachment>C:\temp\anotherfile.txt</attachment>
</row>
</root>htmlbody can be included escaped or unescaped: generally unescaped is easier, though XML conventions would need to be followed (closing brackets etc).