Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to loop through a list of items and print for each item
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to loop through a list of items and print for each item
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to loop through a list of items and print for each item
Exactly what I needed!
Thanks "Jim Cone" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to loop through a list of items and print for each item
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 , 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: . ================================================== Get notification to my posts through email? Please refer to http://msdn.microsoft.com/en-us/subs...#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/...tance&ln=en-us. ================================================== This posting is provided "AS IS" with no warranties, and confers no rights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Items in Drop Down Filter List | Excel Discussion (Misc queries) | |||
How 2 sort an autosum total list after adding items 2 autosum item | Excel Discussion (Misc queries) | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
Print area based on item list | Excel Programming | |||
Pivot Table dropping items from page item list | Excel Discussion (Misc queries) |