mail merge collecting data
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Mail Merge Collecting Data From Excel

Mail Merge Collecting Data From Excel

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

· Urgent Priority · Version 2003

Mail Merge Collecting Data From Excel

Anthony has attended:
Excel Advanced course

by - delegate Anthony [5 posts] (2008 Apr 29 Tue, 17:22) replyReply

Hi

I am trying to do a mail merge to collect data from excel to send statements to suppliers.

I have managed to do a mail merge but where suppliers have more than one item a seperate letter is produced for each item.

I want the letters to collect all rows for a supplier and show them on one letter.

Is there an easy way of doing this?

Any help would be greatly appreciated.

Kind Regrads

Tony

Excel VBA 2 day course List price £495
Version Date Location Places
available
Book Next place rate:
Card Invoice
2003/XP 2008 May 22 Thu + 23 Fri Southwark 5 book now £450 £485
2003/XP 2008 Jun 5 Thu + 6 Fri Bayswater 6 book now £450 £485
2003/XP 2008 Jun 12 Thu + 13 Fri Bloomsbury 6 book now £450 £485
2003/XP 2008 Jun 19 Thu + 20 Fri Southwark 5 book now £450 £485
2003/XP 2008 Jul 3 Thu + 4 Fri Southwark 6 book now £450 £485
2003/XP 2008 Jul 17 Thu + 18 Fri Bloomsbury 5 book now £450 £485
Full Schedule: See all 65 Excel VBA course dates.
Bookings currently available until 26th November 2009.

RE: Mail Merge Collecting Data From Excel

by - trainer Jacob silver contributer[76 posts] (2008 May 12 Mon, 17:10) replyReply

Hello Tony

Thanks for your post. By the brief you have supplied it looks like requirement may well fall into the consultancy area.

ways forwards

1) email us some examples of your work, and list your key objectives). we will then profile & review your requirements

2) We will then send you a proposal
- Scope of work
- Timeframes
- Pricing

3) Sign our consultancy agreement

If you wish to progress this then please let me know.

Kind regards

Jacob


Related articles

· 3 Reasons Why Excel Training Courses For Employees Can Improve Your Business
· Features of Microsoft Excel that assist in Analysis of Financial Data
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel Training: Essential for Today's Employees
· Advanced Excel Training - takes you to the next level

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

Excel tip:

Create and delete borders

To put a border around the outside of a selected range, press Ctrl+Shift+&. Use Ctrl+Shift+_ (underscore) to remove any borders from a range.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information