Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jerry
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M -WordMVP-
 
Posts: n/a
Default 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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get my company letter head from showing on all new doc? Sasha Microsoft Word Help 1 February 28th 06 08:26 PM
Linking Excel cells to a Word document jada Mailmerge 3 November 14th 05 08:17 PM
Insertion of Excel template Jonni Microsoft Word Help 5 January 5th 05 04:33 AM
How do I access a created template from letter wizard trying to streamline Microsoft Word Help 6 January 5th 05 02:52 AM
letter to china requesting prices- template? Misha Microsoft Word Help 1 December 5th 04 10:58 PM


All times are GMT +1. The time now is 12:27 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"