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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
mail merge collecting data

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

Mail Merge Collecting Data From Excel

ResolvedVersion 2003

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

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:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.