Hello,
I have a weekly task of supplying our vendors with a list of line items that requires their attention and I am trying to send it out via an email merge. I am using the quick parts database function to create the list and it seems to work well. It pulls the data from my spreadsheet and lists it correctly based on vendor name but the problem I can't seem to figure out is how to consolidate the emails so that only one goes out per vendor. When I complete the merge and do the preview or edit phase it will create a document with the list of items for that vendor but it will repeat the document for as many times as there are line items in the list. For example; Comapny ABC has 5 line items, the result will be 5 documents with the list of all 5 items on each document.
Is it how my database is set up or is it in the code? What am I doing wrong or does this task require something else to manage it?
Here is what my database looks like but I can't seem to copy and paste the code without it putting it into the list format. Please help.
WO # | Call Time | Service Category | Location | Affiliate | Email Address |
WO143666 | 41827.34609 | Electrical/Lighting | FD7167 | Company 123 | 123@xyz |
WO146881 | 41834.77264 | Structural | FD1865 | Company ABC | 123@xyz |
WO143815 | 41827.50567 | Air Conditioning / Heating | FD2811 | Company ABC | 123@xyz |
WO136458 | 41814.39469 | Air Conditioning / Heating | FD6184 | Company ABC | 123@xyz |
WO150783 | 41838.56642 | Coolers/Freezers | FD7598 | Company ABC | 123@xyz |
WO146090 | 41832.76144 | Coolers/Freezers | FD2398 | Company ABC | 123@xyz |
WO133495 | 41807.54515 | Electrical/Lighting | FD6267 | ABC Vendor | 123@xyz |
WO139138 | 41820.54685 | Plumbing | FD1336 | ABC Vendor | 123@xyz |
WO153768 | 41846.49332 | Coolers/Freezers | FD10093 | ABC Vendor | 123@xyz |
WO150811 | 41838.60796 | Air Conditioning / Heating | FD3499 | ABC Vendor | 123@xyz |
WO151180 | 41840.61348 | Air Conditioning / Heating | FD4905 | Vendor 123 | 123@xyz |
WO139605 | 41821.38025 | Air Conditioning / Heating | FD4905 | Vendor 123 | 123@xyz |
WO139680 | 41821.41613 | Air Conditioning / Heating | FD4270 | Vendor 123 | 123@xyz |
WO139720 | 41821.43822 | Air Conditioning / Heating | FD3810 | Vendor 123 | 123@xyz |
WO135717 | 41812.48406 | Air Conditioning / Heating | FD1404 | Vendor 123 | 123@xyz |
WO133087 | 41806.64427 | Air Conditioning / Heating | FD10202 | Vendor 123 | 123@xyz |