excel interfacing

[paul]

hello all...

i have a long excel spreadsheet with lots of customers
info on it, i have a userform which picks out userdefined
info from cells, so their address will be stored under an
address string. is there anyway i can export this info
to a word document, ie into an address field in a mail
merge.

I'm new to all of this mail merging, is there a way to do
this without specifying a source for the data, or
overriding it to put in my own.

Thanks for any help you can give me.

Paul Haughton

 

[Doug Robbins - Word MVP]

Is the userform in Excel or Word?

Do you just want to create one letter at a time, or one letter for each
customer?


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Paul]

The userform is in excel and all i need to do is create
one letter at a time. It is a modeless userform so the
user can click on the relavent cell to get the info from
excel, but if the info is missing they can fill the field
themselves.

The main problem i have is exporting all of this
information in to a word document, setting the template
up and all the excel bits are fine, it's just this middle
bit i'm stuck with.

TIA

Paul

 

[Doug Robbins - Word MVP]

I would be more inclined to have the userform in Word.

See the article "Load a ListBox from a Named Range in Excel using DAO" at:

http://word.mvps.org/FAQs/InterDev/FillListBoxFromXLDAO.htm

Then when the user selects an item (record) in the listbox, you could have
a series of textboxes on the userform populated with the data for that
record and they could enter the missing data into the textboxes and then
click on a command button that would either insert the information from the
textboxes into (InsertBefore) the range of bookmarks that you place in the
template, of load the information into document variables so that it is
displayed in document variable fields that you place in the template.

See the article "How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi Paul,

You should find an article that describes how to run Word
from within Excel, and dump data into a document on
word.mvps.org

The userform is in excel and all i need to do is create
one letter at a time. It is a modeless userform so the
user can click on the relavent cell to get the info from
excel, but if the info is missing they can fill the field
themselves.

The main problem i have is exporting all of this
information in to a word document, setting the template
up and all the excel bits are fine, it's just this middle
bit i'm stuck with.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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