Mail Merge Collecting Data From Excel

Resolved · Urgent Priority · Version 2003

Tue 29 Apr 2008, 17:22 Delegate Anthony said...

Anthony has attended:
Excel Advanced course

Mail Merge Collecting Data From Excel

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

Mon 12 May 2008, 17:10 Trainer Jacob said...

RE: Mail Merge Collecting Data From Excel

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

Excel tip:

Removing the Ribbon from view in Excel 2010

At times when you want to view the whole spreadsheet, try double clicking on the ''Home'' tab on the ribbon which will hide the ribbon from view.

View all Excel hints and tips

Mail Merge Collecting Data From Excel

Mail Merge Collecting Data From Excel

RE: Mail Merge Collecting Data From Excel

Excel articles

Excel tip:

Removing the Ribbon from view in Excel 2010