Hi, I'm trying to create a macro that mails a PDF of the active sheet, attaches another file, and copies certain cells into the body of the email. I can do all of these individually (thanks in large part to Ron deBruin's site), but I can't figure out how to combine all of these elements. Any ideas? Thanks!
Hi supcussy
Attach what you have, including code...perhaps we can sort it out.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
The main code I've been using is the create and email PDF code. I'd like to add to it so that I can have the body of the email be a certain range of cells, and I need to attach an additional separate file.
-----------------------------------------------------
Please Login or Register to view this content.
Hi supcussy
You indicated you have thisShow us what you have (the actual code with cell/range references)...perhaps we can help. Sample copies of your files would be much better.I can do all of these individually (thanks in large part to Ron deBruin's site), but I can't figure out how to combine all of these elements.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks