I have already modified the Mailings ribbon in my own Add-In. I also appreciate your link to the icons worksheet. So the Add-in can be left on all the time and won't get in the way of anything else. This has no such restrictions and works exactly like and ordinary Mail-Merge. I have seen other ways of doing it, but I found I could not send HTML formatted E-mails that way. That, in essence, is the gist of it - sneaky, but it works. Turn Outlook ON-line so that the E-mails can be sent.Read through the waiting EmailItems in the Outbox and add to Attachments from the temporary Windows Folder.Complete a normal Merge to Email, so Word will generate the E-mails and send them to Outlook's Outbox, where they will wait - because it's still Off-line.Delete the Outlook MailItem from the Outbox, as we don't want to send it anyway.Read through the Outlook MailItem and copy the Attachments to a temporary Windows Folder.(This creates it as an Outlook MailItem in Outlook's Outbox.) Send a copy of the E-mail without doing a Mail-Merge.Turn Outlook OFF-line, so it won't send E-mails.Check there is nothing in Outlook's Outbox.So to be able to add those Attachments to every E-mail in the Merge I have to: MailItem, but not from the Word MailEnvelope. But oh dear me no - nothing as simple as that! After a lot of research I discovered that I could do it from an Outlook I assumed that having added Attachments into the 'E-mail Header', I would be able to obtain their Pathnames in a Word Macro. The bit that made it hard was my insistence that I wanted to make the User Interface as familiar as possible. It proved to be quite a steep learning curve, as I've never messed around with an Office Ribbon before. I will password protect it so that it can't be modified and passed on with our name on it. I'm not sure that I will make my code available however. When done I will be making it available as a FREE Word Add-in that anybody can use. The Icons I needed were right there and had such obvious names that I kicked myself for not guessing them. THis is VERY much better than the Microsoft Office2007IconsGallery, in that you can search on keywords like "MailMerge". In searching for a solution I found that I downloaded from So I did not know what imageMso names to use and thought I would not be able The images that I wanted were not in the Office2007IconsGallery.xlsm that I downloaded from Microsoft. Solving the image problem, turned out to be much easier than I thought. Whilst there it adds the Attachments, before turning OUTLOOK back on-line, so that the E-mails can go. Merge to E-mail, PLUS turns OUTLOOK off-line, completes the Merge so that the E-mails sit in the Outbox. It's only the last two menu options that do anything different. Īs you can see the interface is as similar as possible so that it does not get in the way of normal Mail-Merges. I've also edited one of the Supertips to prove I was editing theĪny other ideas, anyone? Anyway here's the XML involved. I've also checked that my STARTUP Folder is in the right location. The third item - but it's still there! I've checked, I don't have any Add-ins loaded in my STARTUP Folder. However I realised that the 3rd item is redundant, for if there are no Attachments the firth item does the save job anyway. Originally I thought I'd need both the third and fifth items on the drop down menu shown. I have developed a customised Word Ribbon and associated macros to enable users to perform - Merge-to-Email with Attachments as shown below:
0 Comments
Leave a Reply. |