Microsoft Office wuxuu^{(Microsoft Office)} kuu ogolaanayaa inaad daabacdo baqshadaha si gaar ah ama sida isku-darka boostada. Tani waxay si cajiib ah ugu qiimo badan tahay ganacsiyada u baahan inay ku daraan summadaha iyo walxaha kale ee gaarka ah liiska boostada ee ballaaran.

Waa kuwan sida aad ugu daabacan karto baqshadda Microsoft Excel . Xusuusnow^(Remember) inaad u baahan tahay Microsoft Word iyo Excel labadaba si aad tan u samayso. Habkani waa inuu shaqeeyaa iyada oo aan loo eegin haddii aad isticmaalayso suudhka Microsoft ee Windows PC ama Mac .

Tallaabada 1: Samee Liiskaaga Boostada

Tallaabada ugu horreysa waa in la abuuro liiska dadka qaata kuwaas oo aad u diri doonto boostada. Waxaad ka boodi kartaa tallaabadan haddii aad u baahan tahay inaad daabacdo hal ama laba baqshadood. Si kastaba ha ahaatee, tallaabadani waxay muhiim u tahay kuwa ku shaqeeya liisaska waaweyn ee waraaqaha.

Si aad u abuurto liiskaaga boostada:

1. Fur Microsoft Excel.
2. Samee xaashi cusub oo leh tiirarka soo socda: Magaca koowaad^{(First Name)} , Magaca qoyska^(Surname) , Ciwaanka^(Address) , Gobolka^(State) , Dalka^(Country) , Koodhka Boosta^{(Postal Code)} . Soo rar^(Import) xiriiradaada xaashida, ku dar macluumaadkan tiirarka u dhigma. Dukumeentigani wuxuu noqon doonaa liiskaaga boostada.

1. Xaqiijinta ciwaannadaada tallaabadan waa muhiim si looga fogaado in waqti iyo lacag lagu lumiyo daabacaadda xog duug ah ama khalad ah.

Tallaabada 2: Nakhshad baqshaddaada

Marka xigta, waxaad u baahan tahay inaad ku diyaariso template baqshaddaada Microsoft Word . Kani waa dukumeentiga aad u dejisan doonto si aad ugu shubto ciwaannada qaatahaaga marka aad si toos ah u daabacayso.

Si taas loo sameeyo:

1. Ku fur dukumeenti maran Microsoft Word .
2. Dooro tabka fariimaha.

1. Guji baqshadaha

1. Hadda cadee cabbirka xaashida baqshadahaagu noqonayaan. Si aad sidaas u samayso, dooro sumadda Horu^(Preview) -u- eegga.

1. Tabaha Bakhshadda ^(Envelope) Options , dooro liiska hoos-u-dhaca ee cabbirka baqshadda .^(Envelope)

1. Dooro cabbirka baqshadahaagu u baahan yihiin inay noqdaan. Eraygu^(Word) waxa uu ka kooban yahay cabbirrada baqshadda ugu caansan, laakiin waxaad dooran kartaa kaaga adiga oo gujinaya Cabbirka Gaarka^{(Custom Size)} ah .

1. Marka xigta, dooro Font… oo ku xiga sanduuqa ciwaanka Bixinta ama Ciwaanka ^(Delivery)Soo celinta^(Return) si aad u dejiso farta aad rabto labada ikhtiyaar.

1. Dooro OK.

1. Talaabada ugu danbeysa waa in lagu daro calaamadaynta iyo walxaha gaarka ah haddii aad rabto. Si aad sidaas u samayso, dhagsii ku dar^(Add) dukumeenti Tani waxay u furi doontaa baqshadda sidii dukumeenti Word ah oo joogto ah, markaa u tafatir sida caadiga ah.

Fiiro gaar ah: Waxaad isticmaali kartaa muunad ciwaanka ku jira sanduuqa qoraalka cinwaanka bixinta si aad u aragto sida baqshaddaadu u ekaan doonto marka la daabaco. Si aad u aragto baqshaddaada, dhagsii Natiijooyinka Horudhac^{(Preview Results)} ee ribbon.

Tallaabada 3: Deji Quudinta Daabacaadda

Talaabada xigta waa in aad u sheegto Microsoft Word sida uu u shaqeeyo feedhahaagu^{(how your printer feed works)} . Tani waxay hubinaysaa in baqshadahaaga si sax ah loo daabici doono, iyadoo dhammaan walxaha ku jira ururka saxda ah.

Si aad u dejiso quudinta daabacaha:

1. Guji Fariimaha> Baqshadaha.

1. Dooro Ikhtiyaarada

1. Guji tab Xulashada Daabacaada.

1. Daaqadda habka quudinta^(Feed) , dooro hanuuninta sida baqshaddaadu u geli doonto daabacaha. Waxaan kugula talineynaa inaad doorato habka uu baqshadda xudduudaha u yahay cidhifka saxaarada quudinta, maadaama ay kuu fududayn doonto inaad bakhshadda ku riddo daabacahaaga. Ogsoonow in ciwaanada geynta iyo soo celinta ay si khaldan u habaysan doonaan haddii baqshaddaada aan si sax ah loo dhigin.

