Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
importing excel cells into a company letter head template
i am sending out quotes to over 1000 companys for 3 differnt services...i
have them stored in microsoft excel under columns (g1-1400)(h1-1400) and (i1-1400). i also have their addresses stored in excel...i want my template to read dear (name stored in excel) your first quote is g1 your second quote is h1 your 3rd quote is i1 thanks have a good day.........and then print out 1400 different leters to mail out can this be done with excel and word.....or can it be done iwth access |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
importing excel cells into a company letter head template
If I have understood correctly, it should be feasible with Excel and Word.
It can probably be done with Access. I would start with a small example with a few sample records and see what happens. Peter Jamieson "jerry" wrote in message ... i am sending out quotes to over 1000 companys for 3 differnt services...i have them stored in microsoft excel under columns (g1-1400)(h1-1400) and (i1-1400). i also have their addresses stored in excel...i want my template to read dear (name stored in excel) your first quote is g1 your second quote is h1 your 3rd quote is i1 thanks have a good day.........and then print out 1400 different leters to mail out can this be done with excel and word.....or can it be done iwth access |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
importing excel cells into a company letter head template
Hi ?B?amVycnk=?=,
i am sending out quotes to over 1000 companys for 3 differnt services...i have them stored in microsoft excel under columns (g1-1400)(h1-1400) and (i1-1400). i also have their addresses stored in excel...i want my template to read dear (name stored in excel) your first quote is g1 your second quote is h1 your 3rd quote is i1 thanks have a good day.........and then print out 1400 different leters to mail out can this be done with excel and word.....or can it be done iwth access In access, certainly. In Word, probably, but I'm not quite clear how ALL the data is set up in Excel. Is all the information that you want to appear in the letter in one table? Then all you need to do is insert the appropriate columns in a mail merge document. If that's not quite what you have, please be more specific. And we also need to know the version of Word you're using. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get my company letter head from showing on all new doc? | Microsoft Word Help | |||
Linking Excel cells to a Word document | Mailmerge | |||
Insertion of Excel template | Microsoft Word Help | |||
How do I access a created template from letter wizard | Microsoft Word Help | |||
letter to china requesting prices- template? | Microsoft Word Help |