Send e-mail with PDF file

Hello all

I have an excel spreadsheet that i make filters and create PDF to send to client's.

I want now to send them by e-mail:
- choose email's body , title etc etc
- insert PDF created

Can anyone help me with this?

.

Please Login or Register  to view this content.

Allows you to send one or multiple emails with the EMAIL sheet attached as PDF.
Macro can be edited to suit your needs.

Second / Different file attached as well.

Logit can i take pdf like that but attach it ?

And besides that, have each button for each client, or better:
Choose from validation the name of client, and click the button to send to His email the correct attach

Hello guys, can anyone help me out?

Instead of buttons, you can setup a column to hold the files to attach them in the row for that email. Instead of providing you with another working example, @Logit files are great examples, and if you want a custom solution, please provide your sample data, as per the yellow banner above, so we can review and update it.

Originally Posted by maniacb

Instead of buttons, you can setup a column to hold the files to attach them in the row for that email. Instead of providing you with another working example, @Logit files are great examples, and if you want a custom solution, please provide your sample data, as per the yellow banner above, so we can review and update it.

Hello maniacb,
i'm doing a new project and i need to pick this topic again, hopefully you guys can help me out

I need to:
Sent a different file to each and every different person

Check the file in attachment please

.
I couldn't get your macro to work as desired ... sorry.

I did put together the following macro that runs very well here. The macro is looking for TEXT files named "1.txt", "2.txt" & "247.txt" ... that are located on the desktop.

The workbook is also located on the desktop. The individuals TEXT files are correctly attached to the appropriate email.

Now ... what changes to the macro are required for your specific purpose ?

Please Login or Register  to view this content.

The files i want to save and send need to be .PDF

I ve done this test workbook with 3 workers. But i have now 100 and always increasing

Hope to have your help asap

Thank you

.
Edit this line :

Please Login or Register  to view this content.

To :

Please Login or Register  to view this content.

Always make certain the workbook and the PDF files are located on the desktop ... or ... you'll need to change the paths in the macro to match the locations of your workbook and pdf files.

Also .. as the present macro is written ... you will need to edit this line as well :

Please Login or Register  to view this content.

The C10 should match the last used row in column C. For instance, if your rows extend down to Row #2500 ... then it would be C2500.

Originally Posted by Logit

.
Edit this line :

Please Login or Register  to view this content.

To :

Please Login or Register  to view this content.

Always make certain the workbook and the PDF files are located on the desktop ... or ... you'll need to change the paths in the macro to match the locations of your workbook and pdf files.

Also .. as the present macro is written ... you will need to edit this line as well :

Please Login or Register  to view this content.

The C10 should match the last used row in column C. For instance, if your rows extend down to Row #2500 ... then it would be C2500.

But how do i create each PDF and for each sheet?

.
Use the same code you have that creates the PDFs. Just make certain they are saved to the Desktop or whatever location you desire.

Hello Logit,

Although to create 100 pdfs, i need to create 1 by 1?

Is there a way to loop them through all sheet's ?

.
Yes.

What code are you using ?

I just have this code on this project:

Please Login or Register  to view this content.

I need the code that Creates the PDF with the name "NUMBER OF EMPLOYEE & DATE.PDF" And Then send that e-mail with that file.

.
This will create the PDFs :

Please Login or Register  to view this content.

We can add some code to the above so it avoids making a PDF file of unwanted sheets. Will need to know the names of those sheets.

Worked perfect, I have in this problem one more limitation i attached.

I Export an excel data base and then,
1st filter to "PARA ANALISAR"
COPY COLUMN B/S/T/U to the end of the sheet name accordingly.

Please check file in attach if you can help me out

@Logit is there a way to do this for a big range of sheets?

Right now they are around 100, i mean... probably need to filter then copy visible cells then find worksheet and first empty row and paste?

Hello @Logit,
Can you give me some help regarding this copy paste multiple sheets?

Give this code a try

Please Login or Register  to view this content.

Hello mate
I run your code with your file and does not work

"run-time 1004"

I have the file attached working properly
- Need to create a folder in "desktop/RECURSOS HUMANOS/
- Put the excel file inside

Now i need to put the analysis working, copy and paste after filtering to each worksheet according to name

Here is an updated version. Note, I only made changes to the SendEmailfromOutlook code. I did not touch the PDF file create process. What line is highlighted with the code error.

Please Login or Register  to view this content.

I've tried that.

I don't need to send that on the body of e-mail.

I need to paste it on EACH sheet of each worker, and then send the full history

almost there, but i need to add the new lines to the history and then send only the attach

Try this change

Please Login or Register  to view this content.

Hello mate,

It does shows me better but still not correct

I want to only put the orange rows there (no header) and right after the last filled row

hopefully this works

1. I added the the pDF create feature into the Outlook create code, it will all run faster that way. You no longer need the SavePDF module. I renamed the Outlook code.
2. If no information, no headers will be added
3. The temporary sheet will continue to be created and deleted, it's easier to manipulate the added information this way.

Thank you my friend, for my first impression it works perfect. i adjusted to my file and all seem to work perfectly

Originally Posted by maniacb

1. I added the the pDF create feature into the Outlook create code, it will all run faster that way. You no longer need the SavePDF module. I renamed the Outlook code.
2. If no information, no headers will be added
3. The temporary sheet will continue to be created and deleted, it's easier to manipulate the added information this way.

Hello maniacb,

Really sorry to bother you again, i am trying to use your file but is is giving me error 1004

Can you open it and try it please?

The error appears because the directory path may be incorrect. Change the current path(the portion in red)

Please Login or Register  to view this content.

To an actual path on your computer

Thank you very much. already working

What changes are taking place in what sheets? Data Base Sheet has a number in Column B, no date. Can you share the updated sheet and tell me what is the error?

I updated the main module to show column H instead of column B, and hide line with blanks or 12 AM(0:00) in columns S/T/U. Let me know how it works for you.

Please Login or Register  to view this content.

Hi maniacb, is worked nicely,

Although on the worker sheet it appears with 00:00, can we have it blank where it is 00:00 ?

Thanks for your time

Use this updated code

Please Login or Register  to view this content.

At the top of the code, after the Dim lines, add the following line.

Please Login or Register  to view this content.

This will allow the software to run on all the names that don't have an error

Yes, indeed that can be de reason, how can we turn that around to analyze to match the 31 st caracters

AT worksheet "Data base" i have the Column F with every worksheet with only 1st 31 caractacters if that helps..

See updated post 42 for code to resolve issue

This code has correct path and updated code

Please Login or Register  to view this content.

Gives me error 1004, file should be open

But i have no PDF open, so error must occur

I found a few more places where the 31 character limitation has to be changed.

Please Login or Register  to view this content.

Hi maniacb ,

Right now everything seem to be 100% , received 84 emails and each one with an attach.

Thank you very much

Hello maniacb

In my desktop it worked perfectly, i put inside another computer with another excel version where i need to run the office and gives me an error. Is there a workaround for it?

RafaelPresa123, go ahead and start a new thread like FDibbins recommends. You’ll get more eyes on the issue. Make sure you list the new excel version and the version it worked on. List the code/file as well or at least reference this thread. I will help as much as I can. I don’t have an answer as to the issue right now.

You can change sheets.count to 2 and it should continue to work.

Not sure how it can be executed without depressing send, but this code will ask if you want to send the emails. Hopefully this will prevent any more unwanted transmissions.

Please Login or Register  to view this content.