Combinar correspondencia avanzada/Advanced Mail Merge Macro

%3CLINGO-SUB%20id%3D%22lingo-sub-2003923%22%20slang%3D%22es-ES%22%3EAdvanced%20Mail%20Merge%20Macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2003923%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20share%20with%20this%20community%20a%20project%20that%20allows%20the%20combination%20of%20advanced%20correspondence.%20I%20would%20like%20to%20present%20it%2C%20and%20receive%20feedback%20on%20possible%20improvements.%20The%20project%20is%20a%20macro%20in%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3EWord%20with%20VBA%3C%2FSTRONG%3Eand%20is%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20available%2C%20with%20its%20code%20in%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdavidbuenov%2FCombinarCorrespondencia%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fdavidbuenov%2FCombinarCorrespondencia%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20what's%20so%20special%20about%20it.%20Well%2C%20it%20allows%20you%20to%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Generate%20PDF%20documents%3C%2FP%3E%3CP%3E2.%20Select%20the%20folder%20where%20they%20will%20be%20saved%3C%2FP%3E%3CP%3E3.%20Assign%20a%20custom%20name%20to%20each%20PDF%20document%3C%2FP%3E%3CP%3E4.%20Put%20unique%20or%20custom%20password%20to%20each%20PDF%20document%3C%2FP%3E%3CP%3E5.%20Select%20from%20the%20different%20outlook%20accounts%20you%20have%20on%20your%20computer%20to%20send%20the%20mail%3C%2FP%3E%3CP%3E6.%20To%20be%20able%20to%20attach%20other%20files%20to%20the%20result%20of%20the%20combination.%3C%2FP%3E%3CP%3E7.%20With%20the%20result%2C%20multiple%20PDF%20documents%20can%20be%20signed%20using%20Self-Signature%3C%2FP%3E%3CP%3E8.%20The%20macro%20is%20valid%20for%20versions%20of%20Office%202016%20and%20later%20(2019%20and%20Office%20365)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20an%20image%20of%20the%20template.%20And%20to%20understand%20how%20it%20is%20installed%20and%20used%2C%20I%20have%20also%20prepared%20several%20videos.%20The%20first%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FGCoHx2JaaMI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20nofollow%22%3Ehttps%3A%2F%2Fyoutu.be%2FGCoHx2JaaMI%3C%2FA%3E%3C%2FP%3E%3CDIV%20class%3D%22message-user-info%22%3E%3CDIV%20class%3D%22user-profile-image%22%3E%3CDIV%20class%3D%22message-user-image%20message-username-image-link%20avatar-size-small%20circular-display%22%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22message-user-info-text-and-badge%22%3E%3CDIV%20class%3D%22message-user-info-text%22%3E%3CDIV%20class%3D%22message-user-info-text-and-affiliations%22%3E%3CA%20title%3D%22David%20Bueno%20Vallejo%22%20href%3D%22https%3A%2F%2Fanswers.microsoft.com%2Fes-es%2Fprofile%2Fe82eebe7-60c6-4117-b07d-127627c2eb5a%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EDavid%20Bueno%20Vallejo%3C%2FA%3E%3C%2FDIV%3E%3CSPAN%20class%3D%22asking-text-asked-on-link%22%3ECreated%20December%2017%2C%202020%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3ECombine%20advanced%20correspondence%20%E2%89%A1%20Microsoft%20365%3C%2FP%3E%3CDIV%20class%3D%22thread-message-content-body-text%20thread-full-message%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20share%20with%20this%20community%20a%20project%20that%20allows%20the%20combination%20of%20advanced%20correspondence.%20I%20would%20like%20to%20present%20it%2C%20and%20receive%20feedback%20on%20possible%20improvements.%20The%20project%20is%20a%20macro%20in%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20%3CSTRONG%3EWord%20with%20VBA%3C%2FSTRONG%3Eand%20is%20%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%20available%2C%20with%20its%20code%20in%3A%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdavidbuenov%2FCombinarCorrespondencia%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fdavidbuenov%2FCombinarCorrespondencia%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20what's%20so%20special%20about%20it.%20Well%2C%20it%20allows%20you%20to%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Generate%20PDF%20documents%3C%2FP%3E%3CP%3E2.%20Select%20the%20folder%20where%20they%20will%20be%20saved%3C%2FP%3E%3CP%3E3.%20Assign%20a%20custom%20name%20to%20each%20PDF%20document%3C%2FP%3E%3CP%3E4.%20Put%20unique%20or%20custom%20password%20to%20each%20PDF%20document%3C%2FP%3E%3CP%3E5.%20Select%20from%20the%20different%20outlook%20accounts%20you%20have%20on%20your%20computer%20to%20send%20the%20mail%3C%2FP%3E%3CP%3E6.%20To%20be%20able%20to%20attach%20other%20files%20to%20the%20result%20of%20the%20combination.%3C%2FP%3E%3CP%3E7.%20With%20the%20result%2C%20multiple%20PDF%20documents%20can%20be%20signed%20using%20Self-Signature%3C%2FP%3E%3CP%3E8.%20The%20macro%20is%20valid%20for%20versions%20of%20Office%202016%20and%20later%20(2019%20and%20Office%20365)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBelow%20is%20an%20image%20of%20the%20template.%20And%20to%20understand%20how%20it%20is%20installed%20and%20used%2C%20I%20have%20also%20prepared%20several%20videos.%20The%20first%3A%3C%2FP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FGCoHx2JaaMI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20nofollow%22%3Ehttps%3A%2F%2Fyoutu.be%2FGCoHx2JaaMI%3C%2FA%3E%3CDIV%20class%3D%22AnswersExternalContent%22%3E%3CDIV%20class%3D%22video-container%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22%22%3EI%20would%20appreciate%20your%20opinion%2C%20dissemination%2C%20use%20or%20collaboration%20with%20the%20project%20through%20improvement%20proposals.NOTE%3A%20All%20current%20features%20have%20been%20requested%20by%20users%20of%20my%20youtube%20channel.%3C%2FP%3E%3CP%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22FormularioCombinar.jpg%22%20style%3D%22width%3A%20817px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241882i1B4A91EDE3143038%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22FormularioCombinar.jpg%22%20alt%3D%22FormCombinate.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hola,

 

