Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2007

Tip: Looking for answers? Try searching our database.

Picking up info from completed mail merge document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Smudge - 23 Feb 2007 13:45 GMT
Hi there,

When I do a mail merge, I merge to a separate document and save that doc.

Is there any way I can add a macro that picks up the second line of the
address and could put the info in a table in a new page at the top of the
doc? I was wondering if I could "mark" the info to be picked up by using a
specific style.

Probably a bit too optimistic about this. I was going to try to do it using
the macro wizard (my level)

Thanks in advance for your help

Cheers
Signature

Smudge

Helmut Weber - 23 Feb 2007 21:23 GMT
Hi Smudge,

before starting the merge, format the line you need
in a style otherwise not used in the doc,
like "Las Vegas Lights", probably,
but one never knows.

From then on it is a bit too much to ask for.
Do you really want to spoil you merged doc?

If so,
insert a break "Page break" at the start of your doc
count the number of occurences of "Las Vegas Lights".
Insert a table with that number of rows at page 1.

Search again for the specific formatting.
Fill the table which each found text,
whereby the first found text goes into the first cell
of the row number which corresponds to the n-th find.

I ain't that easy.

HTH
Smudge - 25 Feb 2007 19:33 GMT
Hi Helmut,

Thanks for your reply.

I'll go away and play.

I was going to set up a named style (in styles and formatting) with the same
formatting as the rest of the address so that I could use the document as
normal. then the idea was to have maybe a macro that would pick out the names
and orgs that the letter had been sent to - i.e. after letters have been
printed start macro and get a table that can be saved for other users to
havea a quick ref. The datasource (table in word) has a complete list but
many letters just go out to a selection of the addresses so it would neat to
have a record of where the letters went.

Cheers

Signature

Smudge

> Hi Smudge,
>
[quoted text clipped - 19 lines]
>
> HTH
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.