Excel for Envelopes

[rockchalk33]

Hey all,

I need to use Microsoft Excel to create single or multiple #10 envelopes with different business addresses and "attn:" boxes from a list of businesses/addresses/attns stored in Excel. I need to manually be able to click on each business within a userform that I need to print an envelope for. Can anyone point me in a direction to get started on this? I plan on creating a userform that will allow me to add or delete businesses in the current list as well as selecting all businesses that an envelope needs created for (I need a little direction here as well, as I am unaware of a tool available to do this within the developer toolbox).

Thanks

Devin

 

[RedBeard]

To be honest, this sounds more like a job for a database (i.e. Access).

 

[SpillerBD]

Use Mail Merge from Word. You can source the addresses from Excel and use a filter to in various ways to pick exactly which addresses you print to envelopes.

https://support.office.com/en-us/ar...nvelopes-f488ed5b-b849-4c11-9cff-932c49474705