advanced excel seminar training - Mail merging

The UK's most regular instructor-led training courses.
Training information: advanced excel seminar training · Excel training london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Mail merging

Patrick has attended:
Excel Introduction course
Access Introduction course

by - delegate Patrick [2 posts] (2007 Feb 21 Wed, 15:27) Reply

What would be the easiest way to mail merge various excel files into word, knowing that they do not share the same field names?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Mail merging

by - trainer Amanda diamond contributer [1217 posts] (2007 Feb 22 Thu, 14:10) Reply

Hi Patrick

Thanks for your question.

As far as I'm aware the answer is that there is no easy way unfortunately.

You would need to put all of the data you wish to include in the mail merge into one Excel sheet.

thanks
Amanda

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· How to Create Better Excel Spreadsheets: Part Three
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· Advanced level training: Microsoft Excel and the Web
· Compare Different MS Excel Training Methods

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips