Export to PDF Email to Multiple Addresses.

[Slamat Ale]

* Need to Change "A1" Cell till last serial number in address sheet, & Selection of "B4: R19" send email via outlook as PDF format.
* I have approx 73 email address, I lookup all data from serial Number. When Serial Number change all data change.
* Need loop until Last serial number appear.


You can download this file from https://1drv.ms/x/s!AuzvYK0snzo7hzHw-JztJRpht3Xn
Please solve my prob.

 

[Monty]

Hello Slamat.

Welcome to chandoo forum!

Working on this, i may need to ask some questions.

Question1

Do yo wanted to store these Pdf's in a folder while sending mails?

 

[Slamat Ale]

No, brother, just email & delete.

 

[Slamat Ale]

Thank you so much Monty for reply, any other question Monty??

 

[Monty]

Your Gmail id slamatale@gmail.com is this correct..Let's test sending pdf to your email.

 

[Slamat Ale]

Yes brother, my email id slamatale@gmail.com is correct.

 

[Slamat Ale]

This id i use for checking, every serial number have different email id.

 

[Monty]

yes ofcourse as of now,am just all the emails to this email...Check and confirm if you are able receive emails sent via VBA now.

 

[Slamat Ale]

Great, Thanks alot brother, i recieved but there is page break in every file, is it adjust in one page only?

 

[Monty]

Excellent, that can be manged, it was only a test email....Let's try one more time sending all mails, You should be receiving 73 emails.

 

[Slamat Ale]

can you send this coded file to email?

 

[Monty]

Of Course am attaching your file now.Onces you confirm everything is fine with the output.

 

[jamesexcel1970]

Hey little Champ.

i must say you have great patience in helping other's though you are not paid..God bless you..I should like this.

 

[Slamat Ale]

Something wrong, check your email brother.

 

[Monty]

What was that error...I can see different attachments for email...Let me know.

 

[Monty]

Yes something wrong, Apologies for that..Give me some time

 

[Slamat Ale]

Not apologies Sir, Thanks for giving you precious time brother.

 

[Arpanakumar]

Hello Slamat.

Welcome to chandoo forum!

Working on this, i may need to ask some questions.

Question1

Do yo wanted to store these Pdf's in a folder while sending mails?

Is it possible creating PDF and sending as attachment, we are making as BMP file and sending for 100+ email address in lotus notes and need to make it to outlook now, trying my level best with this forum.

 

[Arpanakumar]

Am waiting for the output, i may need this but will try from end before you!

 

[Monty]

Am waiting for the output, i may need this but will try from end before you!

Yes possible dear...Going with unknown errors with this...But let's not give it up.

 

[Monty]

Slamat Ale

Finally! Waiting is over.

Please find attatched for Macro file and change path as per your requirment.

Only one click to send unlimited mails

Any challenges, shoot the questions..Happy to help you!

 

[Arpanakumar]

Hey Montyyyyyyyyyy.

I was just running this file and work excellent, just a click of a button sending 70 emails with PDF..Thank you so very much.

I will ammend into my requirment.

 

[Monty]

Arpana.

i am glad that i could be of some help.