Tag: Microsoft

Recipient of weekly reports in Microsoft Family

I have a typical Microsoft family based on four separate Microsoft accounts:

  • two accounts for parents,
  • two accounts for children.

Both children have Weekly Activity E-Mail reports enabled.

We live in Poland and Polish is our native language, but for the sake of the Microsoft family everything is set up in English (the page itself is loaded in English) as we (Parents) have all our browsers installed in English and English as the language Native language.

Every week I receive a report in English with my name in the beginning. My wife gets no reports.

The best part is that Our children also get these reports:

  • Both receive each weekly report in two copies.
  • The first copy is in English and bears my name.
  • The second copy is in Polish and bears the name of my wife.

What do I miss here? Why do children get reports about their activities? You should not think so. If they should (according to Microsoft) why these reports are titles with the names of the parents.

I did not specify who should receive reports, when and in what language. I've just created a Microsoft family that consists of two adult Microsoft accounts and two Microsoft accounts for children. And I've checked the button for each child to create weekly reports.

Is that a mistake that we get all of these reports in a weird combination? Is there an option to control this feature (ie, to decide who and when to receive these reports and, most importantly, block the reception by children)?

Can not display a QR code when merging is used in Microsoft Word (DISPLAYBARCODE / MERGEBARCODE)

I want to use the Mail Merge feature in Word to create name tags for a conference. (Office 365, Word as a local desktop app on Windows.) The data is provided in an Excel file. One of the fields should be displayed as a QR code.

I have found documentation on the DISPLAYBARCODE and MERGEBARCODE field commands, as well as some useful instructions. I followed this:

https://hubpages.com/technology/Mail-Mergeable-Barcodes-in-Microsoft-Word-2013-aka-Bar-Codes

In the screen shots below, you can see what it looks like when (a) internal field functions are displayed (b) internal functions are hidden without previewing the results and (c) results are previewed.

Enter image description here

(a) is just like the statements in the link – with the field expression { DISPLAYBARCODE "{ MERGEFIELD QRcode }" QR s 100 q 3 } (b) displays the QR code. But in (c) (or when I choose "Finish & Merge") I get an error message: "Data length is not supported by the current type".

The QR data is empty – it does not seem possible to create a MERGEFIELD reference in DISPLAYBARCODE. But it should work according to the above link – and the QR code is displayed in (b).

There are other links that recommend the use of MERGEBARCODE:

Use a merge field as the data for a display bar code field

https://support.office.com/de-de/article/field-codes-mergebarcode-812fc43f-cb53-4782-8f9f-290ed08d34f3

I tried – with the field expression { MERGEBARCODE QRcode QR s 100 q 3 } It is accepted (displayed in view (b) as "QRcode QR Code") but nothing is displayed in view (c) (or when "Finish & Merge" is selected).

I would be very grateful if you can help me! 🙂 Maybe I just have to adjust the syntax. But I've tried all the alternatives that come to mind …

outlook.com – How do I choose which font to use in the Font Selection drop-down menu in the Microsoft Outlook Web App?

How do I choose which font to display in the Font Selection drop-down menu in the Microsoft Outlook Web App?

I would prefer to be able to have a small list of available fonts instead of scrolling through a long list of fonts that are mostly never used:

Enter image description here

sharepoint online – Providing Microsoft teams from the Azure feature via PNP powershell

I provide teams via PnP Powershell and scopes are needed. The only way to get Scope is to log in interactively. This means (which I think) that you can not use Apply-PnPTenantTemplate to deploy teams from, for example, Azure functions or other background tasks without interactive logon.

Is it possible to deploy teams using "Apply-PnPTenantTemplate" from, for example, Azure features or other background tasks without interactive logon?

Microsoft Excel – Links related data points on different (but consecutive) lines into a single line

I have a CSV record that is generated electronically. However, because the packets have discrete data points, they are in different rows because of different timestamps. The goal is to find out.

Spread out data

I want to reduce the data so that all related values ​​are within the same row within a given timeframe. I do not care about a few milliseconds. For example, lines 2 through 8 may all be on the same line, and then lines 9 through 14 may be created a new line. In this sense, one of the columns could be the "master" where a number arrives. It indicates that a new line should be captured. If there are multiple values ​​for the same field in this cadence, the last value is preserved.

For example, I might find that "Speed" is master, so in this case, lines 5 through 17 would be together. There are two values ​​for the battery power in lines 9 and 15, I could just discard line 9.

Is there a way to do this in excel via pivots or a bucketing system, through Excel scripts, or is there a more effective way?

sharepoint online – Authenticate yourself to Microsoft Teams

The following command attempts to connect to Microsoft Teams with Azure AD authentication for apps only: 

Connect-MicrosoftTeams -ApplicationId GUID -CertificateThumbprint "thumbprint" -TenantId GUID

However, the error message "The key does not exist" is displayed.

The same thumprint works well if I use it Connect-PnPOnline,
Any idea what I'm doing wrong?

Thank you very much

Microsoft Excel – Complex conditional formatting

I am a CPA with a lot of Excel experience but can not seem to find an answer to this (my) question. Is there a way to apply conditional formatting to the following example:

EXAMPLE: I have the formula = sum (B4, C28, A32, B40) —> Is there a way to apply a conditional formatting rule to cells B4, C28, A32, and B40, which automatically highlights the cells in which they are are the formula used?

^ This would help enormously with a bank balance that I carry out. Instead of highlighting manually. There are many cells for which I would have to do this manually. I firmly believe that polling is as automated as possible (in fact, most of my polls are simply a drag-and-drop template that automatically identifies most polls).

