Help!

letters to contain multiple(# varying) addresses

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> User Forms RSS
Next:  Selecting text from Word between 2 text strings  
Author Message
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Thu May 03, 2007 4:52 pm    Post subject: letters to contain multiple(# varying) addresses
Archived from groups: microsoft>public>word>vba>userforms (more info?)

Hi,
I'm looking to automate the generation of several hundred letters from data
in an access database. The problem is there can be anywhere from 1 - 6 names
and addresses that the letter is addressed to. I can get one address on the
letter via my vba code from access, no problem. It's the multiple addresses I
cannot find a way to do.
Does anybody know if I can create a word table to insert a variable number
of name and address data into that will fill the table from left to right
then down for a 2 column table?
Frankly, this sounds impossible to me at this point.

TIA,
--
MorningStarFan
Back to top
Advertisement
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Fri May 04, 2007 5:15 pm    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

How is the data arranged in your database?

--
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

"MorningStarFan" wrote in message

> Hi,
> I'm looking to automate the generation of several hundred letters from
> data
> in an access database. The problem is there can be anywhere from 1 - 6
> names
> and addresses that the letter is addressed to. I can get one address on
> the
> letter via my vba code from access, no problem. It's the multiple
> addresses I
> cannot find a way to do.
> Does anybody know if I can create a word table to insert a variable number
> of name and address data into that will fill the table from left to right
> then down for a 2 column table?
> Frankly, this sounds impossible to me at this point.
>
> TIA,
> --
> MorningStarFan
Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Fri May 04, 2007 5:15 pm    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

The data is all in one table in separate fields as below:

ID PreferredName AddressLine1 AddressLine2 AddressLine3 AddressLine4
AddressLine5 AddressLine6 FundName

Can the table be created with VBA and automation that I described? One that
will work for 1-6 name and address combinations per letter?

TIA,
--
MorningStarFan


"Doug Robbins - Word MVP" wrote:

> How is the data arranged in your database?
>
> --
> 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
>
> "MorningStarFan" wrote in message
>
> > Hi,
> > I'm looking to automate the generation of several hundred letters from
> > data
> > in an access database. The problem is there can be anywhere from 1 - 6
> > names
> > and addresses that the letter is addressed to. I can get one address on
> > the
> > letter via my vba code from access, no problem. It's the multiple
> > addresses I
> > cannot find a way to do.
> > Does anybody know if I can create a word table to insert a variable number
> > of name and address data into that will fill the table from left to right
> > then down for a 2 column table?
> > Frankly, this sounds impossible to me at this point.
> >
> > TIA,
> > --
> > MorningStarFan
>
>
>
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Sat May 05, 2007 12:09 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Not quite clear to me,

Does a field such as AddressLine1 contain the name AND address details of an
addressee? Or, are AddressLine1 through AddressLine6 parts of the one
address?

--
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

"MorningStarFan" wrote in message

> The data is all in one table in separate fields as below:
>
> ID PreferredName AddressLine1 AddressLine2 AddressLine3 AddressLine4
> AddressLine5 AddressLine6 FundName
>
> Can the table be created with VBA and automation that I described? One
> that
> will work for 1-6 name and address combinations per letter?
>
> TIA,
> --
> MorningStarFan
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> How is the data arranged in your database?
>>
>> --
>> 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
>>
>> "MorningStarFan" wrote in
>> message
>>
>> > Hi,
>> > I'm looking to automate the generation of several hundred letters from
>> > data
>> > in an access database. The problem is there can be anywhere from 1 - 6
>> > names
>> > and addresses that the letter is addressed to. I can get one address on
>> > the
>> > letter via my vba code from access, no problem. It's the multiple
>> > addresses I
>> > cannot find a way to do.
>> > Does anybody know if I can create a word table to insert a variable
>> > number
>> > of name and address data into that will fill the table from left to
>> > right
>> > then down for a 2 column table?
>> > Frankly, this sounds impossible to me at this point.
>> >
>> > TIA,
>> > --
>> > MorningStarFan
>>
>>
>>
Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Sat May 05, 2007 12:09 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

AddressLine1 - 6 are all parts of the same address.
an example row from the table is a such:

0064694 Dr. Steve J. Adelf 7523 East 128th Street Tulsa OK 74143 Adelf
Scholarship for Engineering and Natural Sciences
--
MorningStarFan


"Doug Robbins - Word MVP" wrote:

> Not quite clear to me,
>
> Does a field such as AddressLine1 contain the name AND address details of an
> addressee? Or, are AddressLine1 through AddressLine6 parts of the one
> address?
>
> --
> 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
>
> "MorningStarFan" wrote in message
>
> > The data is all in one table in separate fields as below:
> >
> > ID PreferredName AddressLine1 AddressLine2 AddressLine3 AddressLine4
> > AddressLine5 AddressLine6 FundName
> >
> > Can the table be created with VBA and automation that I described? One
> > that
> > will work for 1-6 name and address combinations per letter?
> >
> > TIA,
> > --
> > MorningStarFan
> >
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> How is the data arranged in your database?
> >>
> >> --
> >> 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
> >>
> >> "MorningStarFan" wrote in
> >> message
> >>
> >> > Hi,
> >> > I'm looking to automate the generation of several hundred letters from
> >> > data
> >> > in an access database. The problem is there can be anywhere from 1 - 6
> >> > names
> >> > and addresses that the letter is addressed to. I can get one address on
> >> > the
> >> > letter via my vba code from access, no problem. It's the multiple
> >> > addresses I
> >> > cannot find a way to do.
> >> > Does anybody know if I can create a word table to insert a variable
> >> > number
> >> > of name and address data into that will fill the table from left to
> >> > right
> >> > then down for a 2 column table?
> >> > Frankly, this sounds impossible to me at this point.
> >> >
> >> > TIA,
> >> > --
> >> > MorningStarFan
> >>
> >>
> >>
>
>
>
Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Sat May 05, 2007 12:09 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

fyi: my example only had data in AddressLine1 and 2 in this case. The data
varies as addresses vary. Some addresses have 6 lines ...but that is rare.
Most will only have two.
--
MorningStarFan


"Doug Robbins - Word MVP" wrote:

> Not quite clear to me,
>
> Does a field such as AddressLine1 contain the name AND address details of an
> addressee? Or, are AddressLine1 through AddressLine6 parts of the one
> address?
>
> --
> 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
>
> "MorningStarFan" wrote in message
>
> > The data is all in one table in separate fields as below:
> >
> > ID PreferredName AddressLine1 AddressLine2 AddressLine3 AddressLine4
> > AddressLine5 AddressLine6 FundName
> >
> > Can the table be created with VBA and automation that I described? One
> > that
> > will work for 1-6 name and address combinations per letter?
> >
> > TIA,
> > --
> > MorningStarFan
> >
> >
> > "Doug Robbins - Word MVP" wrote:
> >
> >> How is the data arranged in your database?
> >>
> >> --
> >> 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
> >>
> >> "MorningStarFan" wrote in
> >> message
> >>
> >> > Hi,
> >> > I'm looking to automate the generation of several hundred letters from
> >> > data
> >> > in an access database. The problem is there can be anywhere from 1 - 6
> >> > names
> >> > and addresses that the letter is addressed to. I can get one address on
> >> > the
> >> > letter via my vba code from access, no problem. It's the multiple
> >> > addresses I
> >> > cannot find a way to do.
> >> > Does anybody know if I can create a word table to insert a variable
> >> > number
> >> > of name and address data into that will fill the table from left to
> >> > right
> >> > then down for a 2 column table?
> >> > Frankly, this sounds impossible to me at this point.
> >> >
> >> > TIA,
> >> > --
> >> > MorningStarFan
> >>
> >>
> >>
>
>
>
Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Sat May 05, 2007 3:13 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Mon May 07, 2007 3:21 pm    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Mon May 07, 2007 3:46 pm    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Tue May 08, 2007 1:07 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Tue May 08, 2007 1:07 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
Doug Robbins - Word MVP
External


Since: Jul 14, 2006
Posts: 2843



PostPosted: Tue May 08, 2007 1:54 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
MorningStarFan
External


Since: Apr 11, 2007
Posts: 15



PostPosted: Tue May 08, 2007 10:56 am    Post subject: Re: letters to contain multiple(# varying) addresses
Archived from groups: per prev. post (more info?)

Back to top
Advertisement
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> User Forms
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum