excel computer training london - mail merge
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - Mail Merge

excel computer training london - Mail Merge

resolvedResolved · Low Priority · Version Standard

replyReply Tue 20 Feb 2007, 16:19Delegate Carlos said...

Carlos has attended:
Excel Intermediate course

Mail Merge

Please can you explain line by line how to do a mail merge from an excel spreadsheet to a word document???

For upcoming training course dates see: Pricing & availability

replyReply Tue 20 Feb 2007, 17:39Trainer Amanda said...

RE: Mail Merge

Hi Carlos

Thanks for your question.

To do a mail merge from Word using an Excel spreadsheet as your data source:

1. In Word, go to Tools - Letters and Mailings - Mail Merge Wizard. The Mail merge wizard opens in the task pane on the right of your screen.

2. choose letters at step 1, click Next at the bottom of the task pane.

3. Choose Use the current document, click Next.

4. Click Browse under Use an existing list, and select the Excel file and sheet that contains the info you wish to merge into the Word document.

5. Deselect any items that shouldn't be included in the mail merge from the Mail Merge Recipients window and click OK. Click Next.

6. Click the More items link to see the headings in your Excel sheet that you can insert as fields into your letter. Select the field you wish to insert and click OK. Keep repeating this step until you have inserted all your fields, then click Next.

7. The next step allows you to preview your letters - if they all look OK then click Next.

8. Print your letters using the Print link.

You can go back to previous steps at any time during the mail merge wizard process.

I hope this answers your question.

Amanda

 

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard