Office 2013 – Outlook email mail merges to include attachmen

[diana]

Apologies I didn't know to create this in the Word or Outlook board.

Is there a way to create an email mail merge and include an attachment eg word document attachment

Users would like this functionality.

It’s not available in Office 2007. The process is very laborious and users have to create each email & manually insert the attachment. 200 emails later this can be tiring.

I’ve checked Office 2013, and it seems not to be available.

Two methods to do the merge
1. In Word use the Mail Merge Wizard, click Mailings, click Start Mail Merge, click Email Messages

2. In Word document, in the Quick Access Toolbar add button Send to Mail Recipient
This is more individual for each document – therefore this isn’t applicable.


http://office.microsoft.com/en-au/word- ... 09788.aspx" onclick="window.open(this.href);return false;


Any suggestions on how best this can be achieved.

See attachments.

TIA, dd

[Rudi]

I am aware of this excellent add-in by Graham Mayor that has the ability to provide mail merge with attachments (and more). If you benefit from it you can choose to donate towards Graham's time and expertise. I am not sure what Graham's policy is towards using this in a business context???? I would recommend that you contact him and find out if you plan to use it in this way.

[diana]

Thank you Rudi

Ill take a look at the add-in and go from there

Many thanks again Rudi, dd

[Rudi]

In addition to the add-in, here is an option to do the task with VBA. See this page: Mail Merge to E-mail with Attachments from the Word MVP's site.

[diana]

Excellent thank you again Rudi.

Ill take a look at the code and the add-in.
Either method - looks like customisation is required.

Thanks again Rudi, dd

[macropod]

Another MS Word MVP, Doug Robbins has a similar addin, available at: http://bit.ly/1hduSCB" onclick="window.open(this.href);return false;

The addin handles:
• 'Many to One' merges
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple

[Rudi]

It looks like the title of this thread is going into attac mode.

[diana]

Thank you Paul

when I click on the url it displays error with 'This page can’t be displayed"

[macropod]

The link works fine for me - I've just clicked on the link in the post and the page opened up as it should. You may have had a connection issue.

[Rudi]

Thank you Paul
when I click on the url it displays error with 'This page can’t be displayed"

Hi Diana,

It's probably a firewall setting on your network. If you are accessing it from a work PC this is most likely.
I cannot access it via my work PC, but when I get home on my wifi, it works fine.
The address points to a Onedrive account.

1.jpg

[diana]

Thanks you Rudi

Yes your right. At work I cant access the urls due to being in the cloud, and work has blocked cloud site.