1. Dooro Waji^(Face) kor ama Waji^(Face) hoos si aad u qeexdo habka aad kor ugu qaadi doonto baqshadda.

1. Guji^{(Click Clockwise)} wareegtada saacada u dhow si aad ugu rogo nashqada baqshadda sida aad rabto.

1. Haddii daabacaaduhu leeyahay wax ka badan hal saxan oo quudin ah, dhagsii liiska hoos-u-hoosaadka ee ka hooseeya Feed si aad u doorato saxanka saxda ah.

Talaabada 4: Bilow Isku^{(Mail Merge)} - dhafka Boostada oo ku xidh Liiskaaga Boostada^{(Link Your Mailing)}

Waa waqtigii la bilaabi lahaa isku darka boostada. Tani waxay u oggolaan doontaa Microsoft Word inay si toos ah ugu darto magacyada iyo cinwaannada isha xogta liiska cinwaankaaga.

Si taas loo sameeyo:

1. Word , dhagsii Boostada > Bilawga Mailings > Start Mail Merge > Envelopes .

1. Guji ^(Click)tab^(Envelope) Xulashada baqshadda^(Options) . Laba jeer ku calaamadee dejimahaaga sanduuqa wada hadalka baqshadda ^(Envelope) Options kuna dar ciwaanka soo celinta . ^(Return)Marka lagu dejiyo, dhagsii OK.
2. Click File > Save si aad u kaydsato jaantuska baqshadda.

1. Click Mailings > Select Recipients > Use Liis Jira^(Existing) . Haddii aad kaliya ku daabacayso hal baqshad, dooro Nooca^(Type) Liis Cusub^{(New List)} . Sidoo kale^(Likewise) , haddii dadka aad la xidhiidho ay hore ugu kaydsan yihiin Microsoft Outlook sida liiska qaybinta^{(distribution list)} , waxaad dooran kartaa ka dooro Outlook ^(Choose)Contacts^{(Outlook Contacts)} .

1. Dooro xaashidaada Microsoft Excel oo xaqiiji doorashada.

1. Haddii ciwaanada loo baahan yahay in la saxo, waxaad dooran kartaa Tafatirka Liiska qaataha^{(Edit Recipient List)} si aad u bedesho.

1. Guji xannibaadda ciwaanka^{(Click Address Block)} ee ribbon. Daaqaddan ayaa ku tusi doonta sida xannibaadda ciwaankaagu u eegi doono marka xogtaada la geliyo. Dhinaca bidixda waxa ku jira liis ay ku qoran yihiin sida magaca iyo ciwaanka loo daabici doono.

1. Dooro ikhtiyaar, ka dibna dooro OK.

Tallaabada 5: Daabac baqshadaha

Haddii wax walba ay sax u muuqdaan, waa waqtigii aad buuxin lahayd isku darka boostada oo aad ku daabacan lahayd ciwaanada baqshaddaada. Si taas loo sameeyo:

1. Dooro Dhamaystir^{(Select Finish)} & Isku^(Merge) -dhafka , ka dibna daabac Dukumentiyada…^{(Print Documents…)}

1. Ugu dambeyntii, hubi in "Dhammaan" la hubiyay oo dooro OK.

1. Hubi^(Make) in goobaha daabacadu ay sax yihiin, baqshadahaaduna ay si sax ah u siman yihiin ka dibna dooro OK mar kale. Daabacahaagu hadda waa inuu bilaabo daabacaadda baqshadahaaga.

Fiiro gaar ah: Word sidoo kale wuxuu kuu ogolaanayaa inaad abuurto oo aad daabacato calaamado^{(create and print labels)} haddii aad doorbidi lahayd inaad isticmaasho calaamadaha boostada halkii aad si toos ah ugu daabacan lahayd baqshadaha. Waxaad ku dari kartaa faahfaahinta sanduuqa wada hadalka calaamadaha ciwaanka adigoo gujinaya Boostada^(Mailing) > Calaamadaha^(Labels) . Waxa kale oo aad isticmaali kartaa isku-darka waraaqaha^{(use mail merge)} si aad u abuurto calaamado dhawr ah.

Ha iloobin Stamps

Nasiib darro, ma daabici kartid baqshadaha adigoo isticmaalaya Excel oo keliya. Si kastaba ha noqotee, marka la isku daro MS Word iyo Excel , habka daabacaadda baqshadda waa mid aad u fudud. Casharradan, waa inaad haysataa qaybtaada soo socota ee boostada oo aad diyaar u tahay inaad ku tagto wakhti la'aan. Ha^(Don) ilaawin inaad bixiso kharashka boostada!

How to Print on an Envelope in Microsoft Excel

Microsoft Office lets you print envelоpes indiνidually or аs a mass mail merge. This is incredibly valuable for businesseѕ that need to add branding and other custom elements to an extensive mailing list.

Here’s how you can print on an envelope in Microsoft Excel. Remember that you need both Microsoft Word and Excel to make this work. This method should work regardless of whether you’re using the Microsoft suite on a Windows PC or a Mac.

Step 1: Create Your Mailing List

