I have a multipage workbook. What I am wanting is that when a button is clicked, for it to open up the save menu to save one specific page into PDF (worksheet called "Absence Memo"). Once saved, I want it to embed the same page into an email.
Is this possible?
Please let me know if you require any more information.
Embed in an email? or attach?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
I would prefer it to be embedded.
Would it also be possible to do it so when it opens up in Outlook that another worksheet automatically prints (worksheet "Wall Memo")?
Perhaps embeding as html then? I guess I'm struggling with why the conversion to pdf if its going to be the body of an email. If you're using outlook, it will allow embedding images because they are rendered in place, but a I don't know of any way (or reason) to do so with a .pdf filetype.
My reasoning behind it is that we need to have a saved PDF copy of what we sent on record, so I thought it would save a step later on. But if you have another suggestion I am open to ideas!
I think that sounds like a grand idea, but if you want it in a .pdf file format and what it sent via outlook email, it will have to be as an attachment. If you want it to be in the body (where it will have to be saved as an email) then you can do it with html.
Attachment works then.
TryCopy this into a module. You can call if from a button on the page you would like to send. I have placed ''' where you can enter the email address, subject, and body of email. Will the email address me constant?
Please Login or Register to view this content.
Please Login or Register to view this content.
The email addresses will not be constant. The user would have to manually enter the contacts.
I tried entering the code, but I got this error message:
error1.JPG
It might have gotten pasted into a funny spot. I looks like you have an "email sub" right above it that doesn't need to be there. Just copy and paste the code above into its own module. When that is complete assign the button to this macro: "Workbook_To_PDF" not to the function. Do you want the user to pick the email address from outlook? Or will it come from a cell etc on the sheet?
They will be picking their own email addresses, it will not be coming from the excel sheet. I tested it out, but I see it publishing the spreadsheet, and then nothing happens after that. I noticed a few spots where it says "send automatically"... do I need to remove that code so I can enter in email addresses?
Change this true to false. It should be the only one you need to change.Please Login or Register to view this content.
Thank you so much for all your help today. This should be my last question. I see it pdf's the whole workbook. I am really only wanting one page of that workbook pdf'ed. I have gone through the code to figure out where I change this, but its not working. Do you mind pointing me in the right direction?
Thanks a bunch!
Is it always the same worksheet in the workbook? (i.e. the one with the button) or does it vary?
I will always be the same
Can you attach your work? It will be easier for me to edit what you have rather that try to add on it without seeing it in context.
See attached.
Thanks
Alert Chart - 2012-13.xlsm
Attached: Solus Alert Chart - 2012-13.xlsm
Awesome.
Thanks so much for all your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks