Post New Topic

Addressing Excel Question

DCLM726 Posted:

Addressing Excel Question

I am working on my labels for my invites. If I do it in excel...do I put each name and address on the same line or a seperate line each line.

Ultimately, I am going to mail merge them
MCDO15 Posted:

Re: Addressing Excel Question

seperate line per name

Tom Smith 123 Apple Road
Nancy Smity 123 Apple Road

To make your life eaiser, I would seperate by columns first name, last name, address, city, state, zip

When it comes to the mail merge, you will have to plan to say Mr & Mrs, or family, etc... so include colums for that so you don't have to do it manually.
Then when the mail merge comes, don't add 2nd, 3rd, etc.. names of a same family if more then one person from the house gets invited.

you can also include more information about your wedding and your guest with more columns
but won't need to use it during the mail merge.
PegaLega Posted:

Re: Addressing Excel Question

do seperate columns for everything-its easier to put it together

Reply to this topic

Log in to reply or quote a post.