1 00:00:00,880 --> 00:00:05,360 Well, another thing we have seen in class is the correspondence combination, 2 00:00:05,360 --> 00:00:11,439 okay? So to do that we came to correspondence, to the correspondence tab, 3 00:00:11,439 --> 00:00:18,940 and here we have a series of tools that we are using. Well, I'm going to delete all this. To 4 00:00:18,940 --> 00:00:23,859 delete it, to select it all, I can go to the left margin, click three times, 5 00:00:23,859 --> 00:00:30,559 and then it selects everything, I delete it and that's it, okay? Well, here the first thing we did 6 00:00:30,559 --> 00:00:36,399 it will be good to start a correspondence combination and it gave me different options to make that 7 00:00:36,399 --> 00:00:43,439 combination a correspondence combination is like making a template and that automatically 8 00:00:44,899 --> 00:00:54,780 word will not personalize it for a set of information people or whatever 9 00:00:54,780 --> 00:01:02,219 that we have saved in a database or as word says in a list is worth in this case 10 00:01:02,219 --> 00:01:09,409 what I am going to do is a letter is worth then the first thing I give you is to start and I tell you the 11 00:01:09,409 --> 00:01:13,650 type of correspondence combination that I want to do the second thing I do is select the 12 00:01:13,650 --> 00:01:18,969 recipients and this gives me three options write a new list use an existing list or 13 00:01:18,969 --> 00:01:24,329 choose the outlook contacts we have not seen any outlook so this third option 14 00:01:24,329 --> 00:01:29,310 because we cannot use it to use an existing list this if we had done it 15 00:01:29,310 --> 00:01:34,930 once we could do it but we have never done it ok then we have to 16 00:01:34,930 --> 00:01:39,450 come yes or yes to the first option which is to write a new list then here 17 00:01:39,450 --> 00:01:45,189 this window is going to appear in this window different fields appear this 18 00:01:45,189 --> 00:01:48,810 structure that is showing me is important because it is how they work 19 00:01:48,810 --> 00:01:53,790 the databases when we work with access which is the tool that 20 00:01:53,790 --> 00:01:59,670 propósito que nos proporciona microsoft word para trabajar con bases de datos vais a ver 21 00:01:59,670 --> 00:02:07,310 que vamos a trabajar al principio muy al principio de esta manera vale bueno aquí me muestra una 22 00:02:07,310 --> 00:02:14,889 tabla unas columnas y las filas cada fila de ésta se llama un registro vale entonces vamos a ir 23 00:02:14,889 --> 00:02:21,590 metiendo información y word cuando estamos haciendo la combinación de correspondencia 24 00:02:21,590 --> 00:02:27,969 nos va a generar un documento sobre la plantilla que vamos a hacer ahora por cada registro por 25 00:02:27,969 --> 00:02:34,789 cada línea que tenga esa tabla vale bueno lo primero que podemos hacer es bueno aquí me da 26 00:02:34,789 --> 00:02:43,289 por defecto una serie de campos vale informaciones yo no las quiero todas entonces puedo darle a 27 00:02:43,289 --> 00:02:50,090 personalizar columnas y entonces estas son todas las que aparecen aquí arriba yo no quiero todo 28 00:02:50,090 --> 00:02:55,789 this I can want for example treatment because not the name if last name if 29 00:02:55,789 --> 00:03:03,979 name of the organization because not this does not leave me 30 00:03:03,979 --> 00:03:08,599 it is worth eliminating this also eliminate this also 31 00:03:08,599 --> 00:03:13,400 for the city we are going to leave the province I eliminate it well to make the 32 00:03:13,400 --> 00:03:16,979 example we are going to leave a few fields 33 00:03:16,979 --> 00:03:24,620 vale eliminar eliminar 34 00:03:26,479 --> 00:03:31,939 y eliminar bueno si yo quisiera meter más campos 35 00:03:31,939 --> 00:03:38,740 vale por ejemplo podemos meter aquí otro campo agregar y le digo vale el nombre 36 00:03:38,740 --> 00:03:43,379 del campo pues va a ser por ejemplo nota 1 37 00:03:43,379 --> 00:03:55,759 vale agregar nota 2 agregar nota 3 vale por ejemplo imaginaros que es algo así y vamos a 38 00:03:55,759 --> 00:04:03,080 hacer una plantilla para que luego reciba y las notas de cada evaluación vale entonces yo dejo 39 00:04:03,080 --> 00:04:07,139 estos campos son los que quiero le voy a aceptar entonces fijaros como ahora esta tabla me la 40 00:04:07,139 --> 00:04:12,939 muestra con los campos que le he dicho el nombre los apellidos ciudad nota 1 nota 2 nota 3 vale 41 00:04:12,939 --> 00:04:18,060 then I start to put the data here then I say good to see for example because oscar 42 00:04:19,500 --> 00:04:35,639 last name gome city madrid note 1 because it is a 5 14 18 for example another because sylvia is worth 43 00:04:35,639 --> 00:04:49,040 sanz here we are going to put barcelona and we put the notes because a 5 a 5 and a 5 we put now carlos 44 00:04:49,040 --> 00:05:04,519 vale carlos hernández madrid vale y aquí te vamos a poner un 1 un 1 a un 2 y 45 00:05:05,860 --> 00:05:11,139 vamos a ponerle ahí también un 1 vale vamos a poner ahora a maría 46 00:05:11,139 --> 00:05:27,560 sancho who is also from madrid ok maría has everything at 9 ok these would be my data here we would 47 00:05:27,560 --> 00:05:33,639 put all the data all the records all the information of the people to 48 00:05:33,639 --> 00:05:40,120 whom these notes are addressed ok imagine if it is all the students of the smr 1b because 49 00:05:40,120 --> 00:05:46,560 here you would have to appear all the students with your notes, okay, well, I'm going to accept it, 50 00:05:46,560 --> 00:05:51,500 then notice that the first thing he tells me is to save that list, okay, I'm going to tell him to 51 00:05:51,500 --> 00:05:59,819 save it on the desktop, okay, then look at this is the list that I am doing that he already had, he 52 00:05:59,819 --> 00:06:05,620 saves it with this key, this is the symbol of access, it is worth that we have not used it so far, but 53 00:06:05,620 --> 00:06:11,920 if you want if you open it here if you double click I was going to open it instead of with the word I was going to 54 00:06:11,920 --> 00:06:19,779 open it with access ok which is the way we have to work with relational bases so that 55 00:06:19,779 --> 00:06:25,540 we can learn those concepts of relational bases and that we will see a little later ok 56 00:06:25,540 --> 00:06:33,060 in this case I put the name because I am going to say list smr as I have that I am going to put a 2 57 00:06:33,060 --> 00:06:40,740 vale y lo guardo vale ya tengo esos datos creados entonces yo ahora me pongo a crear mi plantilla 58 00:06:40,740 --> 00:06:51,819 entonces empieza a poner bueno estimado señor señora dos puntos y ahora quiero que aquí ponga 59 00:06:51,819 --> 00:06:57,439 el nombre de los diferentes alumnos vale entonces hay una opción que dice insertar campo una 60 00:06:57,439 --> 00:07:04,220 tool to insert a combined field if you deploy you see you have all those fields here ok 61 00:07:04,220 --> 00:07:08,839 then what I want is for you to put esteemed sir lady the name and then put me there the 62 00:07:08,839 --> 00:07:19,399 field name I give a space and the surnames ok the name and the surnames ok resident 63 00:07:23,230 --> 00:07:28,329 and now we are going to insert it again insert combined field and I tell you in the city this 64 00:07:28,329 --> 00:07:34,569 no podéis escribir menor menor el nombre del campo mayor mayor hay que hacerlo vale desde insertar 65 00:07:34,569 --> 00:07:49,930 campo vale las notas obtenidas esta evaluación han sido y entonces ahora cojo y digo eran tres 66 00:07:49,930 --> 00:07:58,870 notes because I am going to insert a table so it is worth then I am going to put here note 1 67 00:08:00,970 --> 00:08:10,649 note 2 note 3 ok and I am going to put a format something like that let's see what else 68 00:08:10,649 --> 00:08:19,509 tiene esto algo así me gusta más vale esto 69 00:08:19,509 --> 00:08:28,029 y lo quiero alinear en el centro por ejemplo nota 1 notador nota 3 bueno en 70 00:08:28,029 --> 00:08:34,769 realidad los quiero todas las notas lo quiero todo alineado al centro 71 00:08:35,809 --> 00:08:38,690 al centro 72 00:08:38,690 --> 00:08:45,370 but it is worth this to the center 73 00:08:45,370 --> 00:08:51,370 and this is the center and now what am I going to do here go 74 00:08:51,370 --> 00:08:57,269 putting in each of the cells of the table that we will see them also this 75 00:08:57,269 --> 00:09:04,330 week I'm going to come to where the correspondence insert field 76 00:09:04,330 --> 00:09:09,629 combined I tell him note 1 and here I put note 2 77 00:09:09,629 --> 00:09:18,450 and here we put note 3 and this would be our good 78 00:09:18,450 --> 00:09:21,450 greeting 79 00:09:21,610 --> 00:09:31,059 of lies and this would be our template ok this 80 00:09:31,059 --> 00:09:35,440 would have a text that will appear in all the documents we are going to 81 00:09:35,440 --> 00:09:40,539 generate and then those fields that are the ones that are going to be customized then if you look here 82 00:09:40,539 --> 00:09:48,759 at the end there is an option that puts you to finish and combine and before we have this one that could 83 00:09:48,759 --> 00:09:57,320 be moving through different fields, that is, through different generated documents, so 84 00:09:57,320 --> 00:10:01,899 the first thing I'm going to tell you is to finish and combine 85 00:10:04,860 --> 00:10:11,320 and this gives me three options it says to edit documents individually it will generate 86 00:10:11,320 --> 00:10:16,179 documents on the computer print documents you can send them directly to the 87 00:10:16,179 --> 00:10:21,740 printer that we have configured by default if we have any or send them by 88 00:10:21,740 --> 00:10:28,240 e-mail that this happens to us the same as before we have not used outlook and then this 89 00:10:28,240 --> 00:10:34,980 we cannot do it yet ok I'm going to tell you to edit the individual documents when you edit 90 00:10:34,980 --> 00:10:40,759 the documents you get this little window and it tells you all current record only one is worth the one that 91 00:10:40,759 --> 00:10:50,799 we have here or from 1 to 3 or ok if we don't want them all but if we want a sub-range 92 00:10:50,799 --> 00:10:57,120 de todo el rango de registros que tenemos en este caso yo los quiero todos le voy a aceptar y 93 00:10:57,120 --> 00:11:02,779 entonces que me crea pues esto estimado señor señora oscar gómez residente en madrid este 94 00:11:02,779 --> 00:11:10,259 era el primer registro que teníamos las notas obtenidas esta evaluación han sido un 5 un 4 y 95 00:11:10,259 --> 00:11:18,360 un 8 vale un saludo y es villablanca vale si sigo bajando entonces aquí ya tengo el segundo el 96 00:11:18,360 --> 00:11:23,480 second document that has been generated from the template that we had created before 97 00:11:23,480 --> 00:11:30,580 estimated silvia san resident in barcelona the notes obtained this evaluation has been 55 and 5 98 00:11:32,419 --> 00:11:40,240 estimated sir carlos hernández resident in madrid the notes obtained have been 1 2 and 1 it is worth the 99 00:11:40,240 --> 00:11:48,700 mismo que hemos puesto antes estimada señora maría 999 y ya no hay más a este este me lo ha 100 00:11:48,700 --> 00:11:53,019 creado porque habíamos dejado un registro en blanco por eso me lo han creado vale cuando hemos 101 00:11:53,019 --> 00:11:58,860 creado la lista he dejado una línea en blanco y por eso me ha creado esto pasa nada vale entonces 102 00:11:58,860 --> 00:12:03,039 yo lo tendría bien cogería estos documentos los podría guardar o hacer con ellos lo que 103 00:12:03,039 --> 00:12:08,340 we would like if you close this window where the documents are, you still have 104 00:12:11,429 --> 00:12:18,090 not to save, you still have your template, okay, then this and so we would come to the archive to save 105 00:12:18,090 --> 00:12:25,789 save or save as if we have never saved it and here we do not change the type, that is, here we would 106 00:12:25,789 --> 00:12:34,789 dejaríamos como documento de word doc x vale y ya tendríamos un documento que va a ir siempre 107 00:12:34,789 --> 00:12:46,970 contra la base de datos que hemos creado vale que es a ver dónde está aquí que es esta base 108 00:12:46,970 --> 00:12:52,590 de datos vale y antes lo que os decía es si yo hago doble clic encima fijaros me abre 109 00:12:52,590 --> 00:13:04,080 that those data you see the data that we have put before and it shows them to me here this is the access that 110 00:13:04,080 --> 00:13:09,679 we will see it is worth here I could continue generating those documents I can even take this 111 00:13:09,679 --> 00:13:20,429 row that has created us in white I select it and I tell it to delete it and so we leave it 112 00:13:20,429 --> 00:13:31,509 todo lo dejamos todo bien vale bueno pues este es el vídeo para que podáis practicar la combinación 113 00:13:31,509 --> 00:13:39,029 de correspondencia vale y esta semana seguimos trabajando bueno chicos pues un saludo hasta luego