file id# XXXXX
http://wikisend.com/download/321898/gross pay report 2013.xlsx
I went ahead and went through every worksheet and put in the formulas manually. A pain in the butt but i really wanted to get it done. For future reference if you could give me a shortcut for that i would appreciate it! what i need next is to create a macro where every worksheet has a button that i can hit and it would email that single worksheet to the employee listed on it. i would be using outlook for this. please let me know if you can help. feel free to call me at XXX-XXX-XXXX as well. thanks-
whatever you recommend i guess. while we are at it....can we change the worksheet tab name to be whatever is entered in the "employee name" cell?
Ok here you go
To run the macro click the button on the Summary sheet. Every time you run the macro it deletes any existing employees sheets and creates a new set of sheets for all the employees listed on the Summary sheet
Please note that since there is a macro in the file you need to make sure that you have your Excel Options configured so that macros are allowed to run, otherwise nothing happens when you click the button. If you need assistance in this regard please let me know,.and provide the version of Excel you are running
Hope this is ok. If you have any further questions do not hesitate to ask
Thank you for rating the answer "Excellent" or "Good" if I was able to answer your question
i cannot seem to open this link. can you help with it?
Try this link which gas a zipped file
Steve here is another link with unzipped file if you're still not able to download the file
Let me know if you still need any assistance
*** RATING REQUIRED ***
hi john-i was able to download the file and it looks great. i was just hoping we could add another macro where there is a button on each worksheet that allows me to email that single worksheet through outlook to the employee email address listed on that worksheet. is this possible?
Great. Glad it worked
If I understand you correctly you want that sheet itself to be sent as a file attachment, and not as text data in the body of the email. Correct?
sending as a pdf attachement would be fine. i think that would be the best way.
i think i would prefer the pdf even if it requires the extra step. the reason is i dont want my sheet manipulated in any way and the boys would be able to do that in excel spreadsheet form. if this can be done early today that would be awesome. that way i could give it a go later today for this friday's pay run. man you were answering pretty late last night! dont you sleep? i really appreciate it!
Ok will do it in pdf..
Should have it ready shortly. Meanwhile thank for remembering to rate
Give me a few minutes to finalize the code and upload the file....
Please go ahead and test it and let me know if it needs any tweaking
i tested it and it looks like emails are being sent without the attachments.
hmm.. I am getting the pdf attachment on my end
not opposed to letting you plug into my computer to have a go at it. might i need to configure outlook settings differently to allow attachments to send via macro? just to be clear...it is only that single worksheet being sent to the email address listed on it rather than the who workbook right? that would not be good! if you want to remote in my computer give me a call at XXX-XXX-XXXX and tell me what to do.
so then a setting on outlook? i tested it again and emails are being sent just with no attachments.
sent. i am not getting the prompt that asks "are you sure you want to send?"
can you try the excel format. that will have to do.
just turned off microsoft essentials and it looks like the pdf is being attached now! is there a way to keep essentials on and still send?
on second thought...only one pdf was attached and subsequent emails were sent with no attachment. please send me the excel attachment format when you can. it must be easier that way, thanks!
The sheet looks great and in excel format I seem to be able to email everything fine. Still, and now I am being a total pest, I would love to send in PDF format for the reason I have already stated as well as I just think that format is more professional. Is there a way we can work on getting over that Outlook block that is stopping me from doing that?
Well done on this workbook by the way. I showed my wife it last night and she was as impressed as I was at all those worksheets being created at the click of a button. Good stuff!
i understand. if i send you a workbook where pdf's were successfully sent would you be able to decipher that code and see where we are off with our workbook? if i have to be charged for a new case i guess i am alright with it.
wikisend file id 417818
i was able to send all worksheets in pdf form when i sent this. thanks-
I had someone help me come up with that workbook (I believe it was this site actually) and they created a macro that you see on the summary page. i would hit that after creating the worksheets and all worksheets would begin to send in PDF format to the email addresses listed. back then i would alter data on each worksheet and it would transfer to the summary page. what you created is the opposite of that, (i enter data on the summary page and it transfers to the individual worksheets) which it much easier for me. hope this helps!
is there a better way to send you this file?
SAME FILE!!!Please make sure you try to download the file yourself before sending me the ID
Or you can use this file sharing site instead
dont know why that happened. here is what i wanted you to see.
i downloaded it myself and it is the one. thanks=
Will send you the test macro as soon I have it ready
Ok here is the test file
First save the file to your desktop then close all excel files before opening this file
When you click the button, the macro first brings up a message telling you where the pdf file has been saved on your system so you can go there and check it if you want to see it.
Then it launches the Outlook message window so you can see the actual email with the attachment before sending it. You can then manually send it from that window
Please go ahead and test it and let me know what happens
the worksheet with my email address worked perfectly. i received the pdf and it looks great. your worksheet would not send and said that macros may be disabled.
Ok please try this file
Try sending both emails and let me know
both worksheets seem to have been emailed just fine. we are close!! if you could integrate that macro into the exsisting workbook you created for me i think we will be golden.
i should be fine without that. thanks-
Here is the full version
Hope it's ok. Please feel free to get back to me if there are any issues or if you have any questions
looks like we are a go!!! you, my friend, are talented with those darn spreadsheets!! thanks so much for your help with this. it really make my life easier (for payroll at least). what on earth will you do with your time now that this project is complete?? thanks john.