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

hello welcome back to my video tutorial for focus of XS mostly for negative surfaces 2010 version and in this video I will show you how to create the button or open the file off Bob and then attach to the tick tick box first create a blank form then design view when we can make it color nicer and I we put in the tape ball chain and they notify okay we need to open dialog and then open the file and put the find him on this Bob it's official with small and let me savvy now we need to add a button open or attach attach file under this one way one take and then open mean similar to a Ford Explorer and then select the file and then put the file here we call Phi dialogue for open final one under this we go to the property on even procedure we need to put some code here or function I will put create a function and call the open five or silly thing with acidic niacin select File and then put on that box now we here put in the function public phone function civic fire string and this video are we not going to put the error handle in here just put you know the basic code for function then we start with dim the FB like a five dialogue stands for title of s of $5 and every sip FD equal to application dot Phi dialogue or we pick the open a mess or fine object find that one and close parentheses and use a with the not allow multiple a equal to four and the title we need to say the title equal to face silly 5 and if dot dot show equal to two then not shown and we put the silicon if the dialog box open and then we see like the Phi equal silica item how many item you just slip one and my take Bob will stick box zero because over here I think Bob name is Deepak zero I didn't change the name yet equal to civic five heels and exit function it is not open and on Bob and just exit the function in if and then sip five dialogue FD equal to nothing we have the width Edmond and then we have to in with before we exit function then let's sit for the function of a civic fine to open dialogue but before we save and so fun dialogue before we use that the main call we need to set the refrain put the two and reframe the sip referring to make a sob of this right here you have to pick score down to pick the mix up of fish for team engine object library you have to select the mix up of face 14 to make it work if you don't have free friending it's not gonna open it and view it now we open our attach file and open it you see it's open dialogue like any program before you say Phi or pix identify to open you open now I will select the 1 5 from download folder why we use them this one makes up fine now when I selected all that fine and is part or location from C useful to one download issue on this text file is similar to copy that file including the part for location of that file to this case for the next step I want to select many Phi and put on the list ok we need to create a list ball here is Bob and you can add is fine and on the list okay okay I'll be tight and just exit here I don't want to do anything on that they say list number three and we edit the syllabi button composition and we put in in this one they take Bach equal to say PI and then we also wanna add need not least number three tab item item by itself is equal to select five okay we had item to the list and we view it you see like the first fine from here save one and open it and Rousseau type Opry must be said to this value list okay we have to set the list to this value is over here row sauce type poverty we have to set to all the list in order to put the value in this list and open again now we copy we insert the one fine here now we need to see the cannot apply to this and this second fine or third fine and tendency we select refine to do this on this Bobby short one because it hoary one fired a time but the least you know you can and show an item to release as long as you have this from open you're going to add it on and on after you sleep this one by our code is on the list we add item whereas item was from silica 5 c4 here after I select 3 files on the list here now I want to send all this fine to to all customer well with one email and attach three files here you go to the side view again and add a button here and just cancel that and name as email send email and under click event position open that you win and now we can put all the code in here on another video I already show you how to send the email we hollow and the code and now we can copy from the previous video or we can type it in here we start with on arrow go to and then exit exit some handle can mess it description will be critical and we soon fix it ok now we put our code here we start with all of dim Oh Luke as our look dot that occasion and demo email item as a mail item move item here people are oak is nothing then sit oh I'll look equal to new if the Maxima looks not open and we opened an application and in it and set o email item equal to application or outlook don't create AI 1000l mail item okay we use a with statement with Oh a mail item and in with that in here we just put in with you before we know will be forget from that we want to send to our customer we have to use the breaker set beam is as requested and then deem recipient or customer email as string now under witness said the is no record set equal to cream DB dot open the course set record set of what of we use of civic we got a record set from Civic all form table non customer we got here table customer input double quote close parenthesis if our is record cow greater than zero you know if we have the customer on the list then we the move is not move to the first one to the first on the list and then we use it do and to is dot you know 5e o F okay we said the rope loop here is in the rope and then now we also need to test the customer to if we have the customer some customer doesn't have in you some heavy meal if is no dot is that is minimal is a commission email email feel this mean customer doesn't have email and we move to the next one else where we get the email week from this table record of a customer we have the table but we have to feel his name email here email feel that's why we because set up email and move to the next one now if we have the email we put in a custom email equal to customer email and is a commission and email and I mean this one and we put double quote semicolon the cut email speed which we deem a we use a semicolon which we not each email and dot to send to who tend to customer email sent to this one because we have all the Holly mail on the list and is the Mopa next and indeed now we if we loop and we have evil here it is greater than zero this one after loop do now elbows and if it is record how is equal to zero or doesn't have any customer we just put the message about that no customer on the list because nobody on this table like a empty table okay and we in E and now dot CC if you want to put somebody in sec I don't have anyone I just put MP and bright one now that subject you put in put subject on email and we can put a test five 10 left s 5 now we just finish the ones in email to all the customer on the list next day we need to attach the notify on the list here now we got the two years in two and CC and subject now it has the next step is at her before we do that we have to maybe you can put them over here team on this foot in as integer we need the four move now for in equal to zero to me dot list with number three we have that dot list cow minus one this cow which means the total we have three during that time we call we use we add use attach that Tashman dot add and effort at me please three item the item on the list item data in and next in and on display and in which we have envied already here now this function for rube and to attach the item or five file location on the list add it on view it and sip some fire here some Excel they can attach any title I exhale PDF or Microsoft Word and now we send email they sent to all customer is loading Microsoft Outlook look good they sent all to customer who has an email address here and spit with the same icon for his email and the subject I just why now it has to be fine here let's see it has we caught this three five from here second pip body and attach attendance in this video you learn how to open dialog box here you have the code to open dialog and put this fine on the list and then you learn how to send the email or this fine from the list to multiple customer thank you for watching

Channel: T Golden Eye

Views: 35,298

Rating: 4.8581562 out of 5

Keywords: Howto, how to, access 2010, ms access vba, MS access 2010, vba access, access tutorial, filedialog, open file dialog, select file from file dialog, send file to many recipient, attach multiple files to multiple recipients, attach many files to many users

Id: dydA1PMo8YE

Length: 24min 33sec (1473 seconds)

Published: Wed Mar 26 2014