excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2007

Louise has attended:
Excel Introduction course

Excel

How to create address labels through excel

RE: Excel

Hi Louise

Thank you for your question. Excel can be used to create data sources for mailmerge. Create a column for each field that will be used in the merge document. Keep the titles of the columns simple, preferably with no spaces. Save the file and when you get to step three in the Word mailmerge process choose "Existing list" and browse for your Excel workbook.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Wed 15 Jul 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.09 secs.