[carl chan]

Hi Macropod,

Thanks for the tutorial again. I went ahead and redid mail merge using your method. I finally managed to insert the text after the categories appear. I kind of wish it was easier to code the mail merge.

Thanks again!

[macropod]

Hi Carl,

I'm glad you got it sorted - less work for me

Yes, it'd be nice if this kind of functionality was built in, but it isn't and the field coding in this and my other tutorials are pushing Word to do things its designers probably never intended.

[Mephisto]

Hi Paul

sorry for not coming back to you earlier, but I lost the webpage and my login, this time of the year.

Thank you for your offer, but I have no clue how I can upload any data here. Shame on me. I have sort of got the mail merge to work, however I would like to use it for other purposes as well.

Currently I would like to create a list that shows the company name up top and then some shareholder details in a list below with their ownership details and subtotals per company on a separate page.

I know this is part of your tutorial, but I just can't get it to work.

If you could give me a hint how to upload the data, I would appreciate you helping me, otherwise you could maybe contact me by e-mail?

P

[macropod]

Hi Mephisto,

When you click on the 'Add Reply' button, the message panel opens. If you scroll down, just below the message panel you'll see the buttons for managing attachments. After composing your message, simply browse to & select your file, click 'upload' then 'Add Reply' to complete a post with an attachment.

[Richelle LaBelle]

GREAT TUTORIAL! They are going to have to add a rating or tagging system to this Lounge so items like this can be tagged!!

[WendellB]

Actually there is a "Star Post" system with that purpose in mind, though it got buried a bit in the conversion from Woody's to Windows Secrets. You can find them in Lounge Matters as pinned posts - see Office Applications to find this post there.

[Gigi Libretto]

I am hoping someone can help me. I had tried the tutorial and it works fine except between all the records there are 3 blank lines. I have tried and tried and can not figure out how to remove these lines.

Here is an example:

ATLANTA



Smith 3,000.00



Gates 50,000.00



Henderson 10,000.00




HOUSTON



Jones 8,000.00



Kelley 9,000.00



Peterson 0.00



I would truly appreciate any help. Thanks

This post has been edited by Gigi Libretto: 2010-07-12 15:25

[jscher2000]

Gigi Libretto, on 2010-07-12 13:22, said:

I had tried the tutorial and it works fine except between all the records there are 3 blank lines. I have tried and tried and can not figure out how to remove these lines.

It would be very helpful to see the "main document" that contains your merge fields.

[macropod]

Gigi Libretto, on 2010-07-13 07:22, said:

I am hoping someone can help me. I had tried the tutorial and it works fine except between all the records there are 3 blank lines. I have tried and tried and can not figure out how to remove these lines.

Here is an example:
...

I would truly appreciate any help. Thanks

Hi Gigi,

OK, my first observation is that you are probably not using the field coding from my tutorial, but the field code from one of the MS website pages instead:
at:
http://support.micro...om/?kbid=211303
or:
http://support.micro...kb/294686/en-us

The sample output data you posted is from one of the above - not from the mailmerge datasource attached to my tutorial. If you're using my field coding with the MS sample data, there wouldn't be any excess spaces unless you modified the field code and/or had extra lines after the field code in your mailmerge main document.

Sorry about the delay in replying - I'm travelling with only limited internet access.

[Lynn Furlong]

I would like to thank you for these detailed instructions on Mail Merge. I wouldnt have known where to start. I have come across a problem though and I hope you can help. I have got as far as calculating group totals. This worked perfectly the first time I ran it however the second time I ran the mail merge the document seemed to have saved the previous totals and the totals al accumulate.

I.e. 256 rows in Excel - Total to approxmately €500,000
1st time I ran merge each group calculated succussfully
2nd time I ran merge each group was correct total plus €500,000
3rd time I ran merge each group was correct total plus €1,000,000
4th time I ran merge each group was correct total plus €1,500,000
5th time I ran merge each group was correct total plus €2,000,000
6th time I ran merge each group was correct total plus €2,500,000
and so on... Any ideas?

Attached file(s)

•  Client2.doc (68K)
  Number of downloads: 2

[macropod]

Hi Lynn,

Your field coding has some errors. For example, the first line is missing some double-quotes and the space that's needed to separate two expressions. Instead of:
{IF{ MERGESEQ }= 1 {SET Key ""}{SET Group -1}{ SET Tot1 0 }{SET Tot2 0}{SET LastKey { Key }}}
you should have:
{IF{ MERGESEQ }= 1 "{SET Key ""}{SET Group -1}{SET Tot1 0}{SET Tot2 0}" {SET LastKey { Key }}}

This post has been edited by macropod: 2010-08-11 21:20
Reason for edit: Field coding errors identified

[Lynn Furlong]

Thanks a million. That fixed it.

Regards
Lynn