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:
Thank you!!
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi.
anyone have any suggestions?
Thank you!!
Hii marreco,
pls clarify, you need a code to pickup email id that is reflecting in W6??
Hi.
Email is the W6 in the cell, then the code has to take this cell and send to the recipient.
hi.
Any idea?
Apologize that i stuckup with my work here.....
In your code pls inlude
replace you To code with belowHTML Code:
While executing the code, whatever the mail id given in W6, will be picked by outlook as To addressHTML Code:
Hope this helps...
Hi.
where should I put this line of code?
Hi.
someone could help me? Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks