MailMerge-spa
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRST
1
Celdas azules contienen texto de ayuda
2
Celdas amarillas, en las que introduciremos la información
3
Celdas rojas contienes datos imprescindibles para la aplicación. No se pueden modificar.
4
5
Este documento contiene tres hojas de cálculo: "Instructions and settings", "Email text" y "Data to be merged"
6
En esta hoja (below), escriba su nombre(as it will appear in the From section of your email), el asunto del email, y el email del remitente. You only need to set a reply-to address if you want replies to go to an email address other than the one you are sending from; if you set it, when the recipient of your email clicks reply, that's the address the reply will be sent to.
7
Podemos mandar documentos adjuntos que hayamos subido primero a Google Docs. Copia la ID de docuemneto entre las celdas "Start of attachment list" y "End of attachment list". Puede añadir celdas extra si necesita adjuntar más documentos.
8
9
En la segunda hoja ("Email text"), escriba el contenido de su email entre las celdas rojas "Start of email" y "End of email" .
Sólo use las celdas entre "Start of email" y "End of email". Cada celda representará un párrafo en su mail. Puede añadir filas extras si son necesarias (use el menú Insertar). Las filas vacías son ignoradas.
10
Al escribir su mail, puede insertar campos especiales que serán reemplazados al combinar los correos, leyendo los datos de la hoja "Data to merged". Los campos especiales se escriben de la forma <<firstname>>, siendo firstname el título de una columna de la hoja de datos "Data to merged". Cuando ejecutemos mail merge,las marcas serán reemplazadas por la información específica de la persona correspondiente. Puede insertar tantas <<markers>> como quiera, siempre y cuando sean columna de la hoja mencionada.No usar un marker lllamado <<status>>, which is reserved for the script's own use.
(In the unlikely event you wish to change the characters used to enclose field names, you can do so at the bottom of this sheet).
11
12
Once you have composed your general email, go to the third sheet ("Data to be merged"). The first row of this sheet must be the list of markers you wish to use. NB Markers are case sensitive - if your marker is <<firstname>>, and your column heading is <<Firstname>>, your mail merge will fail.
13
14
When you have completed your data, use the "Test mail merge" option from the Mail Merge menu. This will pop up the first three emails which would be sent - so you can check that they appear correctly, and the right information is being merged in.
Then, once you are happy, click "Run mail Merge" from the Mail Merge menu. That's it!
(The very first time - and only the first time - you use the Mail Merge menu, you will be asked to grant permission for the script to use your Google email account. You need to click the menu item again after giving permission).
15
As your emails are sent, the Status column in the "Data to be merged" sheet is updated. Google restricts the number of emails which can be sent in one go, to prevent the system being used to send masses of spam. We have recently updated the script, so that if you are sending more than 25 emails, the script waits half a second between each email, which seems to make it possible to send more - in our tests we have successfully sent up to 100 before we encountered a problem. Of course, this means it takes a little longer to send lots of emails. If an email is not sent for some reason, the Status column will indicate this. (Google doesn't disclose exactly how many emails can be sent in a short time without triggering the anti-spam mechanism)
16
17
Your nameAntonio Omatos Soria
18
Email subjectDatos de acceso a Iberkeltia para <<name>>New: you can now include mailmerge fields in your subject if you wish to
19
Reply-to addressantonio@cprlogrono.org
20
21
Start of attachment list
22
Escriba la ID del documento de GoogleDocs que queremos añadir.
23
Se pueden añadir las celdas que consideremos oportunas.
24
25
End of attachment list
26
27
28
before<<
29
after>>
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
Loading...
Main menu