Me gustaría compartir con esta comunidad un proyecto que permite la combinación de correspondencia avanzada. Me gustaría presentarlo, y recibir comentarios de posibles mejoras. El proyecto es una macro en Word con VBA y está disponible, con su código en: https://github.com/davidbuenov/CombinarCorrespondencia  

 

Y qué tiene de especial. Pues que permite:

 

1. Generar documentos PDF

2. Seleccionar la carpeta donde se guardarán

3. Asignar un nombre personalizado a cada documento PDF

4. Poner contraseña única o personalizada a cada documento PDF

5. Seleccionar entre las distintas cuentas de outlook que se tengan en el ordenador para enviar el correo

6. Poder adjuntar otros archivos al resultado de la combinación. 

7. Con el resultado, se pueden firmar múltiples documentos PDF usando Autofirma

8. La macro es válida para versiones de Office 2016 y posteriores (2019 y Office 365)

 

A continuación muestro una imagen de la plantilla. Y para entender cómo se instala y se usa, también he preparado varios vídeos. El primero: 

https://youtu.be/GCoHx2JaaMI 

Combinar correspondencia avanzada ≡ Microsoft 365

Hola,

 

Me gustaría compartir con esta comunidad un proyecto que permite la combinación de correspondencia avanzada. Me gustaría presentarlo, y recibir comentarios de posibles mejoras. El proyecto es una macro en Word con VBA y está disponible, con su código en: https://github.com/davidbuenov/CombinarCorrespondencia  

 

Y qué tiene de especial. Pues que permite:

 

1. Generar documentos PDF

2. Seleccionar la carpeta donde se guardarán

3. Asignar un nombre personalizado a cada documento PDF

4. Poner contraseña única o personalizada a cada documento PDF

5. Seleccionar entre las distintas cuentas de outlook que se tengan en el ordenador para enviar el correo

6. Poder adjuntar otros archivos al resultado de la combinación. 

7. Con el resultado, se pueden firmar múltiples documentos PDF usando Autofirma

8. La macro es válida para versiones de Office 2016 y posteriores (2019 y Office 365)

 

A continuación muestro una imagen de la plantilla. Y para entender cómo se instala y se usa, también he preparado varios vídeos. El primero: 

https://youtu.be/GCoHx2JaaMI 
 

 

Agradecería vuestra opinión, difusión, uso o colaboración con el proyecto mediante propuestas de mejora.  NOTA: Todas las funcionalidades actuales ha sido solicitadas por los usuarios de mi canal de youtube.

FormularioCombinar.jpg

 

 

En este video se explica cómo instalar la aplicación (macro de Word) que he desarrollado para generar documentos usando una combinación por correspondencia d...
0 Replies