Macro to loop through a list of items and print for each item

[JeffR]

I have a spreadsheet where sheet 1 is a customer statement, sheet 2 is a
form letter and sheet 3 has a list of customer numbers and customer names.

In the customer statement for example there is a vlookup that references a
value on the 3rd sheet (with the list of customers). So if the value is 3 it
will use the 3rd customer number in the list.

What I'm trying to do is have a macro run that will print the statement,
print the form letter, increment the value on sheet 3 by 1 and then continue
to loop through this process untl it reaches the end of the list on sheet 3.

Any ideas?

Thanks

 

[Jim Cone]

Take a look at/download John Walkenbach's "Elephants R Us" Mail Merge-Without Word...
http://spreadsheetpage.com/index.php/tip/C19
(one of my favorites)
--
Jim Cone
Portland, Oregon USA



"JeffR"
wrote in message
I have a spreadsheet where sheet 1 is a customer statement, sheet 2 is a
form letter and sheet 3 has a list of customer numbers and customer names.
In the customer statement for example there is a vlookup that references a
value on the 3rd sheet (with the list of customers). So if the value is 3 it
will use the 3rd customer number in the list.
What I'm trying to do is have a macro run that will print the statement,
print the form letter, increment the value on sheet 3 by 1 and then continue
to loop through this process untl it reaches the end of the list on sheet 3.
Any ideas?
Thanks

 

[JeffR]

Exactly what I needed!

Thanks

 

[\Ji Zhou [MSFT]\]

Hello Jeff,

Thanks for using Microsoft Newsgroup Support Service! I am glad that you
have found the helpful link to your issue, and also thanks for Jim's
posting. If you have any future questions or concerns on the same issue,
please feel free to update this thread, and I will try my best to follow up.

Have a great day!

Best regards,
Ji Zhou ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://support.microsoft.com/select/default.aspx?target=assistance&ln=en-us.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wee Sern]

I have been using this macro for cheque printing. Now I need to use this to save into new workbook instead of printing. the file new should pick up from one of the data. Any one have a solution?