Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting files and emails in a cell Radhakant Panigrahi Excel Discussion (Misc queries) 0 April 22nd 10 04:03 PM
Attaching Emails in Outlook Message Format Marie FP[_2_] Excel Discussion (Misc queries) 1 June 23rd 08 07:01 PM
problem in attaching files( Pivot Tables ) Rajesh Chandra Excel Discussion (Misc queries) 1 January 19th 08 09:35 PM
Attaching PDF files Neil Meehan Excel Discussion (Misc queries) 0 September 23rd 06 04:29 AM
Excell Files attached to emails are suddenly not readable today. . Debbie Excel Discussion (Misc queries) 1 January 11th 05 07:34 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"