Use File Dialog, Attach Multiple Files to Multiple Recipients: MS Access

Select file from File Dialog then put it in the list box. Send those files from list box to multiple recipients via Outlook.
Download Sample file at : www.iaccessworl...

[@jungjungdelosreyes4147]

Hi Sir, can we save the selected files in the List into an Auto Created Folder while sending the email?

[@shaiba5095]

Fantastic, I have benefited from this lesson, thank you very much.

[@jadehawk]

Thank you for this tutorial. very clear and easy to understand...

[@bioskopakuntansi]

Very helpful. TQ from Indonesia

[@janezklun]

Thank you for great video,
Janez

[@austin72406]

you're welcome, Janez.

[@jungjungdelosreyes4147]

Hi Twan, good day to you, its a very straight video tutorial, most of my dtabase comes from your ideas, can you code those file attachment can save in one folder in while sending the email? it will be very helpful to simplify my works. thank you in advance.

[@koreywalker3937]

I saw you answered the question below already. Thanks .. But can you share codes on how to save the file path in the table? Also, do you bound the table? Thanks

[@koreywalker3937]

Great Video on attaching file paths!!! However, how do you save the file path to a record in your access table? Do you have a video for that? Thanks

[@rooneymmmmful]

Great video sir. Subscribed!

[@akashtribhuvan8124]

I have created a data entry form with Subject line (Text), Email Body (Text) and an Ole Object box in which I paste the screen shot. Now on save button click, data gets added to the table and also drafts an email with the same subject line and email Body.
***CONCERN I am facing with the ole object IMAGE, which I want automatically to be in the email body below the text. Is there any way to do so, if not then any alternative or suggestions?

[@Henanmir22]

hi. This video is great. Can i ask do you have a video which allows me to import a file to access? So if i wanted to import a .doc or excel document but using this technique?

[@maurizioregis3346]

thanks and congratulations. An information. would it be possible to make the files in List3 possibly linkable? if yes, please, how? thank you

[@frederiko1982]

I cant even make the attachment. Only put the image as default picture but not as real attachment. I can send you the code i haver so far. Can you give me a hand as im relatively new in vba programming

[@gcool10336]

Your video was very helpful! Thanks for the hard work!! How can I send the email without the email opening? I just want it to send in the background.. Thanks

[@austin72406]

you will use .Send instead of .Display on your code.

[@gcool10336]

Thanks...how to bypass the security warning in outlook?

[@Because011]

This is what I need but I want the file to get attached to form/table/record after I select my file. Please advise.
Thank you

[@austin72406]

I have a download file on my website that similar to your question here:
www.iaccessworld.com/downloads/store-and-view-documents-db/

[@frederiko1982]

I wanto to have a file dialog to upload max 8 files to the opened form. Can you give some idea how to do it?

[@austin72406]

you need to set a counter for the list. Every time you insert a file to the listbox it counts. when you click to open file dialog, but count 8 files in the list box then get a message then exit command before open the file dialog.

[@mygmale]

Biggest THANKS to Austin. I am wondering if anybody know how to add the data file to database in VBA? I am struggling to do it right. I am stiLl learning VBA. Thanks.

[@pedroavendanor.7644]

Thankyou for your excelent and very helpful videos!! Only one problem: my sistem does not recognize de declaration "Dim oOutlook As Outlook.Application" I receive a message saying Compile error: User-defined type not defined. Would greatly appreciate your help. Best regards

[@farinatty]

Did you try setting the library reference as noted at 6:00 ?

[@starmedia62]

Austin,
Can you contact me. I have an assignment how to send attachment through emails to teh customer through MS Access.

[@austin72406]

you can contact me at my website on contact us page. I may do a side job.

[@walidsaid38]

Hi, is it possible not to Show the full file path in the list box

[@austin72406]

yes, you will need to extract the part you want from the full file path before inserting into a list box. For example, you want only to show a file name then you will need a function to extract file name out off full file path. There are many resource on the web that you can find.

[@carliek7531]

Great video.
is there a code to "view files"?

[@austin72406]

in the download file. link is under the description section.

[@MrYoenz]

Can someone help me ? I followed all steps had no problems. But how can i save all the file paths in my database?

[@austin72406]

you need to add a field in your table like "LinkAddress" and save them to this field corresponding to your record id.

[@RadyDiab]

Type MisMatch?

[@adithhalid55]

how to open file again from list box. thanks

[@austin72406]

Use click or double click event

[@adv.ranjitdolas6135]

Thanks

[@michellemoncevais2878]

@ austin72406, I was wondering if there was a way to create a form that would automatically search for a folder labeled by Employee First Name and Last Name and then read list all files in that folder on our company server. We basically want to be able to view all files per employee in our database. I am not sure if you already have a video like this or can help.

[@austin72406]

sorry, I don't have any video for this Scenario