LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Combining data from Excel with Outlook address book to mail bills

I'm trying to setup an automated way to send computed bills to a list of
people in an organization (about 300).
We collect data (water usage) and use Excel to compute the bill based on
usage (current reading - previous times rate).
Each row is for a particular meter, and has a number.
We have a seperate list of people, with mailing addresses. Some people will
have more than one meter (we could make it one-to-one by creating duplicate
entries for these people as there are so few).

I'd like a way to combine the address list and the excel data and generate
bills - sounds like a mail merge but with two data sources.

Presumably Access could do this, but I don't have any experience there and I
want people after me to be able to understand what I've done.

Anyways, I'm open to suggestings. The addresses do not have to be in
Outlook, but it is convenient since Outlook Address Book does a good job at
managing this data.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I access Outlook Express email address book using Excel Clarrie s4 Excel Discussion (Misc queries) 1 July 14th 07 03:35 AM
Editing e-mail address brings up Outlook in Excel cell HT New Users to Excel 2 September 23rd 05 04:34 PM
Using Outlook address book in Excel Diane Hazen Excel Discussion (Misc queries) 1 April 19th 05 08:39 AM
How do I import Office address book to Outlook Express address bo. snnorp Excel Discussion (Misc queries) 2 February 22nd 05 11:47 AM
How do i export a Excel database a Outlook address book? Ash Excel Discussion (Misc queries) 2 February 8th 05 05:19 PM


All times are GMT +1. The time now is 02:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"