Adding info by Macro

[Ed]

I have a word document that has a number of remittance
advices on it. Each one takes up from 1 to 15 pages but
the way its is imported from Crystal Reports all of them
are are on one documents.

I need to do two things with this, firstly i need to add
an email address into the document - I have the email
address' on a spreadsheet referenced to a supplier id
which is also on the remittance advice.

Also if possible i would like to split each remittance for
each supplier into its own seperate document, bearing in
mind that every page is not neccesarily a new remittance
as it could span over a few pages.

Does any have any suggestions for this?

Many thanks in advance for your help.

Ed

 

[Cindy M -WordMVP-]

Hi Ed,

I have a word document that has a number of remittance
advices on it. Each one takes up from 1 to 15 pages but
the way its is imported from Crystal Reports all of them
are are on one documents.

The last sentence above is a bit garbelled, but I think it's
necessary to be sure we understand this?

So, Crystal Reports is generating a Word document, and you
need to manipulate the result, I take it. I don't suppose
Crystal Reports is applying any styles, or anything else you
can use to identify the different elements of a remittance?
Could you at least get it to put in "codes" you could locate
using Word's Find/Replace functionality?

I need to do two things with this, firstly i need to add
an email address into the document - I have the email
address' on a spreadsheet referenced to a supplier id
which is also on the remittance advice.

Also if possible i would like to split each remittance for
each supplier into its own seperate document, bearing in
mind that every page is not neccesarily a new remittance
as it could span over a few pages.

Does any have any suggestions for this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail