katiapro93
Board Regular
- Joined
- Jun 25, 2009
- Messages
- 140
Ok, I am going to try this in a different way. I have an excel sheet which has information like name, address, etc. for all my customers. I have another excel sheet which is like a flyer and at the bottom of it, I have to enter the name of the store, address, etc. (info found on my informational excel sheet).
I have been trying to do a mail merge, but I can't get it. What is the easiest way to have excel go into my informational sheet and get the info for the first customer, place info where needed and then create another sheet and pick the information for the next customer on the list. I need it to do this until all the customers have their own personalized flyer.
Can anyone help me. I have already wasted 2 days trying everything and I need to have this done by tomorrow. At this point, I don't have any ideas left.
Example:
Info Sheet:
Rep name of store address city
David WD Store 5800 Miami
Sandra Publix 6800 Hollywood
Address Sheet:
Flyer and at the bottom
Name of Rep:
Name of Store:
Address
City:
Please help me..............
I have been trying to do a mail merge, but I can't get it. What is the easiest way to have excel go into my informational sheet and get the info for the first customer, place info where needed and then create another sheet and pick the information for the next customer on the list. I need it to do this until all the customers have their own personalized flyer.
Can anyone help me. I have already wasted 2 days trying everything and I need to have this done by tomorrow. At this point, I don't have any ideas left.
Example:
Info Sheet:
Rep name of store address city
David WD Store 5800 Miami
Sandra Publix 6800 Hollywood
Address Sheet:
Flyer and at the bottom
Name of Rep:
Name of Store:
Address
City:
Please help me..............