Find Jobs
Hire Freelancers

Double Sided Mail Merge 4x Postcards - Duplex merge data for postcards - Help

$250-750 USD

Cancelado
Publicado hace casi 12 años

$250-750 USD

Pagado a la entrega
I am currently sending out post cards to hundreds of potential customers. I do all of the printing in house, and the optimal layout includes 4 post cards per page. These post cards are being printed in Microsoft Word 2007 and are populated from a giant excel (eventually a database) which mail merges the data into the final postcard file for printing. One side of the post card has the customers name and address. The other side of the postcard has the customers name and a specific price quote (This data is all in the excel file). The goal is to produce the postcards with printed addresses on one side, and their printed name on the BACK SIDE of that quadrant for the post card. Currently I can print 100 pages (400 cards) that have the parties names and addresses on the front side. When I try to either duplex or flip the cards over to print their name and specific price quote on the other side, the cards do not line up. For example, the front of the postcard will display the name and address and look like: ClientA ClientB ClientC ClientD But when you flip it over to print the name and price quote, they are out of order: ClientB ClientA ClientD ClientC This is a known issue and one solution that has been offered is to install an add in for Word 2007 located here: [login to view URL] This website is pretty good about explaining exactly what it is I'm trying to do. I can't seem to get this to work with my documents. Basically, I need some type of solution that will let me print four postcards per page, and have mail merged data print on both sides of the cards, in the proper spaces. I think the solution is going to require some type of script or macro that reorders the raw data in the excel file prior to completing the mail merge for the second page. I have attached three documents. 1) Sample excel file that has eight fields. This is where the name/price/address comes from and is the source for the mail merge. 2) Sample word file that is the front side of the postcard. 3) Sample word file that is the back side of the postcard. The ultimate goal is: Hitting print and having 100 pages print 400 postcards. Then I simply take the stack of 100 pages, flip them over, put them back in the printer, and print the other side which is now lined up. (I could also duplex this). Open to any and all ideas how I can make this happen.
ID del proyecto: 2361175

Información sobre el proyecto

7 propuestas
Proyecto remoto
Activo hace 12 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
7 freelancers están ofertando un promedio de $311 USD por este trabajo
Avatar del usuario
we could help you in fixing this problem, Please allow us to analyses the information.
$250 USD en 5 días
4,8 (67 comentarios)
6,3
6,3
Avatar del usuario
More than 10 years experience in VBA. Please check your PMB.
$250 USD en 5 días
5,0 (5 comentarios)
3,5
3,5
Avatar del usuario
Hope I understood your requirement fully. It seems SQL queries are doing the job in Word documents isn't it? Please reply me if want award the bid for further discussion and clarifications. Thanks in advance.
$300 USD en 7 días
5,0 (1 comentario)
2,8
2,8
Avatar del usuario
Hi. This is a common problem. If you are trying to duplex print in Portrait, there should be no problems. If you are trying to duplex print 'Landscape', the paper is in effect turning upside down. You will need to reverse the set up on the 2nd side. I can set this up for you and produce a PDF for you to check the output. I can also assign a sequence number for each record as a further check.
$250 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, USA freelancer here. I have done such Macros before. If your job description is accurate, I can do this job on time. I am a Marketing Guru. Tasks of this nature is a necessity. After this simple task, I can be of guidance to you in regards to marketing. Look into Personalized URL (PURL). Great way to target the audience.
$250 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Building into the starting product a way to track information.
$250 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
we have experience........
$630 USD en 11 días
0,0 (0 comentarios)
3,6
3,6

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Forma de pago verificada
Miembro desde jul 29, 2012

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.