Mailmerge an Email with an attachment

[Baldeagle]

In my database which is used by a charity I have a button which opens a mailmerge email document in MS Word using the following Visual Basic code -
FollowHyperlink "C:\Our Folders\BWMC\July Donors Email.docx", , True, True
This mailmerge document draws its personal information from a query in my database. And sends off personal emails to a number of donors.

I want to attach a personal document called 'Allocations.docx' which is also a mailmerge document drawing its personal information from the same query. How can I automate the attachment of this document to the email so that each donor gets their own email plus their own attachment?



While I have made good progress with my understanding of MS Access I have little ability with Visual Basic. Can something be added to the existing line of VB which will do what I want? If so, what do I need to add?

Any help would be appreciated.

[June7]

The FollowHyperlink is just opening a Word document. There must be some more code that actually transmits the email. Is there VBA code behind the mailmerge template?

Email is a common topic. Search the forum or google.

[Baldeagle]

When the Word document opens I use 'Finish & Merge' in the 'Mailings' tab to merge the data and send the emails. But how do I get the attachment to automatically attach to each of the emails?

[June7]

I think it's going to be complicated. I googled: VBA Word mailmerge attachment

Here is one http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

I think that code is actually saving the main mailmerge as an attachment to an email. Having a merged document email with another merge document as attachment doesn't look easy, if even possible.

[Baldeagle]

I think you're right!! Perhaps a not very professional solution might be to say in the first email that a second email will follow containing the Allocations form. The second email will simply be the Allocations.docx with the donor's personal details on it.

Can anyone think of a more suitable alternative?

[June7]

I've never done mailmerge but have done email with attachments. It is possible to send an email with multiple attachments, just not sure about mailmerge documents.

Multiple attachments requires repeated adding to the Attachments property to build string of the multiple file paths. For only 2 attachments just do two add statements

.Attachments.Add "path to first document"
.Attachments.Add "path to second document"

Does the Finish & Merge email action actually create an Outlook email with the Word document attached? Or is the Word document converted to the body of the email?

[Baldeagle]

The first Word document (July Donors Email.docx) is sent as the body of an email by MS Outlook - the individual emails all appear in my Sent box. I am wanting the second Word document (Allocations.docx) to be an attachment to those emails (obviously linked to the same donor's personal details).

Maybe I ought to change my focus to the Word forum as I suppose the solution to my problem may come from an expert in Word rather than Access?

[June7]

If the Finish & Merge doesn't offer an attachment option, in particular another merge document, then I suspect the only recourse is VBA email with multiple attachments. A Word document is attachable, it's just the merge document I am not sure of. Might have to save both as PDF and send those as attachments.

Yes, you might have more luck in a Word forum.

[Baldeagle]

Thanks for interacting with me on this. The 'Finish and Merge' allows you to specify if you want the document to go as an attachment or as an email - but there is no option to add an attachment at that stage.

I think I will try the Word forum in the morning.