I posted this question some time ago, but I'm still looking for some help.
I've created a billing form in Excel. I need to merge into it the names, addresses, cities, states and zips from another source (a CSV formatted file, at the moment). There are approximately 70 records to be merged.
What I am trying to do, essentially, is a mail merge as you would do in MS Word. Normally, one can merge into Word from a spreadsheet data source. Well, I'm trying to merge into Excel from a CSV data source (or another format if it would work better).
Question: How do I tell Excel to merge from the csv file AND create a separate record/page for each of the 70 records (just like a mail merge)?
Here's the format of the spreadsheet (I couldn't get HTMLMaker to work):
FIXED (A1:A4) - THIS INFORMATION WILL NOT CHANGE:
My company's name
Address
City, State, Zip
DYNAMIC (A8:A12) - THIS INFORMATION WILL COME FROM ANOTHER SOURCE AND MERGE INTO EXCEL:
Customer's name
Address
City, State, Zip
PAYMENT ACTIVITY (rest of the sheet) - FORMULAS ARE USED
See, I'm just taking Excel and doing a mail merge, just as if I were doing a mail merge in Word. Each billing will be one page length for printing purposes. Each page has to merge from the CSV (or other formatted) source document.
Any ideas how to do this?
Thanks,
Starkman
I've created a billing form in Excel. I need to merge into it the names, addresses, cities, states and zips from another source (a CSV formatted file, at the moment). There are approximately 70 records to be merged.
What I am trying to do, essentially, is a mail merge as you would do in MS Word. Normally, one can merge into Word from a spreadsheet data source. Well, I'm trying to merge into Excel from a CSV data source (or another format if it would work better).
Question: How do I tell Excel to merge from the csv file AND create a separate record/page for each of the 70 records (just like a mail merge)?
Here's the format of the spreadsheet (I couldn't get HTMLMaker to work):
FIXED (A1:A4) - THIS INFORMATION WILL NOT CHANGE:
My company's name
Address
City, State, Zip
DYNAMIC (A8:A12) - THIS INFORMATION WILL COME FROM ANOTHER SOURCE AND MERGE INTO EXCEL:
Customer's name
Address
City, State, Zip
PAYMENT ACTIVITY (rest of the sheet) - FORMULAS ARE USED
See, I'm just taking Excel and doing a mail merge, just as if I were doing a mail merge in Word. Each billing will be one page length for printing purposes. Each page has to merge from the CSV (or other formatted) source document.
Any ideas how to do this?
Thanks,
Starkman