Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching Files to Emails
How can I get the following code to instead of attaching a file that I
specify in code to the email. I would like to make it open a browse screen so that they can browse to a file for me at attach to the email. With MailObject .To = "EmailAddress" .Subject = strFileName & " - " & Me.txtDescription .Attachments.Add "c:\My Documents\book.doc" .Display End With Thank you in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Attaching Files to Emails
Try
fName = Application.GetOpenFileName() "Ben" wrote: How can I get the following code to instead of attaching a file that I specify in code to the email. I would like to make it open a browse screen so that they can browse to a file for me at attach to the email. With MailObject .To = "EmailAddress" .Subject = strFileName & " - " & Me.txtDescription .Attachments.Add "c:\My Documents\book.doc" .Display End With Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting files and emails in a cell | Excel Discussion (Misc queries) | |||
Attaching Emails in Outlook Message Format | Excel Discussion (Misc queries) | |||
problem in attaching files( Pivot Tables ) | Excel Discussion (Misc queries) | |||
Attaching PDF files | Excel Discussion (Misc queries) | |||
Excell Files attached to emails are suddenly not readable today. . | Excel Discussion (Misc queries) |