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
Office 2013 – Outlook email mail merges to include attachmen
-
- 3StarLounger
- Posts: 279
- Joined: 01 Jun 2010, 00:27
Office 2013 – Outlook email mail merges to include attachmen
You do not have the required permissions to view the files attached to this post.
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Office 2013 – Outlook email mail merges to include attac
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.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 279
- Joined: 01 Jun 2010, 00:27
Re: Office 2013 – Outlook email mail merges to include attac
Thank you Rudi
Ill take a look at the add-in and go from there
Many thanks again Rudi, dd
Ill take a look at the add-in and go from there
Many thanks again Rudi, dd
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Office 2013 – Outlook email mail merges to include attac
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.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 279
- Joined: 01 Jun 2010, 00:27
Re: Office 2013 – Outlook email mail merges to include attac
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
Ill take a look at the code and the add-in.
Either method - looks like customisation is required.
Thanks again Rudi, dd
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Office 2013 – Outlook email mail merges to include attac
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
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
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Office 2013 – Outlook email mail merges to include attac
It looks like the title of this thread is going into attac mode.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 279
- Joined: 01 Jun 2010, 00:27
Re: Office 2013 – Outlook email mail merges to include attac
Thank you Paul
when I click on the url it displays error with 'This page can’t be displayed"
when I click on the url it displays error with 'This page can’t be displayed"
-
- 4StarLounger
- Posts: 508
- Joined: 17 Dec 2010, 03:14
Re: Office 2013 – Outlook email mail merges to include attac
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.
Paul Edstein
[Fmr MS MVP - Word]
[Fmr MS MVP - Word]
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Office 2013 – Outlook email mail merges to include attac
Hi Diana,diana wrote:Thank you Paul
when I click on the url it displays error with 'This page can’t be displayed"
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.
You do not have the required permissions to view the files attached to this post.
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 3StarLounger
- Posts: 279
- Joined: 01 Jun 2010, 00:27
Re: Office 2013 – Outlook email mail merges to include attac
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.
Yes your right. At work I cant access the urls due to being in the cloud, and work has blocked cloud site.