File Picker for attachment

Nico2010

Member
Outlook version
Outlook 365 64 bit
Email Account
POP3
Hello
I would like a macro that pick a file from a folder and attach it to my email.
Need help getting started.
Thank you
-Nico2010
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Is it picking a file by name or do you want to open a specific folderr and browser for the file?

For the first, you use attachment.add:


Code:
 Set oMail = objApp.ActiveInspector.CurrentItem
With oMail
    .To = oContact.Email1Address
    .Subject = Left(oDoc.Name, Len(oDoc.Name) - 5)
    'The content of the document is used as the body for the email
    .Body = oDoc.Content
    .Attachments.Add "c:\path to \Documents\instructions.pdf"
    .Display ' .send
End With
 

Nico2010

Member
Outlook version
Outlook 365 64 bit
Email Account
POP3
Is it picking a file by name or do you want to open a specific folderr and browser for the file?

For the first, you use attachment.add:


Code:
 Set oMail = objApp.ActiveInspector.CurrentItem
With oMail
    .To = oContact.Email1Address
    .Subject = Left(oDoc.Name, Len(oDoc.Name) - 5)
    'The content of the document is used as the body for the email
    .Body = oDoc.Content
    .Attachments.Add "c:\path to \Documents\instructions.pdf"
    .Display ' .send
End With
Thank you.
 
Similar threads
Thread starter Title Forum Replies Date
P File Picker for attachment Outlook VBA and Custom Forms 0
D Forwarding email based on the attachment file type and specific text found on the attachment file name Outlook VBA and Custom Forms 1
N Save Selected Email Message as .msg File Outlook VBA and Custom Forms 12
L Article on merging pst file Using Outlook 1
J Deliver new messages to New or Existing Data File? Using Outlook 2
F VBA to move email from Non Default folder to Sub folders as per details given in excel file Outlook VBA and Custom Forms 11
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
A Macro to file emails into subfolder based on subject line Outlook VBA and Custom Forms 1
O Comma Separated Values.ADR and A file error has occurred in the translator Using Outlook 6
R Problem moving file “Email folders.pst” to new PC Using Outlook 5
B vBA for exporting excel file from outlook 2016 Outlook VBA and Custom Forms 3
V Pin a document to the "Attach file" Recent Documents list Using Outlook 0
D Outlook 2016 Unable to load Outlook data pst file Using Outlook 5
K Need to convert .mmf file to .pst format Outlook VBA and Custom Forms 7
S save attachment with date & time mentioned inside the file Outlook VBA and Custom Forms 0
E Having some trouble with a run-a-script rule (moving mail based on file type) Outlook VBA and Custom Forms 5
B Can I create a local PST file for SPAM on a drive that is usually disconnected? Using Outlook 3
C Macro to extract sender name & subject line of incoming emails to single txt file Outlook VBA and Custom Forms 3
P Outlook pst file is too huge with POP3. How to save more space? Using Outlook 4
G Cannot Move Autocomplete File to New Computer Using Outlook 15
B Outlook 2013 erratically deleting original file that is attached Using Outlook 0
I Outlook 365 - import/attach PST file that used POP3 Using Outlook.com accounts in Outlook 0
M Deleting attachments does not reduce file size Using Outlook 0
P PST file is getting huge under POP 3 Using Outlook 2
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
F Script for zip file attachment Outlook VBA and Custom Forms 1
M Export-Import .pst file problems Using Outlook 2
L Cannot open PST file for first session each day Using Outlook 6
J Outlook 2010 Changing events in Outlook calendar via opening file, importing CSV Using Outlook 0
C Can't create Outlook data file Outlook Wishlist 0
S What's in a PST file? Using Outlook 1
S automate save the .xlxs file to share Network Using Outlook 1
L Outlook Office 365 client: won't remember my setting File, not to collapse ribbon Using Outlook 2
B Outlook 2010 Can not find a certain file in M/S Outlook 2010. Using Outlook 1
A Order of Recent Items in Attach File List Using Outlook 5
J How to open OST file in Outlook 2019 & 2016 Using Outlook 1
W error with the permission for the file Outlook VBA and Custom Forms 0
L What are the risks of opening an Outlook 2016 .pst file in Outlook 2010? Using Outlook 4
DoctorJellybean Preserve OST file location in new installation? Using Outlook 4
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
A Populate Listbox from Txt File Outlook VBA and Custom Forms 0
M Same file "stuck" on top of file list in "Attach File" drop down Using Outlook 4
A Populate Textbox from Txt File Outlook VBA and Custom Forms 1
A Read and Write to Text File Outlook VBA and Custom Forms 1
geofferyh How to change the Attachment File Name? Outlook VBA and Custom Forms 1
S Moving .OST file location unsuccessful! Using Outlook 6
S auto-mapping mailboxes in outlook impacting an ost file? Exchange Server Administration 2
DariTrevino MIcrosoft Outlook PST file cannot repair Using Outlook 1
GregS Can't access archive file Using Outlook 5
P how to remove unwanted PST file default categories assigned to many calendar entries Using Outlook 7

Similar threads

Top