OT Any Microsoft Office Experts? OT
Barbara Gill, Remlik VA
>I am trying to figure out if I can merge multiple fields from Excel into a letter in Word. I don't seem to be able to find the answer in Office for Dummies.
Knowledge You Can Build On — Est. 1998
OT Any Microsoft Office Experts? OT
Barbara Gill, Remlik VA
>I am trying to figure out if I can merge multiple fields from Excel into a letter in Word. I don't seem to be able to find the answer in Office for Dummies.
Re: OT Any Microsoft Office Experts? OT
Jim Terry
>Barbara, I know you can select a group of adjacent cells in Excel and use copy and paste to insert them into Word. Paste inserts the cells into Word columns. Paste Special inserts them into an Excel looking table. You can then double click on the pasted table and it then looks more like an Excel table where you can adjust column width. Hope this helps. Jim
Re: OT Any Microsoft Office Experts? OT
Barbara Gill, Remlik VA
>I operate a water system and send out bills 4 times a year. The meter readings and Excel calculated $ is what I want to feed into the Word to produce the bills with former meter reading, present meter reading. gallons used and $ billed plus the Name of the property owner.
Re: OT Any Microsoft Office Experts? OT *LINK*
Ron in Drums PA
>I think what you are trying to do is a mail merge
http://office.microsoft.com/en-us/help/HA010349201033.aspx
Re: OT Any Microsoft Office Experts? OT
Walter Ahlgrim
>This sounds like it should be in Access to me. You can use XL as a data base but there are problem don�t let it get to big is the biggest one. Access could do the whole project.
I was afraid of that
Barbara Gill, Remlik VA
>I don;t have acess.
Thanks Everyone
Barbara Gill, Remlik VA
>
Re: OT Any Microsoft Office Experts? OT
Bill McWhirter
>Can you first merger them into an excel sheet and then copy and paste the merged section into your word document?
Re: OT Any Microsoft Office Experts? OT
Barbara Gill, Remlik VA
>I have to take the information for 27 customers and transfer their numbers for each letter.
Re: OT Any Microsoft Office Experts? OT
Stuart Johnson
>I haven't used it but I think MySQL might be what you want. It is a freeware database application.
Thanks Stuart
Barbara Gill, Remlik VA
>I will check it out.
Re: OT Any Microsoft Office Experts? OT
Darryl
>Barb, couldn't you run a mail merge for the addresses in the basic word document. Then open Word and Excel split the screen horizontally. Then pick the letter from the group of 27 that have had the addresses merged. drag through the line in Excel relative to the particular customer and edit/copy. Move to the word document (just click in it)and paste the line into the letter. Then move to the next letter Word and repeat the copy paste. Should be fairly simple to do. Darryl
Re: OT Any Microsoft Office Experts? OT
Barbara Gill, Remlik VA
>Hmmm, I don't know Darryl but I sure can give it a try.
Re: OT Any Microsoft Office Experts? OT
Darryl
>Barb, I assumed you probably knew how to set up a mail merge but if not in short this is what you do. You put the addresses in a formated file. Must have the same number of fields (even if they are blank) in each address record. the file would be something like this. first-name, last-name,address-line1, address-line2, city,zip. The file probably needs to be comma delimited.
Then make a primary document which would be the letter. Dear (use the insert command to insert field1 Insert command field2 return insert field3 return, insert field 4,field 6. If you only have most address with no second line for the street then you could eliminate that insertion
It would be the same letter for each addressee. In the body would be a statement like "Your current charges and past usage figures are as follows". Then say leave two or three lines of returns so there would be a blank. Then you merge the address files with the basic letter. You would end up with 27 identical letters each with its own address. Then do as I suggested open both programs and edit/copy/ paste into the blank line in each letter. Hope this makes sense. It is easier to do than to explain. Darryl
Re: OT Any Microsoft Office Experts? OT
mpax356
>The mail merge features of Word can be used to pull in fields from Excel besides address fields for individual letters. With only 27 letters you do not need Access or MYSQL or other things to make it more complicated. You do not NOT need to resort to copy and past for each letter. Use the Help function in Word to get assistance on doing this.
You don't need Access
Carole Valentine
>If the first row of your Excel table is field names, you can use the Word mail merge.