Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Profil Kitana
 | Femeie
25 ani
Bucuresti
cauta Barbat
25 - 48 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
The code below is a complex code to send emails based on selected data in the active workbook. It consists of multiple parts, including:
- a Class Module with multiple subs to display messages if email was sent or resent
- a Module with multiple subs to create PDFs from Word documents with data from Excel in Word bookmark fields, create an email with the current active signature and a predefined body, attach the PDFs to the email, add .To and .CC, delete PDFs
- a few global variables to work in both modules
For this to be (maybe) simpler to follow, I will add the EmailWatcher module in its own post, then I'm going to split the normal Module into 2 parts: 1 containing helper Subs and the other 1 containing the main Sub that is the one that actually runs.
|
|
| pus acum 5 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
To be added
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|