Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
I would like to do a mail merge inserting different PDFs as page two
of the word document for a fax blast. However, I need to send a specific page to a specific fax number. I was thinking of setting up an excel document with [name, fax number, document] columns as the data source, and thenmerge with my word document. My concern is that each recipient get the correct (individualized) page, along with the cover sheet with the correct name and fax number. Is is possible to embed a file (pdf or word) into an excel cell? That way, i could use an excel file to set up the merge (Name1, FaxNumber1, Document 1; Name2, Fax Number,2 Document 2; Name3, FaxNumber3, Document3) and then merge with my cover sheet. The individual PDF's would be the last page of the word document. Anyone else have another way to do this? Feel free to respond offline if you prefer. Lisa Berger New York City |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
See the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Lisa B." wrote in message ... I would like to do a mail merge inserting different PDFs as page two of the word document for a fax blast. However, I need to send a specific page to a specific fax number. I was thinking of setting up an excel document with [name, fax number, document] columns as the data source, and thenmerge with my word document. My concern is that each recipient get the correct (individualized) page, along with the cover sheet with the correct name and fax number. Is is possible to embed a file (pdf or word) into an excel cell? That way, i could use an excel file to set up the merge (Name1, FaxNumber1, Document 1; Name2, Fax Number,2 Document 2; Name3, FaxNumber3, Document3) and then merge with my cover sheet. The individual PDF's would be the last page of the word document. Anyone else have another way to do this? Feel free to respond offline if you prefer. Lisa Berger New York City |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
You could probably conditionally insert a PDF object in your merge document.
Insert a link to the object and wrap it in the field construction. You would end up with something like: { IF{ Mergefield Fieldname } = "Condition" "{ LINK AcroExch.Document.7 "D:\\Path\\Filename1.pdf" "" \a \f 0 \p }" "{ LINK AcroExch.Document.7 "D:\\Path\\Filename2.pdf" "" \a \f 0 \p }" } This would insert filename1.pdf when the condition is met and filename2.pdf when not. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lisa B. wrote: I would like to do a mail merge inserting different PDFs as page two of the word document for a fax blast. However, I need to send a specific page to a specific fax number. I was thinking of setting up an excel document with [name, fax number, document] columns as the data source, and thenmerge with my word document. My concern is that each recipient get the correct (individualized) page, along with the cover sheet with the correct name and fax number. Is is possible to embed a file (pdf or word) into an excel cell? That way, i could use an excel file to set up the merge (Name1, FaxNumber1, Document 1; Name2, Fax Number,2 Document 2; Name3, FaxNumber3, Document3) and then merge with my cover sheet. The individual PDF's would be the last page of the word document. Anyone else have another way to do this? Feel free to respond offline if you prefer. Lisa Berger New York City |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
Hi Graham,
Thanks for your help. I'm not sure I adequately (or correctly) explained what I'm trying to do. We are a nonprofit that needs to send out a questionaire (word document) to about 400 - 500 people to update our database, and include their page to update along with the letter/questionaire. We plan to use a fax blast service, to avoid having to hand fax each questionaire as we did last year. I need to supply the fax service with the word document (letter/ questionaire) and the source file (excel or access) so they can fax to correct source. The fax service will "do" the actual merge. My thought was to add a column to the excel document, and insert the pdf file: (columns -- Name/Fax Number/PDF) so it is just another field on the mail merge document. That way the output merge would contain the document with the correct pdf as page two (or whatever). Not sure your idea would work, but perhaps I'm wrong. Any other ideas? I asked the same question in the excel group. Best, Lisa On Mar 27, 2:37*am, "Graham Mayor" wrote: You could probably conditionally insert a PDF object in your merge document. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
Thanks, Doug, but I won't be doing the merge myself. The fax blast
service will do the merge, from my source document and my data source document. However, the article you suggested will work for other tasks. So I thank you. Best, Lisa On Mar 26, 7:22*pm, "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP " |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
Thanks, Doug, but I won't be doing the merge myself. The fax blast
service will do the merge, from my source document and my data source document. However, the article you suggested will work for other tasks. So I thank you. Best, Lisa On Mar 27, 2:37*am, "Graham Mayor" wrote: You could probably conditionally insert a PDF object in your merge document. |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge with pdf as second page
You could insert the extra column with the filename of the PDF and provided
the PDF contains only one page - objects cannot span pages in Word - then the aforesaid method should work. You would just need to additionally supply all the PDFs and change the command as follows { LINK AcroExch.Document.7 "{Mergefield PDFName}" "" \a \f 0 \p } The PDFs would need to be in the same folder as the merge document or you would need to add the path (that they will occupy when merged) also. { LINK AcroExch.Document.7 "C:\\Path\\{Mergefield PDFName}" "" \a \f 0 \p } You can test this by merging to a new document then updating the link fields in that document (CTRL+A then F9). If it works for you could probably merge to fax yourself. It works here in principle. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Lisa B. wrote: Hi Graham, Thanks for your help. I'm not sure I adequately (or correctly) explained what I'm trying to do. We are a nonprofit that needs to send out a questionaire (word document) to about 400 - 500 people to update our database, and include their page to update along with the letter/questionaire. We plan to use a fax blast service, to avoid having to hand fax each questionaire as we did last year. I need to supply the fax service with the word document (letter/ questionaire) and the source file (excel or access) so they can fax to correct source. The fax service will "do" the actual merge. My thought was to add a column to the excel document, and insert the pdf file: (columns -- Name/Fax Number/PDF) so it is just another field on the mail merge document. That way the output merge would contain the document with the correct pdf as page two (or whatever). Not sure your idea would work, but perhaps I'm wrong. Any other ideas? I asked the same question in the excel group. Best, Lisa On Mar 27, 2:37 am, "Graham Mayor" wrote: You could probably conditionally insert a PDF object in your merge document. Insert a link to the object and wrap it in the field construction. You would end up with something like: { IF{ Mergefield Fieldname } = "Condition" "{ LINK AcroExch.Document.7 "D:\\Path\\Filename1.pdf" "" \a \f 0 \p }" "{ LINK AcroExch.Document.7 "D:\\Path\\Filename2.pdf" "" \a \f 0 \p }" } This would insert filename1.pdf when the condition is met and filename2.pdf when not. -- Graham Mayor - Word MVP My web sitewww.gmayor.com Word MVP web sitehttp://word.mvps.org |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I print 3 copies of page 1 in a 3 page mail merge? | Mailmerge | |||
mail merge incorrect page lengths with custom page size | Mailmerge | |||
30 page mail merge labels only prints one page? | Mailmerge | |||
30 page mail merge labels only prints one page? | Mailmerge | |||
only 1 page in mail merge...why? | Mailmerge |