User Profile
Matt_MobiusNZ
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Printing a Chart Sheet in Excel scaling wrong
A client showed me an issue I can easily duplicate - I initially thought it must be a bug in Excel but if it is its been there a long time as I tried rolling the version of C2R Office 365 back years to a version I had the command line for (A december 2021 release) and it made zero difference. Basically they have a sheet of data. If they highlight the data and right click the Sheet link at the bottom and select Insert and chose chart it adds a new sheet with the new chart. The problem is if they print the chart sheet the scaling is completely wrong and they'll only get 30-70% of the chart. The scaling option etc are all unavailable when they create the chart this way. Its not printer driver related as the same thing happens printing to the Microsoft Print to PDF driver too. There are two ways to "fix" it - One is to add a new sheet and copy and paste the chart and then it behaves perfectly. Alternately if you go to the Page Layout tab on the toolbar and click the Page Setup button at the bottom that goes to the old page layout and tweak the paper size (even changing it to the wrong size and then back) it then seems to print ok. I can repeat this behavior simply typing random numbers into a new sheet, highlighting the figures and doing the Sheet right click, insert chart and it won't print correctly. If they just make a chart on the current sheet it works too. If I do the same on Excel 2010 it works perfectly so it seems to be an introduced "bug" that potentially isn't encountered often due to the way people use Excel. I had never inserted a chart as a separate Sheet in this way before. This seems to be broken behavior in Excel so even though I have a "work around" I figure its worth reporting as it seems it might be a legacy feature that is a little broken.365 Distribution lists for media mailing lists
I have a client with an aging Exchange Server. For years they've run regional distribution lists for their 3.5K members. Basically we have an organisational unit for each region and then contacts in each OU for each member. Then we have dynamic Distribution lists that include all contacts in Each OU. From there we use the Limited Allowed senders to allow external authorised senders to email the regions so the server will send their email to all members in each region. It looks like we can do similar on 365 - Make a bunch of contacts and add them to distribution lists. From what I've read each address book distribution list is only counted as one recipient for the sender. What are the limits for the outbound mail when sending to the Distribution lists? The most they'd send in a day would be one email to all regions so 3.5K emails. I guess they might very occasionally do it twice to correct an error or something so maybe 7K emails. A lot of the time its just individual regions being emailed. Will this work - I've found lots of talk of the limits but not really a definitive answer for sending to distribution lists. I've suggested Mail Chip but they really want to use existing mail clients to send the emails due to user tech limitations and its member information and isn't related to selling or marketing so they don't require the click / read information of something like mail chimp. Does this sound like it'll work - We'll then be updating the lists from time to time pragmatically (Powershell or API's) to keep them relevant to their membership database. Any help greatly appreciated as what I'm finding in documents online is often contradictory.Re: 365 Distribution lists for media mailing lists
True I guess that would at least test the truth of the Distro List = 1 Recipient bit. I've created a distro list containing external contacts and allowed certain external senders and that worked that I could email the distro list from my Gmail and the email went to the two external contacts ok. I suppose once I know about the distro list = 1 recipient thing there is enough to indicate that it will be fit for our purpose. To the client it seems like a lot of emails but in the scheme of international companies and marketing its actually a pretty small number.Re: 365 Distribution lists for media mailing lists
I saw that very document. The problem is that indicates that we can send an email to a distribution group and have Microsoft deliver to the members and it only counts as one recipient. I think I can take from them that a group with under 1000 members is fine - There are message size limits which is ok. From there I can see it looks like each person can send to up to 10,000 recipients per day but 1000 at a time (Unless is a distribution group in which case its counted as 1 receipient???). It seems like I'm just going to have to try it but that requires importing thousands of contacts into my tenancy to test and sending them all a test message and checking delivery reports as for me there is far too much ambiguity. Then it closes with the bit you have about third party providers. So that indicates they discourage using 365 to send newsletters which in a way this customer is but its a Not for Profit organisation and the membership is tiny by US standards so I figure they can. Sometimes some cut and dry examples would be useful. Has anyone actually done this successfully.
