VBL code for automatic attachment of file into email

DrLoveday1 · #1 04-12-2013, 04:23 AM

Hello,

Does anyone know some simple VBL code so that the macro i am using to generate a standard email will automatically attach a file to the email.

Any advice would be much appreciated.

niton · #2 04-12-2013, 05:36 AM

Try this http://msdn.microsoft.com/en-us/libr.../ff869553.aspx

Code:

Sub AddAttachment() 
 Dim myItem As Outlook.MailItem 
 Dim myAttachments As Outlook.Attachments 
 
 Set myItem = Application.CreateItem(olMailItem) 
 Set myAttachments = myItem.Attachments 
 myAttachments.Add "C:\Test.doc", olByValue, 1, "Test" 
 myItem.Display 
End Sub

*******************
Consider rating the thread by going to the "Rate Thread" dropdown.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to add attachment to email merge	Claytocb	Mail Merge	5	09-12-2012 06:02 PM
I need help with macro...code needed for automatic sorting	chefmate	Excel Programming	1	08-26-2012 01:04 AM
Email with Excel attachment	Renee	Outlook	0	02-01-2012 12:07 PM
Automatic reply with variable attachment	subby80	Outlook	0	10-20-2011 06:59 AM
email as pdf attachment - subject line and attachment named after mail merge	Nexus	Mail Merge	12	04-13-2011 11:34 PM