Forum

Insert a Pdf Docume...
 
Notifications
Clear all

Insert a Pdf Document in an Email

4 Posts
3 Users
0 Reactions
80 Views
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Gaius to all my name is Maurizio
and my problem is this:
using the vba I created a procedure that opens my e-mail that at times does not have to be (Outlook) and I already place the address of the recipient in his place and so far so good.
Then I created a procedure that picks up data from sheet1 and more precisely from cell (A11: L23) and creates a pdf document that inserts it into the subdirectory called (Utility) and here everything is OK.
Ahora my question and this: There would be the possibility to have the pdf document taken, and put it in the email as an attachment?
Thanks so far for all the help you want to give me on Thanks

Attach Test File

 
Posted : 22/04/2018 4:45 am
(@mynda)
Posts: 4761
Member Admin
 

Hi,

Have you read this article?

https://www.myonlinetraininghub.com/error-creating-relationship-in-vba-userform-code-to-create-pdf-from-excel-worksheet-then-email-it-with-outlook

With Outlook you can add an attachment like so

.Attachments.Add PDFFile 

but that statement is out of context here on it's own, so please read the article to understand how it works.

Regards

Mynda

 
Posted : 23/04/2018 1:43 am
(@a-maurizio)
Posts: 214
Reputable Member
Topic starter
 

Ciao Mynda Treacy
Grazie per il tuo Suggerimento, però evidentemente non hai dato un occhiata al mio programma.
In quanto ti saresti subito Accorto che: Io non voglio usare come posta Elettronica (OutLook) ma altro che non sia lui.
(più) in cui si trova / Email) o (Thunderbird) ma al di la di questo, che mi manca e proprio solo il codice che dica dove pescare il mio file pdf e quindi lo prelevi da li; E lo metta come allegato all'interno del File di Posta Elettronica
Comunque seguirò il tuo consiglio e mi leggerò tutto per benino ciò che mi hai proposto tu

 
Posted : 23/04/2018 4:00 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi,

Your original post said that your email client does not have to be Outlook.  Not that it is not Outlook.  

VBA only works with Microsoft Office programs so it can;t be used to automate Thunderbird.

Regards

Phil

 
Posted : 23/04/2018 7:03 pm
Share: