Mail merge

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

Resolved · Low Priority · Version Standard

Mail merge

Sara has attended:
Excel Intermediate course

by - delegate Sara [1 post] (2008 Feb 6 Wed, 16:07) Reply

How to mail merge emails? The problem is in using data-base fields in the "To:" field as well as in the body of the email message.

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: mail merge

by - trainer Mark gold contributer [326 posts] (2008 Feb 12 Tue, 10:17) Reply

Hiya Sara How are you hope you are well

After taking a bit of advice on this subject i need to ask you for a bit more info on the type of database you want to use

If you could send me more details of what it is you are trying to achieve and from where

If you would prefer to email over the details to me its

mark

i can look into it further

Mark East

· Microsoft Excel Training Advanced Courses - Making Data Validation Work For You
· Microsoft Excel Features and Functions for Accountants
· Advanced Excel Training - takes you to the next level
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Interesting Lifestyle Applications for Microsoft Excel

Please browse our web site to find out more about
microsoft-excel-training and other Microsoft training courses.

Excel tip:

Converting an American date format to European using Formula

Excel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following.

1. Extract the date components mmm dd yyyy, by using the the Text functions LEFT, MID or RIGHT

2. Reorder dd mmm component and concatenate using "&" in the right order this will create a text string with the date in the right order it then needss to be converted to a value so excel can recognise it.

3. To convert to value encase in TEXT function.

4. Format to desired date format.

View all Excel hints and tips

Rate this page: