Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

send info from list box to a mail merge document

Okay, I'm learning.....

The mail merge works like a charm.  One more bit of functionality I need to add.  

I select a document from the combo box, the appropriate people show up.  The user selects any number of the records in ListBox1 to transfer to ListBox2.  

I need to send the mail merged form letter to all the selected records from ListBox2.

I understand that would be a For..Next Loop, but do I use the count property?  ListIndex?  I'm unclear and my syntax is breaking the form.  

Please help!!
-A
0
ambulance
Asked:
ambulance
1 Solution
 
ndbCommented:
Hi,

Try this:

For i = 0 to List1.ListCount - 1
  If List1.Selected(i) Then
    Debug.Print List1.List(i)
  End If
Next i

This will print each item that the user selected.
0
 
ambulanceAuthor Commented:
Duh!  Why didn't I come up with that?!  
Harumph....

Thanks.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now