Sending e-mail, copy the direct recipient cell

[marreco]

I need a code to insert into a macro that I use ...
I would like that when clicked the button, the active sheet (PDF) was sent directly to the email that the former cell (W6). this phone I use VLOOKUP to automatically fill in the email client according to the database.
he is working to convert to PDF and opening the window sending the email.Gostaria only add code to populate an email automatically.


I am using the code below:

Please Login or Register  to view this content.

Thank you!!

[marreco]

Hi.
anyone have any suggestions?
Thank you!!

[prabhuduraraj09]

Hii marreco,
pls clarify, you need a code to pickup email id that is reflecting in W6??

[marreco]

Hi.
Email is the W6 in the cell, then the code has to take this cell and send to the recipient.

[marreco]

hi.
Any idea?

[prabhuduraraj09]

Apologize that i stuckup with my work here.....

In your code pls inlude

replace you To code with below

While executing the code, whatever the mail id given in W6, will be picked by outlook as To address

Hope this helps...

[marreco]

Hi.
where should I put this line of code?

[marreco]

Hi.
someone could help me? Thank you!