Macro

verluc · Apr 24th, 2002, 11:49 AM

I have a sheetA with following macro:
For Each rngeCell In rngeAddresses.Cells
Set olMail = olApp.CreateItem(olMailItem)
olMail.To = rngeCell.Value
olMail.Subject = "Message ! ! ! "
olMail.Body = "Message ! ! ! "
olMail.Send
Next
Can somebody help me with the following:

I need to add a code in this macro who makes an attachment from another workbook.
Is this possible?
Many thanks for help.

Jack in the UK · Apr 24th, 2002, 11:57 AM

very common question email via vba, very well deatiled, use search this will put you there or near abouts.

HTH

Apr 24th, 2002, 11:57 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	very common question email via vba, very well deatiled, use search this will put you there or near abouts. HTH __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

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

Apr 24th, 2002, 11:49 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,288	I have a sheetA with following macro: For Each rngeCell In rngeAddresses.Cells Set olMail = olApp.CreateItem(olMailItem) olMail.To = rngeCell.Value olMail.Subject = "Message ! ! ! " olMail.Body = "Message ! ! ! " olMail.Send Next Can somebody help me with the following: I need to add a code in this macro who makes an attachment from another workbook. Is this possible? Many thanks for help.