• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Email from Excel

T

TonyNZ

Member
Hi

In the dummy sample file attached, there are 2 worksheets named week wise i.e. Week of 29 July, Week of 5 August. In the actual document, there will be about 10 tabs belonging to each week. Each individual week will have data date-wise i.e. Mon 29 July, Tue 30 July, till Fri 2 Aug.

Requirement: At the touch of a button (e.g. Email Monday in the sample file) all the data under Monday only should be emailed as a pdf file. Similarly, when button Email Tuesday is clicked, all the data under Tuesday only should be emailed as a pdf file.

However, there is a catch. Before the data is emailed, all names of the volunteers must get deleted.

I have recorded Macros for Monday and Tuesday. These work well. (For Wed, Thu and Fri, I will record it later).

I want to create a Template, containing 10 tabs. Every time the next 10 weeks is to be prepared this template will be used.

Issue: In the template, how the macro could be modified so that, instead of the reference to the particular week (as in the sample sheet i.e. Week of 29 July as an example), it could say Active Sheet. Thereby meaning, the Monday macro gets activated for any active sheet only. Similarly, macro gets activated for any active sheet only when activating Email Tuesday button.

I hope I have made myself clear.

Any help would be greatly appreciated.
Regards
t
 

Attachments

  • Weekly Planner.xlsm
    23.1 KB · Views: 4
TonyNZ
Why ...?
Why every day has own bordered data and every week of sheet?

Hmm? Every sheet has many rows...
Could You fill those datas to 'table' , 'pick' needed dates data to 'daily-table' and next email that daily-table ?
Hmm? ... You would like to email without names ... then no need to 'pick-up' those names.
Then ... less less macros ... hmm?
 
Thanks. This is the conceptual dummy sample sheet of actual what I work upon. The only difference is that in the actual each day has about 40 rows and 5 columns of data. Activity remains the same but other info like volunteers names differ subject to their availability. and then there is a Comments column too. Taking the 'table' route won't work, I think unless I re-format before emailing. make sense? If the macro could be modified just to pick data for the desired day from the 'active' sheet only, then that's the solution.
 
TonyNZ
If Your sample files layout is different than Your actuals ... then You'll get more challenges!
What was Your point? You could 'select one row (or even column) - move its needed data as needed to range which You would email.
Why need many 'weekly' sheets?
 
Why need many weekly sheets? Well I don't Have any way out as that's what I have to work from. This won't change I mean the current structure of the document. Unfortunately though. So trying to find a way out in the given circumstances. The data table solution won't work. The actual document has headers work merged cells hence limitations to work in the data table options. The document that must go out should be the replica copy of the actual document but without volunteers names. Sorry if its too confusing
 
Yeah I know sometimes hands are tied and we don't have much wiggle room. Thanks for your help though. I'm sure there will be answers coming.
 
You must log in or register to reply here.
Back
Top