VBL code for automatic attachment of file into email

niton · #1 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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