Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a document automatically based on excel or csv data ?
Hi there,
I have a spreadsheet (or csv) file that I want to be able to have merged into a word doc (i.e. Name , Address etc etc) Is there some way I can "force" word to use this data when opened, rather than have to use the merge button etc. I don't want any user interraction and basically just want to print the "populated" word document. access). any help would be greatly appreciated. cheers, Adam |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a document automatically based on excel or csv data ?
If you save the document with the data source attached and the merge fields
in place, the next time that you open it, it should still be attached, ready to go. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message ups.com... Hi there, I have a spreadsheet (or csv) file that I want to be able to have merged into a word doc (i.e. Name , Address etc etc) Is there some way I can "force" word to use this data when opened, rather than have to use the merge button etc. I don't want any user interraction and basically just want to print the "populated" word document. access). any help would be greatly appreciated. cheers, Adam |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a document automatically based on excel or csv data ?
Hi Doug,
with this approach does it still require me to hit the merge button to merge the data ? I will be printing off over 40 documents at once, so I was hoping to not have to do that. cheers, Adam Doug Robbins - Word MVP wrote: If you save the document with the data source attached and the merge fields in place, the next time that you open it, it should still be attached, ready to go. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message ups.com... Hi there, I have a spreadsheet (or csv) file that I want to be able to have merged into a word doc (i.e. Name , Address etc etc) Is there some way I can "force" word to use this data when opened, rather than have to use the merge button etc. I don't want any user interraction and basically just want to print the "populated" word document. access). any help would be greatly appreciated. cheers, Adam |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a document automatically based on excel or csv data ?
If you mean that you have 40 records in the data source, it is only
necessary to execute the merge once, directly to the printer. How are you doing it now? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message oups.com... Hi Doug, with this approach does it still require me to hit the merge button to merge the data ? I will be printing off over 40 documents at once, so I was hoping to not have to do that. cheers, Adam Doug Robbins - Word MVP wrote: If you save the document with the data source attached and the merge fields in place, the next time that you open it, it should still be attached, ready to go. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message ups.com... Hi there, I have a spreadsheet (or csv) file that I want to be able to have merged into a word doc (i.e. Name , Address etc etc) Is there some way I can "force" word to use this data when opened, rather than have to use the merge button etc. I don't want any user interraction and basically just want to print the "populated" word document. access). any help would be greatly appreciated. cheers, Adam |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a document automatically based on excel or csv data ?
Hi Doug,
I am hoping to print out 40 word documents, with details from a 1 line csv file. The csv will contain, for example, simply name and address details etc that will form the header for each document. The documents will all have the name and address info at the top of each page(for 40 different word documents). This is part of a new system am I making sense here ? cheers Doug Robbins - Word MVP wrote: If you mean that you have 40 records in the data source, it is only necessary to execute the merge once, directly to the printer. How are you doing it now? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message oups.com... Hi Doug, with this approach does it still require me to hit the merge button to merge the data ? I will be printing off over 40 documents at once, so I was hoping to not have to do that. cheers, Adam Doug Robbins - Word MVP wrote: If you save the document with the data source attached and the merge fields in place, the next time that you open it, it should still be attached, ready to go. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message ups.com... Hi there, I have a spreadsheet (or csv) file that I want to be able to have merged into a word doc (i.e. Name , Address etc etc) Is there some way I can "force" word to use this data when opened, rather than have to use the merge button etc. I don't want any user interraction and basically just want to print the "populated" word document. access). any help would be greatly appreciated. cheers, Adam |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merging a document automatically based on excel or csv data ?
I would combine all of the documents into one.
See the "Preserving Section Formatting when Pasting between Documents" item in the article at: http://www.word.mvps.org/FAQs/Format...thSections.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message ups.com... Hi Doug, I am hoping to print out 40 word documents, with details from a 1 line csv file. The csv will contain, for example, simply name and address details etc that will form the header for each document. The documents will all have the name and address info at the top of each page(for 40 different word documents). This is part of a new system am I making sense here ? cheers Doug Robbins - Word MVP wrote: If you mean that you have 40 records in the data source, it is only necessary to execute the merge once, directly to the printer. How are you doing it now? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message oups.com... Hi Doug, with this approach does it still require me to hit the merge button to merge the data ? I will be printing off over 40 documents at once, so I was hoping to not have to do that. cheers, Adam Doug Robbins - Word MVP wrote: If you save the document with the data source attached and the merge fields in place, the next time that you open it, it should still be attached, ready to go. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Staunts" wrote in message ups.com... Hi there, I have a spreadsheet (or csv) file that I want to be able to have merged into a word doc (i.e. Name , Address etc etc) Is there some way I can "force" word to use this data when opened, rather than have to use the merge button etc. I don't want any user interraction and basically just want to print the "populated" word document. access). any help would be greatly appreciated. cheers, Adam |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging multiple rows in Excel to one word document. | Mailmerge | |||
Update Excel table in Word automatically from data in Excel | Tables | |||
Why isn't all my Excel data merging into my Word labels document? | Mailmerge | |||
How do you keep the currency format when merging data from Excel? | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge |