Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeat a row in a table and mail merge

Status
Not open for further replies.
srtedg

srtedg

Technical User
Apr 24, 2003
16
US
I'm working on access mailmerge application.

Within word, I have a table that needs to be populated X amount of times.

How can I get this row to automatically repeat X amount of times with the mailmerge fields in the table.

I have a macro that will do it, but I don't know how to automate the macro..
Anyhelp would seriously rock..
Thanks.
 
Sort by date Sort by votes
I think:

If you can define X, then just put a "next record" merge field in there. If you cannot define X, then I can't help.

Otherwise, I am misunderstanding your question.

When do want the macro to run? When a user clicks a button or when the doc is opened?

Anne Troy
Word and Excel Macros
Coming soon: wX
 
Upvote 0 Downvote
I have a nextrecord field in there.. I guess I could get X.

The table now has one row, the last cell contains the nextrecord field. Basically.. I need that row to repeat automatically.
 
Upvote 0 Downvote
To repeat what?

Are you trying to make something like an invoice statement? Something where you have, for instance, 10 records for one person, 8 records for another, etc.?

Anne Troy
Word and Excel Macros
Coming soon: wX
 
Upvote 0 Downvote
Yes, Something similar.

I don't know access or VBA so I have no idea when I'm barking up the wrong tree..
Just a guess on where to look would be a huge help..


Thanks!
 
Upvote 0 Downvote
Well, there's a tech article on it, but it sucks. Just plain sucks--sorry to say. I could never get it to work. To be honest, you see the wX thing at the bottom of my sig? I'm creating a Word Addin, and this will be one of the things it'll do. But it'll use VBA and bookmarks (I believe) and not "mail merge". Unfortunately, I'm not the coder and the code isn't done yet. Wish I could help more.


Anne Troy
Word and Excel Macros
Coming soon: wX
 
Upvote 0 Downvote
Its a start..
Thanks for the help....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Word - Mail merge file names
Replies
1
Views
156
macropod
macropod
OCM
  • Locked
  • Question
Mail merge with details
Replies
2
Views
578
OCM
OCM
remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
1K
remeng
remeng
Andrzejek
  • Question
Formula with & and a single quote 2
Replies
4
Views
508
OzFoxy
OzFoxy
techguy2010
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
295
techguy2010
techguy2010

Part and Inventory Search

Sponsor

Back
Top