Microsoft Excel – Merging consecutive rows to render data from the same record

I was hoping someone could help with Notepad ++ or Excel / VBA.

I have the following data (sorry, I could not attach the file), but if the sample data is copied to Notepad ++, it should have 12 rows of data.

Suppose I use Notepad ++

Lines 4,5 and 6 come from one record, but are split into multiple lines

Line 7,8,9 are individual records

Lines 10, 11, and 12 are from one record, but split into multiple lines

Could someone please help me or inform me of a quick way to display a row of records so that I can analyze the data as I am currently in danger of losing the data integrity of the records.

Any help would be appreciated.

thanks

Finance ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Account Name, Serial Number, Customer Number, Creation Date, Update Date, Number of Digits, Units of Measurement, Currency Free Descriptor, Size, Frequency, Return, Object Billing Size, Billing Size Category, Logger (W), Logger (NW), AMDX, AMDY, RAD Location-Free Descriptor, RAD Outreader GISX, RAD Outreader GISY, RAD Outreader Location Free Descriptor, RAD Handling, RAD Location Code, Combo RAD Flag, Vol, Address – Secondary Addressable Object, Address – Primary Addressable Object, Address – Address line 1, address – address line 2, address – address line 3, address – address line 4, address – address line 5, address – postal code, address – PAF address key

Account_name, 94T034862,9911637482NUM19,2014-11-19 ,, 5, pound ,, 15, B, 100, 00, 15, 15, 0, 0, 5, 55, 55, 110, 98, 66, 0, "PANEL RHS OF COLUMN NO CHILLERCABS. BACK OF THE BOX BEFORE THE BAKERY.
", 82644.0,5186.0, PANEL RHS OF COLUMN NO CHILLERCABS. BACK OF SHOPS BEFORE BAKING.
", TAX, I, 0,30,0 ,,,, 936065186 ,,, 918, SWINGFORD RD ,, MENFIELD, MIDDX, YYY XX1,
Account name, 94T034868,9911429278NUM17,2014-11-07 ,, 5, pound ,, 15, B, 100,00,15,15,0,0,525425,0,178736,0, CELLAR.TEL.0171 9121401,82644.0 , 5186.0, CELLAR.TEL .0171 9121401, TAX, I, 0,158,0 ,,,, 216031935 ,,, 147, SUPER THE RD ,, MONTY ,, YYY 9XX2,
Account_name, 94T034871,9910235259NUM13,2015-01-30 ,, 5, pounds ,, 15, B, 100.00,15,15,0,0,518053,0,174903.0, THIS SECTION OF UNION CT ISV IA ALLEY ON RHS OF NO15 SHEENR D (FEATHERSTONE LEIGH) .. PROCEDURE WITH 30 MTRS ALONG SAME REMOTE TO T / AS & # 39; TEC HISM … MTR UNDER WASHBASIN R / O PREMISES …, 82644.0.5186.0, THIS SHOPPING SECTION OF UNION CT ISV IA GASSE ON RHS NO. 15 SHEENR D (FEATHERSTONE LEIGH). PROCEE D 30 MTRS ALONG GASSE.THENUNDE RARCH.ON.RHS.TO SHOP T / AS & # 39; TEC HISM … MTR UNDER WASHBASIN R / O PREMISES …, TAX, I, 0,37,0 ,,, , 17644552 ,,, 167, UNION PARK ,, BEDMOND, SUNVIL, YYY XX3,
Account name, 94T034887,9910508441NUM12,2014-10-24 ,, 5, pound ,, 15, B, 100,00,15,15,0,0,540456,0,185014,0, CELLAR FRONT RIGHT, 82644,0, 5186,0, CELLAR FRONT RIGHT, TAX, I, 0,105,0 ,,,, 149388560 ,,, 111 SHOP, GUNFERD RD ,, PERL ,, JJJ XX4,
Account_name, 94T034889,9910698216NUM14,2014-11-28 ,, 5, pound ,, 15, B, 100,00,15,15,0,0,525594,0,178188,0, "IN STORES (SPIRITS) UNDER RAIL ACCESS AFTER 12NOON AS KEY TO SPIRIT STORE NOT AVAILABLE BEFORE 12PM
", 82644.0.5186.0," IN STORES (SPIRITS) UNDER RAIL ACCESS TO 12 KEYS FOR THE STORAGE OF SPIRITS THAT ARE NOT AVAILABLE BEFORE 12 KEYS FOR STORAGE
", TAX, I, 0,30,0 ,,,, 64777361 ,,, 286 SHOP, OLD COMPTON RD ,, FETLING ,, YYY XXW,

Microsoft Excel – If the text value is more than 3 times in the range, true / false

In the following example, I want to count all duplicates in the range A2:I2 and if there are more than 3 equal occurrences, true otherwise false, I tried >3Suppose it were true if the number of unique values ​​were greater than 3.

In the figure below, the formula would return true because there are more than 3 text values ​​in the range A2:I2

=SUMPRODUCT(COUNTIF(A2:I2,A2:I2))>3

Enter image description here

Microsoft Office – How do I edit the fields of a heading / outline level in MS Word?

I have a document in Word organized with multilevel outlines using the standard heading styles.

When I create a table of contents, a hyperlink to these headings / contours is created, but usually a field with the name _TOC10001237 is referenced, for example. Each heading / outline level gets its name automatically, but I want to change some of the names of these references from "_TOC10001237" to "_TOCtheNameIwant".

I can not change this by switching the fields on and off. How can I do it?