The first step is to create the list of recipients to whom you will send mail. You can skip this step if you only need to print one or two envelopes. However, this step is essential for those working with large mailing lists.

To create your mailing list:

1. Open Microsoft Excel.
2. Create a new spreadsheet with the following columns: First Name, Surname, Address, State, Country, Postal Code. Import your contacts to the spreadsheet, adding this information in the corresponding columns. This document will become your master mailing list.

1. Verifying your addresses at this step is important to avoid wasting time and money printing old or incorrect data.

Step 2: Design Your Envelope

Next, you need to prepare your envelope template in Microsoft Word. This is the document you will set up to populate with your recipient’s addresses when printing automatically.

To do so:

1. Open a blank document in Microsoft Word.
2. Select the Mailings tab.

1. Click Envelopes.

1. Now specify what paper size your envelopes are to be. To do so, select the Preview icon.

1. In the Envelope Options tab, select the drop-down menu under Envelope size.

1. Choose the size your envelopes need to be. Word contains most common envelope sizes, but you can designate your own by clicking Custom Size.

1. Next, select Font… next to the Delivery address box or Return address to set the font you want for both options.

1. Select OK.

1. The last step is to add branding and custom elements if you desire. To do so, click Add to document. This will open the envelope as a regular Word document, so edit it as you would normally.

Note: You can use a sample address in the delivery address text box to see how your envelope will look when printed. To preview your envelope, click Preview Results in the ribbon.

Step 3: Set the Printer Feed

The next step is to tell Microsoft Word how your printer feed works. This ensures that your envelopes will be printed correctly, with all elements in the proper organization.

To set the printer feed:

1. Click Mailings > Envelopes.

1. Select Options.

1. Click the Printing Options tab.

1. In the Feed method window, select the orientation for how your envelope will feed into the printer. We recommend selecting a method where the envelope borders the edge of the feed tray, as it will make it easier to place the envelope in your printer. Note that the delivery and return addresses will be misaligned if your envelope isn’t correctly positioned.

1. Select Face up or Face down to define which way up you will load the envelope.

1. Click Clockwise rotation to rotate the envelope design to your preference.

1. If your printer has more than one feed tray, click the drop-down menu under Feed from to choose the correct tray.

Step 4: Start the Mail Merge and Link Your Mailing List

It’s time to begin the mail merge. This will allow Microsoft Word to automatically add the names and addresses from your address list data source.

To do so:

1. In Word, click Mailings > Start Mail Merge > Envelopes.

1. Click the Envelope Options tab. Double-check your settings in the Envelope Options dialog box and add your Return address. When you’re set, click OK.
2. Click File > Save to save your envelope template.

1. Click Mailings > Select Recipients > Use an Existing List. If you’re only printing to a single envelope, select Type a New List. Likewise, if your contacts are already saved in Microsoft Outlook as a distribution list, you can select Choose from Outlook Contacts.

1. Select your Microsoft Excel spreadsheet and confirm the choice.

1. If any addresses need to be edited, you can select Edit Recipient List to change them.

1. Click Address Block in the ribbon. This window will show you how your address block will look with your data inserted. The left-hand side contains a list of options for how the name and address will be printed.

1. Choose an option, then select OK.

Step 5: Print the Envelopes

If everything looks correct, it’s time to complete the mail merge and print addresses onto your envelopes. To do so:

1. Select Finish & Merge, then Print Documents…

1. Finally, make sure “All” is checked and select OK.

1. Make sure the printer settings are correct, and your envelopes are correctly aligned then select OK again. Your printer should now begin printing your envelopes.

Note: Word also allows you to create and print labels if you’d rather use mailing labels instead of printing directly on the envelopes. You can add details in the address labels dialog box by clicking Mailing > Labels. You can also use mail merge to create several labels.

Don’t Forget Stamps

Unfortunately, you can’t print envelopes using Excel alone. However, with the combination of MS Word and Excel, the envelope printing process is incredibly easy. With this tutorial, you should have your next batch of mail ready to go in no time. Don’t forget to pay for postage!

Related posts

• Sida loo Quful Unugyada Microsoft Excel

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?

• Farqiga u dhexeeya Microsoft Excel Online iyo Excel ee Desktop

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• Hagaaji "Ma bilaabi karo Microsoft Office Outlook" Khaladka

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Sida loo Furo Word iyo Excel si Badbaado ah

• Sida Loo Wadaago Faylka Excel Si Fudud Layskula Shaqeeyo

• Sida Taariikh ahaan loogu kala saaro Excel

• Sida loo Isticmaalo If iyo Nsted Haddii Odhaahyada Excel

• Sida loo isticmaalo Flash Fill ee Excel

• Sida loo tirtiro khadadka banaan ee Excel

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Hagaha VBA Sare ee MS Excel

• Sida loo sawiro Microsoft Word

• Dib-u-cusboonaysiinta Muuqaalka ee Microsoft Office: 8 shay oo ay tahay in la ogaado

• U samee qoraha OpenOffice muuqaal oo u shaqeeyo si ka badan sida Microsoft Word

• Sida Loo Hagaajiyo Safka gudaha Excel